d1 Use Excel to find the pvalue and compare it to the level

(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.

Solution

(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