Math Part One

Graded Assignment

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.

(10 points)

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:

sales department

the mean for the salaries of the sales department is : 42.5

the mean for the ages os the sale department is : 33.8

advertising department

the mean for the salaries of the advertising department is: 45.3

the mean for the ages of the advertising department is : 42.1

(20 points)

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:

sales department

the deviations for the salaries of the sales department is:16.6

the deviations for the ages of the sales department is: 7.1

advertising department

the deviation for the salaries of the advertising department is: 17.6

|Score |
| |
|Score |
|