Question
A study was commissioned to investigate the characteristics of employees at a major business. Data was collected on 60 employees, and the following variables were
A study was commissioned to investigate the characteristics of employees at a major business. Data was collected on 60 employees, and the following variables were recorded. working out to be shown on EXCEL.
Column 1GenderWhat is your gender?
Column 2AgeHow old are you?
Column 3SalaryWhat is your yearly salary (before tax)?
Column 4OvertimeHow much overtime do you work each week?
Column 5Job TypeWhat department do you work in?(1 = Purchasing,
2 = Marketing/Human Resources, 3 = Accounting).
(a)Calculate a 95% confidence interval for the unknown population mean amount of overtime each employee works each week.
(b)The company has been accused of gender inequality. Test, at the 5% level of significance, whether the average salary of males is greater than the average salary of females. [You may assume that the unknown population standard deviations for male and female salaries are equal].
(c)Test, at the 5% level of significance, whether Job Type of an employee is dependent on the employee's Gender.
DATA SET :
G AGE SALARY O/T JOB TYPE
F 35 50000 3 2
F 37 69000 5 1
M 58 81000 3 1
F 25 41000 9 2
M 56 74000 3 1
M 34 45000 2 2
F 28 43000 0 2
F 21 30000 3 2
F 24 42000 8 2
M 43 54000 3 1
F 26 36000 8 2
F 21 50000 10 3
M 23 47000 3 1
M 29 32000 12 3
F 34 49000 4 3
F 49 83000 5 2
F 37 59000 1 2
M 23 35000 7 1
F 19 42000 10 3
M 34 56000 2 3
M 32 40000 10 2
F 28 41000 2 2
M 25 41000 11 3
M 48 60000 4 1
M 40 38000 2 3
F 22 26000 1 1
M 28 36000 6 2
F 32 70000 3 2
F 35 46000 2 2
F 40 48000 1 1
F 39 78000 2 3
M 19 39000 9 2
F 22 46000 6 2
F 31 43000 3 1
M 49 49000 3 3
F 30 40000 4 2
M 45 62000 0 2
F 18 29000 12 1
M 32 43000 5 3
M 18 48000 12 3
M 32 47000 7 3
F 43 65000 2 1
M 27 50000 10 1
F 22 27000 5 2
M 49 47000 4 1
F 36 58000 0 1
F 28 31000 10 3
M 57 86000 2 3
F 53 65000 7 2
F 27 32000 5 2
F 26 64000 7 1
M 40 40000 5 2
M 35 54000 4 2
F 33 68000 2 2
F 49 49000 2 2
M 22 59000 8 3
M 31 30000 5 1
M 18 45000 10 3
F 30 47000 2 2
F 32 44000 9 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started