Cycling frequency data

Analysts for the UK Department for Transport conducted a survey to determine how often citizens ride their bicycles. Citizens were asked if they rode their bicycles one time per month, one time per week, three times per week, and five times per week. For each town or local authority, the analysts recorded the total number of people who responded to the survey and the number of people who indicated each frequency of cycling. The analysts would like to simplify the presentation of results by combining the cycling frequency categories that have similar characteristics.

You can use this data to demonstrate Cluster Variables.

Worksheet column Description
Local Authority The town or city in England
One time per month The number of people who say they cycle one time per month
One time per week The number of people who say they cycle one time per week
Three times per week The number of people who say they cycle three times per week
Five times per week The number of people who say they cycle five times per week