The distance travelled (in km) by a courier service motorcycle on 50 trips was recorded by...

 

Transcribed Image Text:

The distance travelled (in km) by a courier service motorcycle on 50 trips was recorded by the driver. 24 30 20 28 23 17 16 21 20 18 19 22 26 31 21 13 15 20 18 20 34 29 24 23 25 17 35 29 19 10 17 11 14 15 27 18 8 22 13 28 26 18 16 27 22 25 14 24 (a) Define the random variable and the data type. (b) Use Excel's Data > Data Analysis > Histogram option to prepare: (i) a numeric frequency distribution (use bin ranges: 10, 15, 20, 25, 30 and 35) (ii) a percentage frequency distribution (iii) a histogram of the distances travelled by the courier per trip. (c) From the results, determine: the percentage of deliveries that were between 25 km and 30 km the percentage of deliveries within a 25 km radius (iii) the percentage of deliveries beyond a 20 km radius (iv) below which distance 52% of the deliveries were made (v) above which distance the longest 24% of the deliveries were made. (i) (ii) d) If the company has a policy that no more than 10% of all deliveries should be more than 30 km from their depot, are they adhering to this policy? Justify your answer. The distance travelled (in km) by a courier service motorcycle on 50 trips was recorded by the driver. 24 30 20 28 23 17 16 21 20 18 19 22 26 31 21 13 15 20 18 20 34 29 24 23 25 17 35 29 19 10 17 11 14 15 27 18 8 22 13 28 26 18 16 27 22 25 14 24 (a) Define the random variable and the data type. (b) Use Excel's Data > Data Analysis > Histogram option to prepare: (i) a numeric frequency distribution (use bin ranges: 10, 15, 20, 25, 30 and 35) (ii) a percentage frequency distribution (iii) a histogram of the distances travelled by the courier per trip. (c) From the results, determine: the percentage of deliveries that were between 25 km and 30 km the percentage of deliveries within a 25 km radius (iii) the percentage of deliveries beyond a 20 km radius (iv) below which distance 52% of the deliveries were made (v) above which distance the longest 24% of the deliveries were made. (i) (ii) d) If the company has a policy that no more than 10% of all deliveries should be more than 30 km from their depot, are they adhering to this policy? Justify your answer.