This assignment is a simulated salary survey analysis.Included in this week?’s module in Canvas is a spreadsheet (Assignment 8 – Spreadsheet.xls) displaying

  
This assignment is a simulated salary survey analysis. Included in this week’s module in Canvas is a spreadsheet (Assignment 8 – Spreadsheet.xls) displaying hypothetical salary survey data for the job of Human Resource Assistant. You are Company E in the survey. In one (1) page or less, answer the following question:

  • Calculate the market pay rate for this job. Which pay policy does your company appear to have chosen for this job? 

This assignment must be typed and submitted electronically in MS Word format (.docx or .pdf) and must be named: LastName_Assignment8. Submit your completed assignment to Assignment 8, listed in this week’s module in Canvas 

Sheet1

Company Size Industry Avg. Pay
E 500-999 Nonprofit 35000
B 101-249 Nonprofit 32000
C 51-100 Service 28000
D 0-50 Manuf. 29000
F 250-499 Service 32000
G 101-249 Manuf. 30000
H 51-100 Nonprofit 27000
I 0-50 Service 25000
J 500-999 Manuf. 35000
K 250-499 Nonprofit 34000
L 51-100 Service 30000
M 0-50 Manuf. 26000