Coca-Cola is the number one seller of soft drinks in the world. It continues to try to grow internationally with operations throughout Europe, Asia and Russia. However, many of these nations desire different bottle sizes which is a manufacturing concern for the Coke bottlers in these nations.

Due to the variability of the new bottling machinery, it is likely that every 200 milliliter bottle of Coke does not contain exactly 200 milliliters. Some may contain more and some less. Coke brings in a production engineer who will test some of the bottles from the first production run to determine how close they are to the 200 milliliter level.

Below are the fill measurements from a run of 50 random sample bottles:

200.1 199.9 200.2 200.2 200.0 200.1 200.9 200.1 200.3 200.5
199.7 200.4 200.3 199.8 199.3 200.1 199.4 199.6 199.2 200.2
200.4 199.8 199.9 200.2 199.6 199.6 200.4 200.4 200.6 200.6
200.1 200.8 199.9 200.0 199.9 200.3 200.5 199.9 201.1 199.7
200.2 200.5 200.2 199.7 200.9 200.2 199.5 200.6 200.3 199.8

Question:

In Excel use the Descriptive Statistics and comment on the mean, the skewness, the standard deviation and kurtosis.

a. Based on your analysis, how is the new bottling process working?