On-time performance of workers arriving at their job in a department is an important statistic in any organization. Suppose that you wanted to find the average percent of on-time performance for workers in Department D of your organization during the past month. These data are given in Fig. 1.18.

(a) Use Excel to create a table of these data, and at the right of the table use Excel to find the sample size, mean, standard deviation, and standard error of the mean for these data. Label your answers, and round off the mean, standard deviation, and standard error of the mean to one decimal place using number format.

(b) Print the result on a separate page.

(c) Save the file as: ONTIME3