Chapter 1 – Problem 22-Refer to the Lincolnville School District bus data, which report information on the school districtâ€™s bus fleet
a.Which of the variables are qualitative and which are quantitative?
b. Determine the level of measurement for each variable.
Chapter 2 – Problem 53-Refer to the Lincolnville School District bus data. Select the variable referring to the number of miles traveled since the last maintenance, and then organize these data into a frequency distribution.
a. What is a typical number of miles traveled? What is the range?
b. Comment on the shape of the distribution. Are there any outliers in terms of miles driven?
c. Draw a cumulative relative frequency distribution. Forty percent of the buses were driven fewer than how many miles? How many buses were driven less than 10,500 miles?
d. Refer to the variables regarding the bus manufacturer and the bus capacity. Draw a pie chart of each variable and write a description of your results.
For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.
Submit output in one Excel file