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: $
Rodriguez: $
Daniel: $
Eli: $
Lee: $
Kim: $
Buster: $
Green: $
Green, Kim, Eli, and Lee are fulltime 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
