Week 9 Assignment Template
Making Data Driven Decisions (150 Points)
Name:
Title of Presentation:
Write a two to three (2–3) page report in which you:
- 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 2
(Median of data set)
|
Quarter 1
(Median of first half of the data set) |
Quarter 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.
2.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 |
4.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? |
5.Evaluate the results of the hypothesis test and communicate the suggested solutions based on those results. (This section should be 1–2 pages). Provide the following discussion based on the conclusion of your test:
- Provide a detailed explanation to your supervisor of how the results address the concern.
- What is your suggested solution based on the results?
- What decisions should be made based on the results? What should the next steps be?
