Question

# Assume that you want to test the claim that the paired sample data come from a...

Assume that you want to test the claim that the paired sample data come from a population for which the mean difference is muSubscript dequals0. Compute the value of the t test statistic. Round intermediate calculations to four decimal places as needed and the final answer to three decimal places as needed. Start 2 By 9 Table 1st Row 1st Column x 2nd Column 36 3rd Column 38 4st Column 21 5st Column 32 6st Column 30 7st Column 30 8st Column 33 9st Column 36 2nd Row 1st Column y 2nd Column 34 3rd Column 34 4st Column 27 5st Column 32 6st Column 31 7st Column 35 8st Column 33 9st Column 35 EndTable A. tequalsminus1.480 B. tequalsminus0.523 C. tequals0.690 D. tequalsminus0.185

data

 x y 36 34 38 34 21 27 32 32 30 31 30 35 33 33 36 35

using excel

data -> data analysis -> paired t test

result

 t-Test: Paired Two Sample for Means x y Mean 32 32.625 Variance 28.28571429 7.125 Observations 8 8 Pearson Correlation 0.845289037 Hypothesized Mean Difference 0 df 7 t Stat -0.523321521 P(T<=t) one-tail 0.308451513 t Critical one-tail 1.894578605 P(T<=t) two-tail 0.616903026 t Critical two-tail 2.364624252

B) -0.523 is correct