Instructions

Convert hourly wages to annualized salaries and use the entire data set to calculate the mean and median salaries of the data set using the attached spreadsheet. Download and save the spreadsheet to your computer. Then use it to calculate your answers to the questions at the bottom of the spreadsheet using the data provided.

NOTE: This assignment requires the use of spreadsheet software, such as Microsoft Excel. If you do not have MS Excel on your computer:

• you can upload the file to your Google Docs account provided by the College and work from there.
• Google Docs is accessible from the MyPima website. The icon for it is located next to the Mail icon on the upper right side of the page.
• To work with the spreadsheet in Google Docs, save the Application_Assignment2.xls file to your computer and then use the Upload function of Google Docs to upload and open the file.
• To submit it to the online course, reverse the process go to File/Download As/Excel in Google Docs, save the file to your computer, and then upload it to the course via the Dropbox link.

This is all the information I received for this question.

Font Formatti Alignment Number E28 B G H Annual Salary Annual Salary Mean Median 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 14 Human Resources Generalist 15 Human Resources Specialist 16 Human Resources Generalist 17 Human Resources Assistant 18 Human Resources Generalist 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 19 20 21 1. Convert all HR Assistant hourly wages to annualized salaries 22 23 24 2. What is the arithmetic mean of Column D? 25 26 27 3. What is the median salary in Column D? Font Formatti Alignment Number E28 B G H Annual Salary Annual Salary Mean Median 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 14 Human Resources Generalist 15 Human Resources Specialist 16 Human Resources Generalist 17 Human Resources Assistant 18 Human Resources Generalist 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 19 20 21 1. Convert all HR Assistant hourly wages to annualized salaries 22 23 24 2. What is the arithmetic mean of Column D? 25 26 27 3. What is the median salary in Column D