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

Class	Frequency	Relative Frequency	Cumulative Frequency	Cumulative Relative Frequency
1013
1417
1821
2225
2629
Total

2. Using the relevant functions in Excel, complete the following tasks:

• Compute the mean, median, mode, and geometric mean using Excel functions.
• What are the variance, standard deviation, and coefficient of variation of the data.
• What are range of the data, the first quartile? the third quartile? and interquartile?
• What is the z-score if the time spent by the salesperson?