Case Study: Statistics Bottling Company

705 Words2 Pages

This research in the finding of mean, median and standard deviations of the Bottling Company Case results calculations as displayed in the excel spreadsheet of some corrections that were produced. The 30 ounce bottles of the various bottle had some complaints about the different trade names of soda produced from the company advertisements. The company boss has asked for an investigation on this matter from the employees on random shifts in each class in the bottling plant. I also think the differences in the results between the companies may have a different result depends on the amount.
Statistics Bottling Company Case Study

The mean, median, standard deviation, and the confidence interval, there will be an inserted of my calculation shown in a spreadsheet of this assignment. In my finding of means calculation sums of thirty ounce bottles that were given, the (=average (B3:B32). The finding of median calculation using the build in Excel which is: =MEDIAN (B3:B32). The finding of standard deviation calculation formula used Excel as well, which is: =STDEVA (B3:B32). The calculation of 95% confidence interval is +1.96 and -1.96. I took each bottle and added and subtracted the standard deviation to receive my calculated results. The majority …show more content…

The bottles should have been committed in the operations of the machines calibration values could have been set wrong or some break in the country. The second cause could be due to just an error made on the assemble lines. The other reason could be in my conclusion is the product could have been condensed in storage. In the resolution of the machine caused spill out before the tops were secured on the bottles before moving them. The different variable can cause a shortage, and the problem can be geared up properly to stop losing liquid from the soda

Open Document