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

\f