Employees profile
In the Word report, please include your name, student ID, the name of the data
set, and your questions.
1. Calculate the mean, median, and variance of annual salaries for (a) all
employees, (b) IT department, and (c) Sales department.
2. Given the dataset, estimate the average annual salary for all managers at
confidence interval level of 1%.
3. Are there any differences between the bonus between the Blacks and Whites?
1. (a) all employees
Mean: 113122,3303
Median: 96511,5
Variance of annual salaries: 2866127908
(b) IT department
Mean: 107349,3542
Median: 108127
Variance of annual salaries: 758026312,6
© Sales department
Mean: 111049,8571
Median: 96345
Variance of annual salaries: 2837405679
2. Given the dataset, estimate the average annual salary for all managers at
confidence interval level of 1%.
All managers conclude: Computer Systems Manager, Engineering Manager,
Manager, Sr. Manager.
The average annual salary for all managers at confidence interval level of 1%
ranges from 118245,6 $ to 125471,9 $.
3. Are there any differences between the bonus between the Blacks and Whites?
We define in excel:
1 for Black
2 for Caucasian
Hypothesis:
H0: There are no differences between the bonus between the Blacks and Whites
H1: There are differences between the bonus between the Blacks and Whites.
Use ANOVA test in SPSS:
We have following photo:
It can be concluded from the ANOVA table that:
p-value = 0,720 > 0,05
Fail to reject H0
There are no differences between the bonus between the Blacks and
Whites.