1. Construct a box-and-whisker plot for the provided data set.

Minimum	Maximum	Quartile 1 (Median of first half of the data set)	Quartile 2 (Median of data set)	Quartile 3 (Median of second half of the data set)

Create the box-and-whisker plot in Excel and include a screenshot of the box-and-whisker plot below.

1. Copy the sample mean, median, and standard deviation from the provided Excel Worksheet and enter those below.

Mean	Median	Standard Deviation

1. Copy the 95% Confidence Interval from the Excel Worksheet provided and enter that below.

Lower Limit	Upper Limit

1. Use the results from the hypothesis test in the Excel worksheet. Clearly state the logic of your test, the calculations, and the conclusion of your test.

Null Hypothesis (
Alternative Hypothesis (
What type of Test Statistic did you use and why?
Value of Test Statistic
P-value
Critical Value
Conclusion: Is the claim supported? Why or why not?

1. Evaluate the results of the hypothesis test and communicate the suggested solutions based on those results. Provide the following discussion based on the conclusion of your test:

1. Provide a detailed explanation to your supervisor of how the results address the concern.
2. What is your suggested solution based on the results?
3. What decisions should be made based on the results? What should the next steps be?