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

1. 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?