Assignment 1: Bottling Company Case StudyDue Week 10 and worth 140 pointsImagine

Assignment 1: Bottling Company Case StudyDue Week 10 and worth 140 pointsImagine 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.Note: The assignment need have to be done on Excel. Just do it on word doc.You can download the excel attachment. The column A on the excel sheet is the data for 30 bottles and column C is the step by step questionto be addressed.Write a two to three (2-3) page report in which you:OrYour assignment must follow these formatting requirements: