Statistic
9.1 Z test for the Mean
Z test for the Mean Problem:
You are the manager for Oxford Cereals. Among other responsibilities
Data , you are responsible for monitoring the amount in each cereal box.
Null Hypothesis Company specifications requrie a mean weight of 368 grams per box.
Level of Significance 0.05 You select a random sample size of 25 ceral boxes. The standard deviation of the cereal
Population Standard Deviation filing process is 15 grams and we found the sample mean to be 372.5 grams
sample size
sample mean
Intermediate Calculations
Standard Error of the Mean B6/SQRT(B7)
Z Test Statistic (B8-B4)/B11
Two- Tail Test
Lower Critical Value NORMSINV(B5/2)
Upper Critical value NORMSINV(1-B5/2)
p-value 2*(1-NORMSDIST(ABS(B12)))
IF(B17