Capstone Project Part $1$ Template

Descriptive Statistics: Using Excel, calculate the following descriptive statistics and then interpret the results in context using a business perspective. The analysis$/$interpretation should tell management what the descriptive statistic is revealing about the performance of the packaging process.

Descriptive Statistic Value Analysis$/$Interpretation

Mean

$583\mathrm{.}5782$

It's interesting to note that the average weight of cereal boxes is $583\mathrm{.}59.$ This information could potentially be used to improve packaging and reduce waste.

Median

$584\mathrm{.}1298$

Based on the data, it appears that the median weight of the wax boxes is $584\mathrm{.}13,$ which is slightly higher than the company's average weight. This could be an opportunity to investigate and optimize the weight of the wax boxes to ensure consistency and efficiency in the production process.

Mode

$583\mathrm{.}056$

The analysis indicates that the weight of the cereal is most commonly found to be $583\mathrm{.}06.$

Standard Deviation

$8\mathrm{.}764051$

This is a great opportunity to examine weight differences among boxes and determine potential causes for variation.

Range

$54\mathrm{.}7273$

This analysis shows us the difference between the weight of the heaviest object and the weight of the lightest object and try to identify any patterns or insights that might emerge. This analysis could be useful in identifying trends or factors that contribute to weight variations, and could ultimately inform strategies for optimizing weight management

Lowest Value $549\mathrm{.}563$

Upon closer inspection, we can see that the box with the lowest weight is positioned below the company's average weight of $574.$ This could be a cause for concern as it may indicate that the product is not meeting the company's standards. It would be beneficial to investigate the reasons behind the lower weight and find ways to optimize the weight of the products to ensure they meet the company's requirements.

Highest Value $604\mathrm{.}2903$

the highest weight exceeds the company's average weight of $574$g by a considerable margin. The deviation in the weight of the object in question indicates that it may be an outlier or an anomalous item that needs to be further examined to ensure quality control standards are met.

Proportion of boxes below label weight

$65$ boxes This information is quite helpful as it displays the percentage of $13\%$ cereal boxes that are below the company's average weight.

Proportion of boxes above label weight

$435$ boxes

According to a recent study, $87\%$ of cereal boxes weigh more than the average standard weight.

Proportion of boxes below MAV

$545$

The MAV is $22$ grams below the declared box label weight of $567$ grams, which equals $545$ grams

Skewness $-0\mathrm{.}49912$

Because the result is negative, it means that the distribution of data falls more towards the left side of the graph.