MIS171 : Business Analytics : Scenario - Management Assignment

Internal Code : MAS592

Management Assignment

Scenario : You are playing the role of Anil Kumble, Senior Analyst at Kwuntongcorp. Mary Kohli , Human Resources Manager at Kwuntongcorp, has written to you again regarding the Kwuntongcorp dataset. Her memorandum is reproduced below. The basis for your analysis is again the file “Kwuntongcorp.xlsx”. For Attention: Anil Kumble, Senior Analyst From: Mary Kohli, Human Resources Manager Regarding: Further analysis of dataset Dear Anil Thank you for your earlier responses. In order for me to finalise the employee profile required by senior management, I need the following information. 1. An estimate of : a. the mean salary for ALL Kwuntongcorp employees. b. the proportion of ALL Kwuntongcorp employees who are (very and moderately) satisfied with their job. 2. The mean salary across the industry is $28,500. Senior management claims that our employees earn more than the industry average.Check the validity of this claim. 3. Senior management also believes that the proportion of (moderately and very) satisfied employees is at least 92%.Is this true? 4. Is there is a significant difference in the mean salary of ALL male and ALL female employees? 5. I am concerned that a sample of 450 Kwuntongcorp employees may not provide us with very accurate estimates. For future surveys,what sample size would be needed in order to be able to estimate : a. the mean salary for ALL Kwuntongcorp employees to within $900, with 95% confidence? b. the proportion of ALL Kwuntongcorp employees who are (very and moderately) satisfied with their job to within 2%, with 95% confidence? I look forward to your response. Regards Mary Wong Questions : 1.You will need to apply techniques you have learned/will learn during lectures and tutorials in Weeks 7 and 8.You will also need to use the results of your assignment 1 analysis as the basis for your answers to assignment 2. 2.The HR Manager has asked for a number of tasks to be done. The following guidelines for each question should be followed: 1. (a) An estimate of the mean salary for ALL Kwuntongcorp employees. You will need to calculate an estimate of the mean salary for ALL Kwuntongcorp employees. You will need to be able to interpret your result as demonstrated in the relevant lecture and tutorial. 1. (b) The proportion of ALL Kwuntongcorp employees who are (very and moderately) satisfied with their job. You will need to first determine the relevant sample proportion from your data then calculate the estimate of the proportion of ALL Kwuntongcorp employees who are(very and moderately) satisfied with their job 2. The mean salary in this industry is $28,500. Senior management claims that Kwuntongcorp employees earn more than the industry average.Check the validity of this claim. You will need to test senior management’s claim using the appropriate technique. You will need to be able to interpret your result as demonstrated in the lecture and tutorial. 3. Senior Management also believes that the proportion of (moderately and very) satisfied employees is at least 92% . Is this true? You will need to test if senior management’s claim is true by using the appropriate technique. You will need to be able to interpret your result as demonstrated in the lecture and tutorial. 4. Is there a significant difference in the mean salary between ALL male and ALL female employees? You will need to find out if there is a significant difference in the mean salary between ALL male and ALL female employees. You will need to be able to interpret your result as demonstrated in the relevant lecture and tutorial, depending on which approach you have chosen.