The following is the printout from Excel Hypothesis Test about a Population Mean

Question

The following is the printout from Excel Hypothesis Test about a Population Mean: Sigma Unknown Case Sample Size 30 Sample Mean 45000 Standard Deviation Sample 15000 Hypothesized Test Value 48500 Standard Error? Test Statistic t ? Degrees of Freedom 29 Alpha 0.05 Critical Value (two tail) + or-? P-value (Lower TailNa P-value (Upper Tail) Na P-value (Two tail) 0.211378013 Using the given Null Hypothesis and level of significance Not enough information is given to answer this question. O The null hypotheisis should be rejected I have no idea The null hypotheisis should not be rejected

Explanation / Answer

Ans:

t=(45000-48500)/(15000/SQRT(30))

t=-1.278

df=30-1=29

p-value(2 tailed)=tdist(1.278,29,2)=0.211378

significance level=0.05

As,p-value>0.05,we fail to reject the null hypothesis.

So,the correct option is:

The null hypothesis should not be rejected.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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