B.Referring to Table 13-13, the value of the measured t test statistic to test w

Question

B.Referring to Table 13-13, the value of the measured t test statistic to test whether composite score depends linearly on spending per student is ________. (round to 3 decimal places)

C.Referring to Table 13-13, the p-value of the measured t test statistic to test whether composite score depends linearly on spending per student is ________. (round to 4 decimal places) Using the EXCEL.

In this era of tough economic conditions, voters increasingly ask the question: "Is the educational achievement level of students dependent on the amount of money the state in which they reside spends on education?" The partial computer output below is the result of using spending per student ($) as the independent variable and composite score which is the sum of the math, science and reading scores as the dependent variable on 35 states that participated in a study. The table includes only partial results Regression Statistics Multiple R R Square Adjusted R 0.3122 0.0975 0.0701 quare Standard Error Observations 26.9122 35 ANOVA df MS Regression Residual Total 2581.5759 724.2674 34 26482.4000 Coefficients Standard Error t Stat P-value Intercept Spending per Student (S) 595.540251 22.115176 0.007996 0.00423

Explanation / Answer

A) Estimated change in mean composite score in case if the state decides to spend 1,000 dollars more per student

= 1000*(0.007996) = 7.996

B) Value of measured t statistic = 0.007996/0.004235 = 1.888

C) p - value = 0.0678

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

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