Making Data Driven Decisions

Week 9 Assignment Template Making Data-Driven Decisions (150 Points) Name:  Snack Company Case Study (MGT) Construct a box-and-whisker plot for the provided data set. Copy each of the values needed to construct a box-and-whisker plot from the Excel worksheet provided and enter those numbers below. Minimum Maximum Quarter 1 (Median of the first half of the data set) Quarter 2 (Median of data set) Quarter 3 (Median of the second half of the data set 19.02 20.79 19.66 19.93 20.17 Create the box-and-whisker plot in Excel and include a screenshot of the box-and-whisker plot below. The box and whisker plot (Boxplot) summarizes the given set of data including outliers. The shape of the boxplot as seen in figure 1 above shows how data has been distributed. With the median at the center of the box, it means that the data is normally distributed Copy the sample mean, median, and standard deviation from the provided Excel Worksheet and enter those below. Mean Median Standard Deviation 19.92 19.9250 0.402598 Copy the 95% Confidence Interval from the Excel Worksheet provided and enter that below. Lower Limit Upper Limit 19.76767 20.0683 Use the results from the hypothesis test in the Excel worksheet provided to fill in the table below. Clearly state the logic of your test, the calculations, and the conclusion of your test. Null Hypothesis (H0) µ=20 Alternative Hypothesis (H1) µ<20 What type of Test Statistic did you use and why? Test statistic z. I used the z-test because the population's standard deviation is already known. Value of Test Statistic -1.11558 P-value 0.1368...