Week 9 Assignment - Making Data-Driven Decisions Imagine you work in a probation office. Your supervisor is interested in the mean monthly number of parolees the office handles. They believe the number is greater than 155. Your supervisor wants to determine if they are correct and has asked you to investigate. If they can prove that the true monthly number of parolees is greater than 155, they can start the process of hiring another parole officer. You collect monthly data from the past five years and then randomly sample 30 months. The results of your sample and your calculations are shown in the Excel file provided in the assignment instructions in Canvas. Instructions: Using the data from the Case Study (above) and the Calculation Worksheet (Excel file), complete the following: 1. Construct a box-and-whisker plot for the monthly number of parolees. 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 first half of the data set) Quarter 2 (Median of data set) Quarter 3 (Median of second half of the data set)

Page 2 of 3 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 for the monthly number of parolees from the provided Excel Worksheet and enter those below. Mean Median Standard Deviation 3. Copy the 95% Confidence Interval for the monthly number of parolees from the Excel Worksheet provided and enter that below. Lower Limit Upper Limit 4. Conduct a hypothesis test to verify if the claim that the mean monthly number of parolees is greater than 155 is supported. 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?

Page 3 of 3 5. Evaluate the results of the hypothesis test and communicate the suggested solutions based on those results. (This section should be at least 1 page in length). Provide the following discussion based on the conclusion of your test: a) Provide a detailed explanation to your supervisor of how the results address the concern. b) What is your suggested solution based on the results? c) What decisions should be made based on the results? What should the next steps