MAT210 - Week 9 Assignment Template

 

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:

 

1.     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
118.00	206.00	159	140.75	168

 

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

 

 

Figure1: screenshot of the box-and-whisker plot

 

Need Help with your homework/Assignment? Don’t Be Shy To Ask for help by Clicking this Link.

 

 

 

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

Mean	Median	Standard Deviation
155.93	159.0000	18.827590

 

 

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

Lower Limit	Upper Limit
148.90300	162.9637

 

 

 

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 (	µ=20
Alternative Hypothesis (	µ<20
What type of Test Statistic did you use and why?	t-test; population standard deviation not given
Value of Test Statistic	39.54502
P-value	1.00000
Critical Value	-1.69913
Conclusion: Is the claim supported? Why or why not?	Fail to reject the null so there is not enough evidence to reject the hypothesis; we cannot support this claim.

 

 

Need Help with your homework/Assignment? Don’t Be Shy To Ask for help by Clicking this Link.

 

 

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: 

 

a.     Provide a detailed explanation to your supervisor of how the results address the concern.

The results from the analysis failed to reject the null which showed that there is no enough evidence to reject the hypothesis. Failing to reject the null indicates that the sample did not provide sufficient evidence to conclude that the effect exists. The results addressed the concern by concluding that the claim of more than 155 monthly parolees is not justified.

b.    What is your suggested solution based on the results?

Based on the results, my suggested solution is there is no need to start the process of hiring another parole officer because we cannot prove that the true monthly number of parolees the office handles is greater than 155.

 

c.     What decisions should be made based on the results? What should the next steps be?

Considering that the analysis utilized the data for the monthly number of parolees, the next step should be to utilize a data for the yearly number of parolee. The decision can increase the accuracy of the analysis to determine if the supervisor will need to start the process of hiring another parole officer.

Need Help with your homework/Assignment? Don’t Be Shy To Ask for help by Clicking this Link.