Question

Please show me how to do these steps with EXCEL. I am really confused on which numbers to plug into the equations, and am preparing for an exam and I am only able to use excel.

Please show full work, thank you again. I WILL RATE POSITIVE. :) thanks

The Crown Bottling Company has just installed a new bottling process that will fill 16-ounce bottles of the popular Crown Classic Cola soft drink. Both overfilling and underfilling bottles are undesirable: Underfilling leads to customer complaints and overfiling costs the company considerable money. In order to verify that the filler is set up correctly, the company wishes to see whether the mean bottle fill, p, is close to the target fill of 16 ounces. To this end, a random sample of 35 filled bottles is selected from the output of a test filler run. If the sample results cast a substantial amount of doubt on the hypothesis that the mean bottle fill is the desired 5 ounces, then the filler's initial setup will be readjusted. (a) The bottling company wants to set up a hypothesis test: that the filler Il be readjusted if the null hypothesis is rejected. Set up the null and alternative hypotheses for this hypothesis test. Ho: 16 versus H,: uF (b) Suppose that Crown Bottling Company decides to use a level of significance of a 0.01, and suppose a random sample of 35 bottle fills is obtained from a test run of the filler. For each of the following four sample means-x= 16.06, x 15.94, x= p-value, case, use a critical value setup should in adjusted. In ea confidence erval. Assume that a equals.1. (Round your z to 2 decimal places and p-value to 4 decimal places and Cl to 3 decimal places.) T 16.06 1.01 p-value ((Click to select) CI = 15.94 p-value CI (Click to select) Readiust x = 16,02 Do not readjust p-value (Click C select) X = 15.98 p-value (Click to select)

Answer 1

16.06 a iA Excel - (16.06-)x35 X O,35 P-value - P(z0.35)=2 P (z<-0.35) NORMS DIST O.35) nExel z 2 O.3632- O,72 6 in tycel (ENORMANV (0.995) Z O.005 1. ニ2.58 2.5 X t 2.58 16-06- 2.S , 16.06+ 2.ら8 Y 35 16.06 0.43 6.06+ 0.436 5,624 6.496

chamyas Only p-valu usill emain Samne- 2.5? CnHcal value Zo.ol えこ15、94 15.94 IL O.35 0.7264 2 P2<-0.35) P- value 15.94 t 0.436 15. S04 16.3 6 Do no n - 16. O 2 16.02-16 O19 P-value 2 P(Z70.19 2 P(Z-D. 13) E 2 NORNSDIST (-0.19) Exce 2aO. 4 24 0.8494 C I 16.02t,4 3 S.584 16.456J Ajet Do nol bE

0.19 V3s 2 P (Z0.19) P-valuw O.8494 1S. 18 0.436 CI (15.54 4 6.4 16 jur Do not