Lab 05Template - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

Your name INSTRUCTIONS:
DS 123 Lab #5 1. Under File, select Page Setup. Select the top tab: Sheet.
Due: 3/24/08 In the Print window, select Gridlines and Row and Column Headers.
2. Set column A to 10 and column D to 16.
3. Insert a page break above row 49.
4. Define Postexposure as Variable 1 and Preexposure as Variable 2 in the
DataAnalysis Toolkit t-test for paired two sample for means for Question 1.
Question 1. Problem 9.32, p. 377
Preexp. Postexp. Diffs. t-Test: Paired Two Sample for Means
50 53 -3
25 27 -2 Postexp. Preexp.
30 38 -8 Mean 54.5 50.5 Average diff = 4
50 55 -5 Variance 389.39 341.39
60 61 -1 Observations 10 10
80 85 -5 Pearson Correlation 0.99
45 45 0 Hypothesized Mean 0
30 31 -1 df 9
65 72 -7 t Stat 4.19
70 78 -8 P(T<=t) one-tail 0
Mean = 4 t Critical one-tail 1.83
StDev = 3 P(T<=t) two-tail 0
t Critical two-tail 2.26
Hypotheses: H0: mupost - mupre <= 0 H0: Mupost - mupre <= 0
HA: mpost - mupre not > 0 HA: mupost - Mupre > 0
Rejection Region:
df = 9 Rej H0 if p-value < 0.01
2.26
Test Statistic: 4.19 p-value = 0
Conclusion:
Since the test statistic of
with at least 99% confidence. H0 with at least 99% confidence.