Statistics employee retention case, the questions are the following 1. Assume that the population proportion of employees that had left the company prior to the time this dataset was established was...

1 answer below »
Statistics employee retention case,
the questions are the following

1. Assume that the population proportion of employees that had left the company prior to the time this dataset was established was 20%. Suppose that you surveyed 117 employees, what is the probability of observing that 40% or more left company if the true population proportion is 20%? Is it reasonable to assume that this could be likely, or does it appear that a 40% exodus would be unusual?


2. Given the survey data that was collected, calculate the 95% confidence interval for the proportion of employees that left the company. Interpret this interval. If you believed that the true population proportion of employees that left the company is 20%, is there any evidence to suggest that you were wrong?


3. Create a classification tree with “Left the Company” as your Y. Split the tree several times so that you can clearly see if there are any continuous variables that might be a surrogate measure for whether a person left the company or not. Cut and paste your tree and report on what that continuous variable is.


4. Calculate the 95% confidence interval for the satisfaction rating. Interpret this interval. If you believed that the satisfaction rating was .80, is there any reason to believe that you are wrong?


5. With Satisfaction Rating as your Y, test to see if the number of projects might be related to the mean Satisfaction Rating. In order to do this, place all of the employees that had 6 or more projects in one group and all those that had 5 or less in another group. Then see if there is a significant difference in Satisfaction Rating when comparing the two groups.


6. With the Satisfaction Rating as your Y, test to see if whether a person that had an accident results in a significant lesser Satisfaction Rating than an employee that did not have an accident on the job.


7. Split the data set into two groups, one with the number of years at 5 or more, and the other group with 4 or less. Using these two groups, test to see if the mean Satisfaction Rating of those with a longer tenure is different than the mean Satisfaction rating of the lesser tenure.


8. Perform a Graphical Summary (Stat>Basic Stats>Graphical Summary) of the Monthly hours data. Report on the mean, standard deviation and shape of the data.


9. If you were to split the data set based on 195 hours, is there any evidence to suggest that the number of hours worked has an influence on satisfaction rating? Test to see if the mean Satisfaction Rating of those working more hours is significantly less than those working less than 195 hours.


10. For the scenario in Problem 9, perform a hypothesis test to determine if there is any evidence to suggest that the variability in Satisfaction Rating for the employees that worked less than 195 hours is different than the variability in Satisfaction Rating of the folks that worked more than 195 hours.



Answered Same DayFeb 19, 2021

Answer To: Statistics employee retention case, the questions are the following 1. Assume that the population...

Rajeswari answered on Feb 20 2021
132 Votes
50959 assignment
Question no.3
We find (sheet 3) excel data for left for company alone. We find that majority of those who left did not get promotion. So not getting p
romotion is one reason for leaving. Satisfaction level may be one reason. Comparison of two averages shown in excel
Other variables namely tenure, last evaluation, accident at work do not cause much significant difference in the average.
Question no.4
    
    
    
    satisfaction_level
    
    
    
    
    
    
    
    
    Mean
    0.481731
    
    
    
    Standard Error
    0.036002
    
    
    
    Median
    0.44
    
    
    
    Mode
    0.44
    
    
    
    Standard Deviation
    0.259613
    
    
    
    Sample Variance
    0.067399
    
    
    
    Kurtosis
    -0.94066
    
    
    
    Skewness
    0.123131
    
    
    
    Range
    0.81
    
    
    
    Minimum
    0.09
    
    
    
    Maximum
    0.9
    
    
    
    Sum
    25.05
    
    
    
    Count
    52
    
    
    
    Confidence Level(95.0%)
    0.072277
    
    
    
    
    
    Mean satisfaction
    0.4817
    
    
    
    
    
    
    
    confidence interval lower bound
    0.409454
    Upper bound
    
    
    0.554007
Since 0.80 does not lie within this interval my belief that it was 0.80 was wrong.
Question 5
To find out the relation between satisfaction rating and number of projects
    H_0: Two satisfaction levels are equal
    
    
    
    H_a: Two Satisfaction levels ae not equal
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    t-Test: Two-Sample Assuming Unequal Variances
    
    
    
    
    
    
    
    
    
    
     
    Variable 1
    Variable 2
    
    
    
    
    Mean
    0.4828
    0.455
    
    
    
    
    Variance
    0.070119
    5E-05
    
    
    
    
    Observations
    50
    2
    
    
    
    
    Hypothesized Mean Difference
    0
    
    
    
    
    
    df
    50
    
    
    
    
    
    t Stat
    0.735828
    
    
    
    
    
    P(T<=t)...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here