mu= 947.94 n= 5 x bar = 1000 command in the column labeled as Predicted SAT (Col

Question

mu= 947.94
n= 5
x bar = 1000

command in the column labeled as Predicted SAT (Column D). 13. Conduct a one-sample t test for the hypothesis test with Ho: population mean SAT score 1000 vs. Ha: population mean SAT score # 1000. Calculate the t statistic and put your calculation in Cell G6. 14. Use the "TDISTIO" function to find the p-value and put the command in Cell G7. Type your conclusion below 15. Use the "COUNIEO" function to count the number of states whose SAT scores are greater than 1000. Put your command in Cell G8. 16. Please save your Excel file and this Word file. Make sure they are named correctly. Upload both two files to "Lab Exam" under Assignments on Canvas. 6 7:01 PM 12/3/2017

Explanation / Answer

Solution:-

13)

State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.

Null hypothesis: = 1000
Alternative hypothesis: 1000

Note that these hypotheses constitute a two-tailed test. The null hypothesis will be rejected if the sample mean is too big or if it is too small.

Formulate an analysis plan. For this analysis, the significance level is 0.05. The test method is a one-sample t-test.

Analyze sample data. Using sample data, we compute the standard error (SE), degrees of freedom (DF), and the t statistic test statistic (t).

SE = s / sqrt(n)

DF = n - 1 = 5 - 1

D.F = 4
t = (x - ) / SE

Thus, the P-value = Using t-calulator.

Interpret results.

If P-value is greater than the significance level (0.05), we cannot reject the null hypothesis.

If P-value (0.08) is less than the significance level (0.05), we have to accept the null hypothesis.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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