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é 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
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
2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may
not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.
Page 1 of 2
MAT210 – Week 9 Assignment Template
3. 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 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.
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 be?
2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may
not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.
Page 2 of 2
Week 9 Assignment: Case Study (HSA)
Due Week 9 and worth 150 points
Imagine you work in a hospital that has been working on improving patient wait times. The average wait
during peak hours is 90 minutes. Your supervisor is interested in improving patient satisfaction and
believes that decreasing wait times will help. The hospital has implemented a new system and claimed
that it would lower wait times to less than 45 minutes. Your supervisor has asked you to evaluate the new
system that has been in place for six months.
You collect data from the past six months and then randomly sample 30 patient wait times. The results of
your sample are shown in the Excel file below.
Write a two to three (2é page report using the provided template in which you:
1. Construct a box-and-whisker plot for the monthly number of patient wait times.
2. Calculate the sample mean, median, and standard deviation for monthly number of patient wait
times.
3. Construct a 95% Confidence Interval for the monthly number of patient wait times.
4. Conduct a hypothesis test to verify if the claim that the mean monthly number patient wait times is
less than 45 minutes is supported. Clearly state the logic of your test, the calculations, and the
conclusion of your test.
5. Provide the following discussion based on the conclusion of your test:
a. If you conclude that patient wait times is less than 45 minutes, provide three (3) possible
causes.
Or
b. If you conclude that the claim of less than 45 minutes is not supported or justified, provide
a detailed explanation to your supervisor about why this perception might exist. Include
your speculation on the reason(s) behind the claim.
2022 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may
not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.
Page 1 of 1
Patient Wait
Sample Time in
Number Minutes
1
48
2
45
3
44
4
45
5
52
6
35
7
45
8
35
9
59
10
48
11
43
12
44
13
43
14
53
15
35
16
43
17
47
18
35
19
42
20
39
21
37
22
43
23
44
24
47
25
30
26
45
27
28
29
30
45
39
45
46
Minimum
Maximum
Q1
Q2
Q3
Student should Use t-test
Mean
Median
Standard Deviation
n=
df=
Confidence Level=
t=
E=
Confidence Interval Lower Limit
Confidence Interval Upper Limit
Null Hypothesis
Alternative Hypothesis
What type of Test Statistic did you use
and why?
Conclusion: Is the claim supported?
Why or why not?
=
?
?
?
<
>
If student uses z-test; provide
feedback and grade for content.
Hypothesis Test
Null Hyp:
Alt Hyp:
m
m
significance level =
test statistic =
critical value =
p-value =
Since
1
30.00
59.00
39.75
44
45.75
43.37
44.0000
6.002777
30
29
0.95
2.045
2.241474
41.12519
45.6081
r0
°.05
we
fail to reject the null:
m
=
20

Purchase answer to see full
attachment