1. Create a new tab labeled MMM and set up an empty table like the one in the Data tab. Populate the table by linking the cells to the data in the Data tab. Then, complete the following:
   1. Figure out the mean, median, and mode of the hourly wages. Then multiply the total project hours times each one.
   2. Write a rationale statement for how you calculated the mean, median, and mode.
   3. Write a summary describing how each measure (mean, median, and mode) could be used for this project. Include your recommendation on which is the most appropriate and why.

 

Transcribed Image Text:

A B D E F H 1 Employee's Name Hourly Pay Rate Mon Tue Wed Thu Fri Total Hrs. Worked Gross Pay Status 2 Smith $8.95 8 8 8 8 8 40 $358.00 C Cost Incurred by Full Time Employee Formula $3,040.00 3 Rodriquez $11.00 8 8 8 8 8 40 $440.00 C 4 Daniel $14.00 8 8 8 8 8 40 $560.00 C 3040 5 Eli $16.00 8 8 8 8 8 40 $640.00 F Cost Incurred by Contract Employees 6 Lee $19.00 8 8 8 8 8 40 $760.00 C $3,118.00 3118 7 Kim $20.00 8 8 8 8 8 40 $800.00 F 8 Buster $25.00 8 8 8 8 40 $1,000.00 C 9Green $40.00 8 8 8 8 8 40 $1,600.00 F A B D E F H 1 Employee's Name Hourly Pay Rate Mon Tue Wed Thu Fri Total Hrs. Worked Gross Pay Status 2 Smith $8.95 8 8 8 8 8 40 $358.00 C Cost Incurred by Full Time Employee Formula $3,040.00 3 Rodriquez $11.00 8 8 8 8 8 40 $440.00 C 4 Daniel $14.00 8 8 8 8 8 40 $560.00 C 3040 5 Eli $16.00 8 8 8 8 8 40 $640.00 F Cost Incurred by Contract Employees 6 Lee $19.00 8 8 8 8 8 40 $760.00 C $3,118.00 3118 7 Kim $20.00 8 8 8 8 8 40 $800.00 F 8 Buster $25.00 8 8 8 8 40 $1,000.00 C 9Green $40.00 8 8 8 8 8 40 $1,600.00 F