Write the  report in which you will perform the following tasks

 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	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 screen shot of the box-and-whisker plot below. 

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

Mean	Median	Standard Deviation

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

Lower Limit	Upper Limit

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 (
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. (This section should be 1-2pages). 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?