Honors Project: Group Comparisons
You are a statistician hired by a company owner for data analysis of employee records. For your first assignment, the owner wants you to find and compare data for full-time employees in the sales department and full-time employees in the advertising department.
|Name: fernando pirela |Date: 05/26/12 | |Score |
You will find the necessary employee data in the Excel spreadsheet titled Company Data. Download and open the spreadsheet, which lists data for all full-time employees. Employees 001 through 014 are all the employees in the sales department and employees 045 through 062 are all the employees in the advertising department.
Find and compare the mean salaries and mean ages of the employees in the sales and advertising departments. Explain to the owner how these values could be misleading.Answer:
the mean for the salaries of the sales department is : 42.5
the mean for the ages os the sale department is : 33.8
the mean for the salaries of the advertising department is: 45.3
the mean for the ages of the advertising department is : 42.1
Find and compare the standard deviations of the salaries and ages of the employees in the sales and advertising departments. Tell how you would you explain the meaning of these values when you present them to the owner.Answer:
the deviations for the salaries of the sales department is:16.6
the deviations for the ages of the sales department is: 7.1
the deviation for the salaries of the advertising department is: 17.6
Please join StudyMode to read the full document