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 |