Q2. The College Board SAT college entrance exam consists of three parts: Math, w

Question

Q2. The College Board SAT college entrance exam consists of three parts: Math, writing, and critical reading (The World Almanac, 2012). The Webfile TestScore contains the sample data showing the math and writing scores for a sample of 12 students who took the SAT follow.

a) Using Excel, at 0.05 level of significance, test for a difference between the population mean for the math scores and the population mean for the writing scores.

b) What is the p-value and what is your conclusion?

1 Math Score |Writing Score 474 380 463 612 420 526 430 459 615 541 335 613 540 432 528 574 448 502 480 499 610 572 390 593 10 12 13 14 15

Explanation / Answer

a.

Data + Data Analysis + t test : paired two sample for means

b.

95% CI for mean difference: (1.4593, 48.5407)
T-Test of mean difference = 0 (vs not = 0): T-Value = 2.34 P-Value = 0.039

p value < alpha

we reject null hypothesis

t-Test: Paired Two Sample for Means Variable 1 Variable 2 Mean 514 489 Variance 4661.272727 8735.818182 Observations 12 12 Pearson Correlation 0.942167362 Hypothesized Mean Difference 0 df 11 t Stat 2.337429391 P(T<=t) one-tail 0.019675138 t Critical one-tail 1.795884814 P(T<=t) two-tail 0.039350275 t Critical two-tail 2.200985159

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.