Business Analytics - Case Study

Business Analytics - Case Study

Assignment Two

Background

This assignment requires you to perform inferential techniques (based on Lectures and Tutorials in Weeks 7 and 8) on the Kwuntongcorp dataset and then  report on your findings.

There are two (2) parts to this assignment:

Part 1: Data Analysis (calculations done by hand, with help from Excel)

Part 2: A reply to Mary Kohli’s memorandum addressing her questions and demonstrating how you have reached your conclusions.

The assignment is to be completed in groups of two or three.Groups are only to be comprised of students from the same class.

Scenario

As for Assignment 1, 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”.

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 :
   1.  the mean salary for ALL Kwuntongcorp employees.

1.  the proportion of ALL Kwuntongcorp employees who are (very and moderately) satisfied with their job.

1. 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.

1. Senior management also believes that the proportion of (moderately and very) satisfied employees is at least 92%.Is this true?

1. Is there is a significant difference in the mean salary of ALL male and ALL female employees?

1.  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 :

1. the mean salary for ALL Kwuntongcorp employees to within $900, with 95% confidence?
2.  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

ACTIVITIES

Part 1 : ANALYSIS

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.

NOTE : For all confidence intervals and related calculations you can assume that a 95% confidence level is appropriate. For hypothesis tests a 5% level of significance (α = 0.05) is appropriate.

Part 2: RESPONSE TO MARY

This should be in the form of a memorandum(as for Assignment 1).

GUIDELINES

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.

HINT: The Week 7 lecture and tutorial may be helpful.

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.

HINT: The Week 7 lecture and tutorial may be helpful.

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.

HINT: The Week 8 lecture and tutorial may be helpful.

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.

HINT: The Week 8 lecture and tutorial may be helpful.

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.

HINT: The Week 7 lecture and tutorial may be helpful.

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  etc.--?

You will need to calculate required sample sizes to meet the specifications described in Q5a and Q5b.

HINT: The Week 7 lecture and tutorial may be helpful.

SUBMISSION :

As for Assignment 1.

For the electronic submission there will be a link in Moodle in the MIS171 portal(Week 10).

As for Assignment 1,the maximum number of pages for the analysis is 8 and for the memorandum is 2.