Question: 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

  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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!