Question

Can anyone help me on how to do this in excel/what formulas to use?

A bottle of "Cold Kool Catsup" is labeled as having 32 oz. of catsup. The bottle filling factory wants to make sure the filling machine is filling accurately. They do not want to fill too little and make customers unhappy, and they do not want to fill too much and thus decrease profits. At the alpha level of 0.05 is the process out of control? (From the companies data they estimate the population standard deviation to be 0.3 oz.). Using the sample data from the range A9:A53 and the cells in the spreadsheet run a hypothesis test and write a concluding statement. 79393 8684 1-3-3 2 3111-22-21 2 3 2 2 4 22222223333 8 2 4 8 2

Answer 1

first enter data in columns c1 and name it observations are 45 here one sample t test not in Excel so we have to do dummy is 0 rows as 3 or 4 in secon column name as dummy then go to DATA two sample t test with equl variance/unequal variance>select data in first as variable enter ok then select dummy in second block and choose alpha is 0.05 mean diference is equal to put 32 in box and choose label equal to tikmar t-Test: one sample t test oz.per bottle Mean Variance Observations Pooled Variance Hypothesized Mean Difference df t Stat P(T<-t) one-tail t Critical one-tail P(T ) two-tail t Critical two-tail 0.074512828 45 0.074512828 32 0.351063592 0.363608044 1.680229977 0.727216088 2.015367574 claim: A bottle cold kool catsup is labeled having 32

The bottle filling factory wants to make sure the filling machine is filling accurately ie 32 To test: H0:mean:32 vs H 1: Alternative :mean not equal to 32 Test Statitics one tail test critical value is -0.35106 1.68023 two tailed t test critical value is 2.015368 ## Decision : we reject Ho at (1-alpha)"100 percent level of significance if absolute test statistics value is greater than t critical value ## conclusion: here for both one tail and two tail critical value is greater than test statistics value hence we fail to reject HO ie A bottle cold kool catsup is labelled having 32 claim is got that is bottle cold kool catsup should be 32