Question

Use the table below to determine the answers to the following questions. Assume an alpha of 0.05 and use Excel's T Test Two Sample Assuming Unequal Variances to determine the answer to those questions.

Employee	Exercise	Rating
1	Yes	15
2	Yes	17
3	Yes	16
4	Yes	20
5	Yes	20
6	Yes	14
7	Yes	14
8	Yes	16
9	Yes	24
10	Yes	10
11	Yes	23
12	Yes	22
13	Yes	15
14	Yes	13
15	Yes	14
16	Yes	15
17	No	10
18	No	24
19	No	15
20	No	9
21	No	14
22	No	13
23	No	11
24	No	12
25	No	14
26	No	11
27	No	11
28	No	15
29	No	9
30	No	20
31	No	22
32	No	12
33	No	22
34	No	23
35	No	6
36	No	9

1	What is the value for the test statitistic ("t Stat" as Excel calls it)?
2	What is the value for the Critical value for t?
3	What is the the p-value for this two-sample hypothesis test?
4	Our conclusion should be that participating in the fitness program does result in employees who are more productive. True or False.

Answer 1

Step1:First we need to load data analysis tool park.If the data analysis tool park loaded in Excell then go to step 2

Step2:Click on “Data” tab then click on “Data analysis.”

Step3:Click on "t-Test: Two-Sample Assuming Unequal Variances"

Step4: Select Range 1 and Range 2 of data

Step5:Enter Hypothesized mean difference is zero in the box and alpha is 0.05 in the box

Step6:Select Output Range and click on OK

t-Test: Two-Sample Assuming Unequal Variances
	Yes	No
Mean	16.75	14.1
Variance	15.53333	28.30526
Observations	16	20
Hypothesized Mean Difference	0
df	34
t Stat	1.715544
P(T<=t) one-tail	0.047673
t Critical one-tail	1.690924
P(T<=t) two-tail	0.095347
t Critical two-tail	2.032245

a)The value for the test statitistic ("t Stat") is 1.715544

b) The value for the Critical value for t is 1.690924

c) The the p-value for this two-sample hypothesis test is 0.047673

d) P-value=0.047673<alpha=0.05 then we reject the null hypothesis and conclude that  participating in the fitness program does result in employees who are more productive i.e.(TRUE)