Imagine you are a manager at amajor bottling company. Custom.
Imagine you are a manager at amajor bottling company. Customers have begun to complain that the bottles ofthe brand of soda produced in your company contain less than the advertisedsixteen (16) ounces of product. Your boss wants to solve the problem at handand 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. Youask 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. Bottle NumberOuncesBottle NumberOuncesBottle NumberOunces114.511152114.1214.61215.12214.2314.713152314414.81414.42414.9514.91515.82514.7615.316142614.5714.917162714.6815.51816.12814.8914.81915.82914.81015.22014.53014.6Write a two to three (2-3) pagereport in which you:1. Calculate the mean, median, andstandard deviation for ounces in the bottles.2. Construct a 95% ConfidenceInterval for the ounces in the bottles.3. Conduct a hypothesis test toverify if the claim that a bottle contains less than sixteen (16) ounces issupported. Clearly state the logic of your test, the calculations, and theconclusion of your test.4. Provide the followingdiscussion based on the conclusion of your test: a. If you conclude that there are less thansixteen (16) ounces in a bottle of soda, speculate on three (3) possiblecauses. Next, suggest the strategies to avoid the deficit in the future.Orb. If you conclude that the claim of less sodaper bottle is not supported or justified, provide a detailed explanation toyour boss about the situation. Include your speculation on the reason(s) behindthe claim, and recommend one (1) strategy geared toward mitigating this issuein the future.Your assignment must followthese formatting requirements:· Be typed, double spaced, usingTimes New Roman font (size 12), with one-inch margins on all sides. Nocitations and references are required, but if you use them, they must followAPA format. Check with your professor for any additional instructions.· Include a cover page containingthe title of the assignment, the student’s name, the professor’s name, thecourse title, and the date. The cover page and the reference page are notincluded in the required assignment page length.