A study was commissioned to investigate the characteristics of employees at a major business. Data was collected on 60 local employees and the following variables recorded.

Column 1LocationWhich city are you working in? (Melbourne, Sydney)

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, 3=Accounting)

QUESTION 2(4 + 4 = 8 marks)

a.Calculate a 95% confidence interval for the unknown population mean amount of salary of employees.

b.Test, at the 1% level of significance, whether the average overtime hours are more than 5?

Can you calculate and explain how to calculate the mean amount of salary of employees and the average overtime hours more than 5 at 1% level?

200032 STATISTICS FOR BUSINESS ASSIGNMENT DATA SET: 201 THIS DATA SET NUMBER SHOULD APPEAR AT THE BEGINNING OF YOUR ASSIGNMENT FAILURE TO COMPLY WITH THIS REQUEST WILL RESULT IN A 10$ PENALTY Location Age Salary Overtime Job Type Sydney 34 8600 Sydney 22 33000 Sydney 36 39000 Melbourne 32 36000 Melbourne 41 46000 Sydney 23 47000 Sydney 18 47000 13 Sydney 26 57000 11 Sydney 46 66000 Melbourne 22 53000 Sydney 18 26000 Melbourne 33 71000 Sydney 37 44000 sydney 37 64000 Melbourne 31 46000 Melbourne 50 69000 Sydney 26 44000 Sydney 33 38000 Sydney 24 36000 Melbourne 35 52000 Sydney 22 38000 Melbourne 22 45000 Sydney 33 64000 Sydney 33 55000 Sydney 18 57000 sydney 26 67000 Sydney 24 47000 Melbourne 44 61000 Melbourne 50 70000 Melbourne 24 33000 N N N W N W N N P W W H W H W N W N N W H N N H N W H H N W H W H N N N N N N W W N H H H N N N N W W H W N N N H N P N Melbourne 32 42000 Sydney 37 50000 Sydney 40 84000 Melbourne 48 70000 Melbourne 30 35000 Sydney 27 34000 Melbourne 27 50000 Melbourne 53 78000 Sydney 19 35000 Sydney 28 37000 Melbourne 41 44000 Sydney 22 29000 Melbourne 19 42000 Melbourne 41 57000 Sydney 25 46000 Sydney 28 53000 Melbourne 40 57000 Melbourne 20 51000 Melbourne 19 38000 Sydney 27 28000 Melbourne 30 37000 Melbourne 21 39000 Sydney 34 40000 Melbourne 51 51000 Sydney 27 36000 Sydney 22 46000 UWUINMOWOD Melbourne 37 33000 Melbourne 46 58000 Sydney 40 50000 Sydney 18 40000