Question

	Before	After	di=xi-yi	di^2
1	190	180	10	100
2	170	160	10	100
3	185	190	-5	fill in missing number
4	160	160	0	0
5	200	190	10	100
Sum (Show excel formula)
Mean (Show excel formula)
Standard Deviation (Show excel formula)

Complete the chart above and answer the questions below (show all work if using technology state the technology used and provide the formula)

1. What is the appropriate hypothesis test to use for this analysis: z-test for two proportions, t-test for two proportions, t-test for two dependent samples (matched pairs), or t-test for two independent samples?

2.  Let μ1 = mean weight before the exercise regime. Let μ2 = mean weight after the exercise regime. Define the null hypothesis.

3. Let μ1 = mean weight before the exercise regime. Let μ2 = mean weight after the exercise regime.  Defines the alternative hypothesis.

Answer 1

Formulas used:

SUM	=SUM(B3:B7)	=SUM(C3:C7)	=SUM(D3:D7)	=SUM(E3:E7)
MEAN	=AVERAGE(B3:B7)	=AVERAGE(C3:C7)	=AVERAGE(D3:D7)	=AVERAGE(E3:E7)
STANDARD DEVIATION	=STDEV.S(B3:B7)	=STDEV.S(C3:C7)	=STDDEV.S(D3:D7)	=STDDEV.S(E3:E7)

	Before	After	di=xi-yi	di^2
1	190	180	10	100
2	170	160	10	100
3	185	190	-5	25
4	160	160	0	0
5	200	190	10	100
Sum (Show excel formula)	905	880	25	325
Mean (Show excel formula)	181	176	5	65
Standard Deviation (Show excel formula)	15.96871942	15.16575089	7.071067812	48.73397172

1. What is the appropriate hypothesis test to use for this analysis: z-test for two proportions, t-test for two proportions, t-test for two dependent samples (matched pairs), or t-test for two independent samples?

t-test for two dependent samples (matched pairs)

Solution2:

2.  Let μ1 = mean weight before the exercise regime. Let μ2 = mean weight after the exercise regime. Define the null hypothesis.

H0:μ1 =μ2  that is  μ1 -μ2=0 =====> μd =0

3. Let μ1 = mean weight before the exercise regime. Let μ2 = mean weight after the exercise regime.  Defines the alternative hypothesis.

Alternative Hypothesis:

Ha: μ1 > μ2 that is  μ1 -μ2>0 =====> μd>0

μd is difference in means before and after