Need statistics help with a Bottling Company Case Study

Imagine you are a manager at amajor bottling company. Customers have begun to complain that the bottles of thebrand 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 hasasked you to investigate. You have your employees pull thirty (30) bottles offthe line at random from all the shifts at the bottling plant. You ask youremployees to measure the amount of soda there is in each bottle. Note: Use thedata set provided by your instructor to complete this assignment.Write a two to three (2-3) page report in which you:Calculate the mean, median, and standard deviationfor ounces in the bottles.Construct a 95% Confidence Interval for the ouncesin the bottles.Conduct a hypothesis test to verify if the claimthat a bottle contains less than sixteen (16) ounces is supported. Clearly statethe logic of your test, the calculations, and the conclusion of yourtest.Provide the following discussion based on theconclusion of your test: a.If you conclude that there are less than sixteen (16) ounces in a bottle ofsoda, speculate on three (3) possible causes. Next, suggest the strategies toavoid the deficit in the future.Orb.If you conclude that the claim of less soda per bottle is not supported orjustified, provide a detailed explanation to your boss about the situation.Include your speculation on the reason(s) behind the claim, and recommend one(1) strategy geared toward mitigating this issue in the future.Your assignment mustfollow these formatting requirements:Be typed, double spaced, using Times New Romanfont (size 12), with one-inch margins on all sides. No citations and referencesare required, but if you use them, they must follow APA format. Check with yourprofessor for any additional instructions.Include a cover page containing the title ofthe assignment, the students name, the professors name, the course title, andthe date. The cover page and the reference page are not included in the requiredassignment page length.The specific courselearning outcomes associated with this assignment are:Calculate measurements of central tendency anddispersal.Determine confidence intervals fordata.Describe the vocabulary and principles ofhypothesis testing.Discuss application of course content toprofessional contexts.Use technological tools to solve problems instatistics.Write clearly and concisely about statisticsusing proper writing mechanics..