Perform inferential techniques on the kwuntongcorp dataset

Assignment Help Applied Statistics

Reference no: EM131048379

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:

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

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

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%.Isthis 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

ACTIVITIES

Part 1 : ANALYSIS

You will need to apply techniques you have learned/will learn during lectures and tutorials in Weeks7 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 guide lines 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 Week7 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.

Reference no: EM131048379

Questions Cloud

Describe what is happening in skin in response to sunlight : Going out into the sun stimulates quite a bit of activity in the skin, especially on a hot summer day. Describe what is happening in the skin in response to the sunlight.

Find the gross domestic product per capita for each country : To find the Gross Domestic Product per Capita (PPP) for each country, use the list found at: https://www.cia.gov/library/publications/the-world-factbook/rankorder/2004rank.html

Identify the estimated multiple regression equation : Diamonds. Use the data in Table 28.4 (page 28-35) to fit the multiple regression model with two explanatory variables, Carat and Depth, to predict the Total Price of diamonds. Don't forget to include the interaction term in your model.

Advice to the business owner on how business has performed : Advice to the business owner on how their business has performed for the month of March - recommendations to improve the profitability of the business.

Perform inferential techniques on the kwuntongcorp dataset : MIS171Business Analytics - perform inferential techniques (based on Lectures and Tutorials in Weeks 7 and 8) on the Kwuntongcorp dataset and then report on your findings - what sample size would be needed in order to be able to estimate :

Calculate maximum efficiency of solar distillation system : From the calculated heat transfer rate of the evaporating water, calculate the maximum efficiency of the solar distillation system on a 1 m2 piece of glass for a solar flux of 800 W/m2. This is a maximum, because the vapor pressure of sea water is ..

A simple linear regression model : Diamonds. Consider the diamond data of which Table 28.4 (page 28-35) is an excerpt. We are interested in predicting the total price of a diamond. Fit a simple linear regression model using Carat as the explanatory variable.

Write summery of the documentary the rise of isis : Write summery of the documentary The Rise of ISIS. I am looking for in this assignment is similar to other video/review assignments. A summary of the video, your thoughts, its significance, etc...

Multiple regression model for predicting selling price : Florida real estate. The table on text page 614 gives the appraised market values and actual selling prices (in thousands of dollars) of condominium units sold in a beachfront building over a 93-month period.

User Account

All Pages