We're Open
+44 7340 9595 39
+44 20 3239 6980

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

For Attention:                   Anil Kumble, Senior Analyst                                                                                        25/4/2016

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

  


Price: £ 99

100% Plagiarism Free & Custom Written, Tailored to your instructions

Details

  • Title: Business Analytics - Case Study
  • Price: £ 99
  • Post Date: 2021-07-27T04:16:21+00:00
  • Category: Case Study
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Business Analytics - Case Study Business Analytics - Case Study
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Writing is not my field. I take help from this website for my accounting assignment. The work is good and I scored good grades in it. Thank you from the bottom of my heart.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I ordered the literature review for my research project in rush delivery. I was not expecting that they would complete my order 2 hours before my chosen time. The quality is also nice. Thank you for help.

Write your Feedback

Your email address will not be published. Required fields are marked *