Imagine You Are A Manager At A Major Bottling Company

Order #SK85Pages: 1CPP: 200Deadline: 11:00PMAPAInstructions:Imagine you are a manager at a major bottling company. Customers have begun to complain that thebottles 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. Youhave 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 setprovided by your instructor to complete this assignment.BottleNumberOunces BottleNumberOunces BottleNumberOunces1 14.5 11 15 21 14.12 14.6 12 15.1 22 14.23 14.7 13 15 23 144 14.8 14 14.4 24 14.95 14.9 15 15.8 25 14.76 15.3 16 14 26 14.57 14.9 17 16 27 14.68 15.5 18 16.1 28 14.89 14.8 19 15.8 29 14.810 15.2 20 14.5 30 14.6Write a two to three (2-3) page report in which you:1. Calculate the mean, median, and standard deviation for ounces in the bottles.2. Construct a 95% Confidence Interval for the ounces in the bottles.3. Conduct a hypothesis test to verify if the claim that a bottle contains