Question: You are looking at labor costs for a construction project using eight employees: The employees names are Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and

You are looking at labor costs for a construction project using eight employees:
The employees names are Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green.
Each employee worked eight hours a day for five days.
The employees wages per hour are as follows:
Smith: $8.95
Rodriguez: $11
Daniel: $14
Eli: $16
Lee: $19
Kim: $20
Buster: $25
Green: $40
Green, Kim, Eli, and Lee are full-time employees, and the others are contract employees.
Set up spreadsheets to address the analysis objectives.
Use the SUMIF function to sum costs correctly.
Use a pivot table and pie chart that display the correct information.
Make sure the programming correctly calculates the mean, median, and mode.
Write a summary about the differences between how the mean, median, and mode can be used, and provide a recommendation.
Write a rationale statement that fully addresses the programming decision

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 General Management Questions!