-Calculate the average pay and count how many employees have worked for the hospital for over five years. (Attaches is the excel sheet picture with data info => look at part 1 and part 2) -Determine the average hourly wages for housekeeping using the DAVERGAE function ~In the Excel sheet, on rows 26-27 enter the criteria and a DAVERAGE function to determine the average wage for Housekeeping. Apply accounting number format to the result. -Count all the number of employees that were hired prior 1/1/2010 using the DCOUNT function ~In the Excel sheet, on rows 29-33 enter the criteria and a DCOUNT function to count the number of employees in each classification hired prior to 1/1/2010 B23∞09AWN -257891011121314151617181920AEmp #101112131415161718192021222324252627fx22.2BCFacilities Payroll DataHourly RateClassification$19.80 Housekeeping$22.80 Facilities Service$19.80 Housekeeping$20.40 Housekeeping$23.40 Facilities Service$19.20 Laundry$20.40 Housekeeping$23.40 Facilities Service$19.20 Housekeeping$18.00 Maintenance$22.20 Facilities Service$21.60 Maintenance$21.60 Maintenance$22.80 Maintenance$21.90 Facilities Service$19.20 Housekeeping$18.60 Laundry$22.20 MaintenanceDESupervisorHire Date6/22/2009 Juarez10/15/2012 Johnson5/5/2013 Juarez5/12/2014 Juarez8/12/2010 Johnson1/15/2008 Juarez1/18/2009 Juarez3/8/2003 Johnson6/1/1995 Juarez12/31/2009 Ackerman11/1/2013 Johnson7/21/1998 Ackerman2/15/2012 Ackerman4/22/1996 Ackerman9/7/1998 Johnson3/4/2010 Juarez5/23/2013 Juarez8/1/1998 AckermanFShiftNightDayDayAfternoonAfternoonDayAfternoonNightDayNightNightDayNightDayDayNightDayAfternoon 2122232425262728293031323334282930Average hourly wage for Housekeeping$21.60 Facilities Service$18.60 Laundry$22.20 Facilities Service5/12/2012 Johnson7/11/2013 Juarez7/3/1998 JohnsonAfternoonDayDay

Emp#Hourly RateClassificationHire…

Answered: Calculate the average pay and count how…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

-Calculate the average pay and count how many employees have worked for the hospital for over five years. (Attaches is the excel sheet picture with data info => look at part 1 and part 2)

-Determine the average hourly wages for housekeeping using the DAVERGAE function

~In the Excel sheet, on rows 26-27 enter the criteria and a DAVERAGE function to determine the average wage for Housekeeping. Apply accounting number format to the result.

-Count all the number of employees that were hired prior 1/1/2010 using the DCOUNT function

~In the Excel sheet, on rows 29-33 enter the criteria and a DCOUNT function to count the number of employees in each classification hired prior to 1/1/2010