Question 1 The manager of an automobile showroom studied the time spent by each salesperson interacting with the customer in a month apart from the other jobs assigned to them. The data in hours are...

Can you please make excel steps. Thanks

Extracted text: Question 1 The manager of an automobile showroom studied the time spent by each salesperson interacting with the customer in a month apart from the other jobs assigned to them. The data in hours are given below. 17 13 18 16 20 24 15 19 19 12 10 16 26 27 13 23 17 15 24 20 14 21 26 24 Using classes 10-13, 14-17, and so on, show: a. The frequency distribution. b. The cumulative frequency distribution. c. The proportion of salesperson who spent 13 hours of time or less with the customers. d. Prepare a histogram. e. Comment on the shape of the distribution in the histogram you prepared in part d.