STA200 Managerial Statistics
STA200 Managerial Statistics
Data Analysis Assignment (Group Project)
Date Due: Refer to syllabus.
Total Mark: 60
Files Required:
Worth: 15% of final assessment
Random Sampler Generator.xls; EDA_Stats.xls
This assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!
For this assignment you will examine data obtained from a small private company that currently employs 192 people. Each year this company completes a review of its employee's salaries. Information on several variables is collected including gender, department worked in, years at the business, beginning salary, current salary, and a measure of initial experience of the employee upon commencing work for the company.
The higher the score, the more experience the person had when they first started. The data is contained in the file Random Sampler Generator.xls and can be described as follows: Variable
ID
Gender
StartYr
Dept
Begin$
2008$
Expernc
Position
Count
192
192
192
192
192
192
192
192
Description
The business identification number for the employee
The gender of the employee
The starting year of the employee
The department of the employee coded as a number
The starting salary of the employee
The current salary (2008) of the employee
The "experience variable" value when the person started at the business
The current position (or level of responsibility) of the employee; senior management, departmental head, general staff
Before you begin your analysis you are required to take a random sample of 140 from the 192 cases in the file. To do this you need to use the file Random Sampler
Generator.xls. Your tutor will show you how this can be done in EXCEL. The statistical analysis, outlined below, is to be based on this sample of 140. Make sure to
Data Analysis Assignment (Group Project)
Date Due: Refer to syllabus.
Total Mark: 60
Files Required:
Worth: 15% of final assessment
Random Sampler Generator.xls; EDA_Stats.xls
This assignment requires an amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late!! Each question carefully describes what you are required to do so please follow these carefully!
For this assignment you will examine data obtained from a small private company that currently employs 192 people. Each year this company completes a review of its employee's salaries. Information on several variables is collected including gender, department worked in, years at the business, beginning salary, current salary, and a measure of initial experience of the employee upon commencing work for the company.
The higher the score, the more experience the person had when they first started. The data is contained in the file Random Sampler Generator.xls and can be described as follows: Variable
ID
Gender
StartYr
Dept
Begin$
2008$
Expernc
Position
Count
192
192
192
192
192
192
192
192
Description
The business identification number for the employee
The gender of the employee
The starting year of the employee
The department of the employee coded as a number
The starting salary of the employee
The current salary (2008) of the employee
The "experience variable" value when the person started at the business
The current position (or level of responsibility) of the employee; senior management, departmental head, general staff
Before you begin your analysis you are required to take a random sample of 140 from the 192 cases in the file. To do this you need to use the file Random Sampler
Generator.xls. Your tutor will show you how this can be done in EXCEL. The statistical analysis, outlined below, is to be based on this sample of 140. Make sure to