Question

Pioneer Castings, Inc. is realizing it's employee turn-over is rather high. Furthermore, the management is also wondering if the rates are the same between Men and Women. To find out the details, it randomly picked a sample of men and women and recorded the number of years each stayed with the company. Given this dataset, can we conclude that the men and women have the same tenure at the company? Use level of significance = 4% everywhere.                  
                                      
                  
Run the appropriate T-test (using Excel and Explain the steps). Output to Cell D33.                              
Q5   What is the P-value?              
Q6   What is the Level of Significance?              
Q7   If you compare the T-stat with T-critical, you would conclude that               
Q8   If you compare the P-value with Alpha, you would conclude that               

Men       Women
3.2       0.7
15.7   0.9
1.3       0.8
0.7       0.3
8.6       5.8
10.4   2.3
3.2       1.4
1.3       9.3
23.9   5.7
0.2       12.1
0.8       2.8
11.1   0.4
1.5       1.4
3.7       1
14.9   0.8
3       11.9
2.3       4.8
18.2   1.3
12.9   2.6
2.5       1.8
3.8       6.3
3.4       20.7
5.5       1.8
3.8       16.4
17.3   4.1
3.7       2.7
9.7       1.4
10.3   2.9
4.3       4.5
9       4
15.8   0.6
16.8   3
4.1       1.1
5.6       7
1.4       1.4
20.1   2.3
1.2       17
5.1       6
5.8       3.7
6.8       6.8
13.7   6.1
6.1       0.4
6.4       4.9
2.5       3.3
22.2   10.6
4.4       4.9
18.1   0.3
0.4       4.7
2.8       3.7
13.9   1.4
7.9       2.8
5.4       1.3
6.2       1.6
2.5       4
11.3   7.1
10       2.5
2       3.8
1.5       5.8
4.3       8.9
1.3       7.6
5.8       11.2
2.8       3.2
1.5       9.4
0.6       5.6
5.8       8.2
4.8       0.1
2.7       2.5
5.7       11.1
17       2.8
11.3   1.1
9.6       3.5
1.9       2.2
15.8   2.9
2.4       1.6
5.6       6.6
0.9       1.9
20.6   1.3
11.2   1.7
10.6   7.8
1.2       5.3
10.7   3.1
3.1       5.2
0.2       7.6
0.5       0.6
3.7       5.6
7.1       2.2
1.6       10.5
20.1   2.8
3.8       8.5
3.6       6.2
1.8       1.5
1.4       3.4
11.3   8.9
10.2   20.2
11.6   0.6
15.9   2.5
15.3   3
10.1   0.7
3.4       10.7
3.7       0.3
6.4       4.1
14.2   35.9
2.2       7.1
2.6       4.2
18.9   3.2
6.4       1.4
12       2
16.6   2
7.3       20.9
5.3       25.2
10.3   1.4
16.7   5.2
12.6   2.9
1.9       3
7.1       2.5
6.6       6.1
1.6       12.4
3.2       3
1.6       8.4
0.9       0.8
0.5       13
1.5       1.5
1.9       1.1
4.8       5.9
18       8.4
1       10.6
0.8       4.2
16.5   0.6
1.6       17.6
3.1       1.4
0.6       4.7
10.8   15.4
1.2       8.6
3.1       2.6
3.3       0.6
3.1       8.8
3.7       5.6
0.7       10.3
2.5       6.5
2.3       1.6
5       0.6
0.3       0.8
4.1       7.9
3.4       3.5
6.2       7.5
8       6.5
7.8       3.3
1.8       3.2
0.3       2.4
0.7       3.3
14.1   3.6
5.1       8.1
2.5       3.9
3.3       1
1.5       2
19.5   27.9
3       15.4
1.8       0.5
3       0.5

Answer 1

Enter the data correctly from cell A1 to B160 with the labels.

Steps: Go to data, select Data analysis, select t-test: two sample assuming unequal variances, give the variable 1 range as $A$1:$A$160 , give the variable 2 range as $B$1:$B$160, hypothesized mean difference as 0, give the output range as $D$33, check the checkbox of Labels, enter alpha as 0.04, click on OK.

From the output obtained, the following questions are answered.

5.

The alternative hypothesis is two sided and thus the test is two-tailed

The p-value for two-tailed test is obtained as

0.054111833

6.

The level of significance is given to be 4% i.e. 0.04

7.

The t statistic is obtained as

1.93316505

The critical value for two tailed test is obtained as

2.062288333

As the observed value is less than the critical value, we fail to reject the null hypothesis at 4% level of significance and hence conclude that the tenures of men and women do not differ significantly.

8.

The p value is obtained as

0.054111833

The given alpha is 0.04.

As the p-value is more than 0.04, we fail to reject the null hypothesis at 4% level of significance and hence conclude that the tenures of men and women do not differ significantly.

Hopefully this will help you. In case of any query, do comment. If you are satisfied with the answer, give it a like. Thanks.