Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment.

Calculate the mean, median, and standard deviation for ounces in the bottles.

Construct a 95% Confidence Interval for the ounces in the bottles.

Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.

Provide the following discussion based on the conclusion of your test:

Bottle Number 1 2 3 4 ** 5 6 7 8 9 10 Ounces 14.23 14.32 14.98 15.00 15.11 15.21 15.42 15.47 15.65 15.74 Bottle Number 11 12 13 14 15 16 17 18 19 20 Ounces 15.77 15.80 15.82 15.87 15.98 16.00 16.02 16.05 16.21 16.21 Bottle Number 21 22 23 24 25 26 27 28 29 30 Ounces 16.23 16.25 16.31 16.32 16.34 16.46 16.47 16.51 16.91 16.96