Greendelivery.com has recently decided to review the weekly mileage of the delivery vehicles used to deliver shopping purchased online to customer homes from a central parcel depot. The sample data...

Greendelivery.com has recently decided to review the weekly mileage of the delivery vehicles used to deliver shopping purchased online to customer homes from a central parcel depot. The sample data collected (Table 2.20) is part of the first stage in analysing the economic benefit of potentially moving all vehicles to biofuels from diesel.

(a) Use Excel to construct a frequency distribution and plot the histogram with class intervals of 10 and classes 75–84, 85–94 . . . 175–184. Comment on the pattern in mileage travelled by the company vehicles.

(b) Use the raw data to determine the mean, median, standard deviation, and SIQR.

(c) Comment on which measure you would use to describe the average and measure of dispersion. Explain using your answers to (a) and (b).

(d) Calculate the measure of skewness and kurtosis, and comment on the distribution shape.