1. An HIM supervisor timed his staff for eight hours during the workday to determine the average number of inpatient records coded in one hour. Using the findings in theExcel data set to answer the following questions.

1. Using Excel, find the mean, median, mode, range, and standard deviation for each of the Coding Professionals A-D.Round to two decimal places. Include your Excel table here. (8 pts)

1. Based on the statistics you just found for each professional, which professional is doing the most efficient job? Base your answer on more than one statistic. (2 pts.)

1. Using Excel, find the overall mean, median, mode, range, and standard deviation for each hour.Round to two decimal places. (2 pts)