Question: The ‘Ride Your Bike to Work’ Club in a nearby college town set out to promote greater use of bicycles. Their biostatistician expressed interest in measuring the progress of their work. The first survey completed from a random group of citizens asked how they got to work that morning. Responses were scored as:

Auto: 0

Bicycle: 1

Motorcycle: 2

Walking: 3

Bus: 4

Put the data in an excel spreadsheet. First, using Excel’s countif, determine the frequencies of each option. Then arrange the following scores into an appropriate frequency distribution and graph them. Calculate any measure of central tendency that are appropriate. Write a sentence or two explaining what the distribution shows.