Convert hourly wages to annualized salaries and use the resulting data set (15 salaries) to calculate the mean and median salaries. Then calculate your answers to the questions at the bottom of the spreadsheet using the data provided. Show all your work to receive maximum credit for your answers.

Transcribed Image Text:

2 3 Job Classification 4 Human Resources Generalist 5 Human Resources Assistant 6 Human Resources Generalist 7 Human Resources Generalist 8 Human Resources Specialist 9 Human Resources Generalist 10 Human Resources Generalist 11 Human Resources Assistant 12 Human Resources Generalist 13 Human Resources Specialist Human Resources Generalist 15 Human Resources Specialist 16 Human Resources Generalist Human Resources Assistant 14 17 18 Human Resources Generalist 19 20 21 22 23 24 25 26 27 28 29 Wage $45,000.00 $10.58 per hour $50,000.00 $40,000.00 $35,000.00 $42,000.00 $47,500.00 $12.00 per hour $43,500.00 $32,000.00 $41,000.00 $37,500.00 $48,000.00 $11.25 per hour $44,500.00 1. Convert all HR Assistant hourly wages to annualized salaries. 2. What is the arithmetic mean of Column D? Annual Salary Annual Salary 3. What is the median salary in Column D? Mean Median 2 3 Job Classification 4 Human Resources Generalist 5 Human Resources Assistant 6 Human Resources Generalist 7 Human Resources Generalist 8 Human Resources Specialist 9 Human Resources Generalist 10 Human Resources Generalist 11 Human Resources Assistant 12 Human Resources Generalist 13 Human Resources Specialist Human Resources Generalist 15 Human Resources Specialist 16 Human Resources Generalist Human Resources Assistant 14 17 18 Human Resources Generalist 19 20 21 22 23 24 25 26 27 28 29 Wage $45,000.00 $10.58 per hour $50,000.00 $40,000.00 $35,000.00 $42,000.00 $47,500.00 $12.00 per hour $43,500.00 $32,000.00 $41,000.00 $37,500.00 $48,000.00 $11.25 per hour $44,500.00 1. Convert all HR Assistant hourly wages to annualized salaries. 2. What is the arithmetic mean of Column D? Annual Salary Annual Salary 3. What is the median salary in Column D? Mean Median