In: Math
1. What is the 95% CI for the difference between the mean starting salaries of those who stay at least three years and those who leave before 3 years? Can you say that you are 95% sure there is a difference?
| Case Study: Employee Retention at D&Y | ||||||
| Employee | Starting Salary | On Road Pct | State Univ | CIS Degree | Stayed 3 Years | Tenure | 
| 1 | 38900 | 57% | Yes | Yes | No | 11 | 
| 2 | 42300 | 68% | Yes | Yes | No | 5 | 
| 3 | 39800 | 75% | No | Yes | No | 21 | 
| 4 | 35700 | 29% | No | Yes | Yes | |
| 5 | 40400 | 71% | No | Yes | No | 19 | 
| 6 | 36400 | 62% | No | Yes | No | 18 | 
| 7 | 37300 | 41% | Yes | No | Yes | |
| 8 | 36600 | 37% | No | Yes | No | 17 | 
| 9 | 34600 | 65% | No | Yes | No | 20 | 
| 10 | 42300 | 53% | Yes | Yes | No | 16 | 
| 11 | 37800 | 73% | No | Yes | Yes | |
| 12 | 39700 | 60% | No | Yes | No | 12 | 
| 13 | 36100 | 56% | Yes | Yes | Yes | |
| 14 | 36100 | 42% | Yes | Yes | Yes | |
| 15 | 33800 | 35% | No | Yes | Yes | |
| 16 | 38900 | 36% | No | Yes | Yes | |
| 17 | 35500 | 50% | No | Yes | No | 15 | 
| 18 | 37600 | 58% | No | Yes | Yes | |
| 19 | 38100 | 78% | Yes | Yes | Yes | |
| 20 | 38300 | 16% | No | No | Yes | |
| 21 | 34600 | 29% | No | Yes | Yes | |
| 22 | 36300 | 26% | No | Yes | Yes | |
| 23 | 37200 | 59% | Yes | Yes | No | 14 | 
| 24 | 37700 | 55% | Yes | Yes | Yes | |
| 25 | 36600 | 45% | No | Yes | No | 13 | 
| 26 | 41000 | 81% | Yes | Yes | No | 9 | 
| 27 | 40800 | 111% | Yes | Yes | No | 7 | 
| 28 | 36700 | 56% | Yes | Yes | Yes | |
| 29 | 37700 | 56% | No | Yes | No | 22 | 
| 30 | 37700 | 42% | No | Yes | No | 11 | 
| 31 | 39300 | 69% | Yes | Yes | No | 16 | 
| 32 | 37500 | 50% | No | Yes | No | 18 | 
| 33 | 40000 | 69% | Yes | Yes | No | 9 | 
| 34 | 41500 | 64% | Yes | No | No | 5 | 
| 35 | 39600 | 72% | No | Yes | No | 18 | 
| 36 | 36900 | 42% | No | Yes | Yes | |
| 37 | 39500 | 62% | No | Yes | No | 5 | 
| 38 | 37800 | 20% | No | Yes | No | 23 | 
| 39 | 38600 | 57% | No | Yes | No | 8 | 
| 40 | 40600 | 70% | Yes | Yes | Yes | |
| 41 | 41600 | 63% | Yes | Yes | Yes | |
| 42 | 40800 | 44% | No | No | Yes | |
| 43 | 36200 | 68% | No | Yes | No | 31 | 
| 44 | 39600 | 59% | No | Yes | No | 10 | 
| 45 | 36100 | 56% | Yes | Yes | Yes | |
| 46 | 36100 | 42% | No | Yes | Yes | |
| 47 | 39500 | 53% | Yes | Yes | No | 17 | 
| 48 | 39100 | 38% | No | Yes | Yes | |
| 49 | 40300 | 53% | Yes | Yes | Yes | |
| 50 | 38800 | 78% | Yes | Yes | Yes | |
| 51 | 39400 | 34% | Yes | Yes | No | 27 | 
| 52 | 38400 | 23% | No | Yes | Yes | |
| 53 | 35200 | 33% | No | Yes | Yes | |
| 54 | 36100 | 24% | No | No | Yes | |
| 55 | 37100 | 44% | No | Yes | Yes | |
| 56 | 37200 | 64% | Yes | Yes | No | 23 | 
| 57 | 36800 | 46% | Yes | No | Yes | |
| 58 | 36500 | 27% | No | No | Yes | |
| 59 | 35900 | 29% | No | No | Yes | |
| 60 | 37900 | 76% | Yes | Yes | No | 14 | 
| 61 | 37900 | 58% | No | Yes | No | 26 | 
| 62 | 37900 | 28% | No | Yes | No | 14 | 
| 63 | 36700 | 37% | No | Yes | Yes | |
| 64 | 37400 | 49% | No | Yes | No | 19 | 
| 65 | 38200 | 62% | Yes | Yes | Yes | |
| 66 | 36600 | 51% | Yes | Yes | No | 7 | 
We use minitab to solve this question-
We first test is the variance equal for salaries of Leave before 3 years and Stay at least three years.
Ho : S12 = S22 Vs Ha : S12 S22
The test statistics is,
F = S12 / S22 , S12 - Larger sample variance betwwen Leave before 3 years and
Stay at least three years and
S22 - smaller sample variance between Leave before 3 years
and Stay at least three years .
= 3600471 / 2968129
F =1.213044
P-value = P( F < 1.213044) = 0.2926
P-value > 0.05 , Do not reject Ho
Therefore we use pooled variance.
We use t test with pooled standard deviation as the variances of the salaries of Leave before 3 years and Stay at least three years are equal.
Minitab output-
MTB > TwoSample 'Leave before 3 years' 'Stay at least three
years';
SUBC>   Confidence 95.0;
SUBC>   Test 0.0;
SUBC>   Alternative 0;
SUBC>   Pooled.
Two-Sample T-Test and CI: Leave before 3 years, Stay at least three
years
Two-sample T for Leave before 3 years vs Stay at least three years
                          
N   Mean StDev SE Mean
Leave before 3 years      35
38620   1897      321
Stay at least three year 31 37271  
1723      309
Difference = μ (Leave before 3 years) - μ (Stay at least three
years)
Estimate for difference: 1349
95% CI for difference: (453, 2245)
T-Test of difference = 0 (vs ≠): T-Value = 3.01 P-Value = 0.004 DF
= 64
Both use Pooled StDev = 1817.7075
___________________________________________________________________________
95% CI for the difference between the mean starting salaries of those who stay at least three years and those who leave before 3 years is (453, 2245).
From given sample information there is 95 % chance that difference lies in (453, 2245).