Greendelivery.com has recently decided to review the weekly mileage of the delivery vehicles used to deliver shopping

Question:

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.

80 136 159 163 106 144 170 137 114 Table 2.20 165 138 131 136 111 145 105 152 155 159 118 93 163 123 91 131

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: