(d-1) Use Excel to find the p-value and compare it to the level of significance.

Question

(d-1) Use Excel to find the p-value and compare it to the level of significance. (Round your answer to 4 decimal places.) The p-value is . It is (Click to select) than the significance level 0.01. (b) Calculate the t test statistic to test the manufacturers claim. (Round your answer to 4 decimal places.) Test statistic _____________ The sodium content of a popular sports drink is listed as 225 mg in a 32-oz bottle. Analysis of 15 bottles indicates a sample mean of 233 mg with a sample standard deviation of 25 mg.

Explanation / Answer

(b) t=(xbar-mu)/(s/vn)

=(233-225)/(25/sqrt(15))

=1.2394

-------------------------------------------------------------------------------------------------------------------

(b) The degree of freedom =n-1=15-1=14

So the p-value =2*P(t with df=14>1.2394)=0.2356 (from student t table)

greater than the significance level 0.01

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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