![]()
![]()
![]()
Use this data set to build a managerial summary outlining your findings and recommendations. Your analysis should answer all of the following questions and should have outputs of the graphs or the statistical tests being used. Comment by Nimet Alpay: Attach the data set here.
1. Do the gender and age range distributions in the sample data match your expectations from the infographics in the annual report? If not, which demographic groups seem to be either over- or under-represented?
In your response, describe why you selected the test you did and verify its assumptions. Adequately explain how you interpret the output of the statistical test to answer these questions.
2. Have the rates of patients’ being Very Satisfied or their Likelihood to Recommend increased since the annual report was published?
In your response, describe why you selected the test you did and verify its assumptions. Adequately explain how you interpret the output of the statistical test to answer this question.
3. Is a patient’s likelihood to recommend the surgery center tied to their satisfaction level? Is it reasonable to expect that a program designed to increase patient satisfaction would be likely to result in more patient recommendations?
In your response, describe why you selected the test you did and verify its assumptions. Adequately explain how you interpret the output of the statistical test to answer these questions.
4. Is the average patient profitability (lifetime value) the same for the different procedures offered by the center? If not, which procedures have significantly higher or lower patient lifetime values compared to others?
In your response, describe why you selected the test you did and verify its assumptions. Adequately explain how you interpret the output of the statistical test to answer these questions.
(HINT: Run a one-way ANOVA to see if there is any difference among the different procedures. If you conclude a difference exists, then you should run a multiple comparison test to determine the significantly different pair of means)
Your managerial summary should include a description of the statistical tests used to answer each question, the necessary outputs and results for each test (test statistics, p-values, etc.) and should show that any required assumptions for those tests are valid. Use a 95% level of significance for any statistical tests.
NOTE: The data file you have received is in Excel format and has a
second worksheet
that defines the variables provided, shows their possible values and provides additional explanation of the data.
Rubric: Accuracy of answers to questions above (15 points each), write-up of results in a managerial report or research summary (15 points).
Total: 75 points
220818
MATH 810
–
PROJECT II
220818
MATH 810 APPLIED STATISTICS
ANALYSIS OF PATIENT OUTCOMES
–
75
points
You work for a regional healthcare system and have
been recently promoted
into an executive position
in which you have some administrative and financial responsibilities over additio
nal departments
including an
outpatient surgery center. As part of your onboarding and assessment of the new surgery
center, you’ve disco
vered tha
t
few analytics
on the surgery center’s
operations and profitability are
available. However, you were able to obtain
some anonymized
patient survey data that has
been
randomly
sam
pled
over the last several week
s
. The data includes information on procedur
es and their
outcomes, as well as some patient demographics, satisfaction
and
profitability
.
This
data set
has
been
included
here.
You also received a copy of last year’s internal annual report that
included the following
infographics
on patients
:
Use th
is
data
set
to build a
managerial summary
outlining your findings and recommendations
. Your
analysis should answer all of the follo
wing questions and should have outputs of the graphs or the
statistical tests
being used
.
1.
Do the gender and age range distributions in the sample data match your expectations
from the
infographics in the annual report? If not, which demographic groups
seem to be either over
-
or
under
-
represented?
In your response, describe why you selected the test you did and verify its assumptions.
Adequately explain how you interpret the output of the statistical test to answer these
questions.
MATH 810 – PROJECT II
220818
MATH 810 APPLIED STATISTICS
ANALYSIS OF PATIENT OUTCOMES – 75 points
You work for a regional healthcare system and have been recently promoted into an executive position
in which you have some administrative and financial responsibilities over additional departments
including an outpatient surgery center. As part of your onboarding and assessment of the new surgery
center, you’ve discovered that few analytics on the surgery center’s operations and profitability are
available. However, you were able to obtain some anonymized patient survey data that has been
randomly sampled over the last several weeks. The data includes information on procedures and their
outcomes, as well as some patient demographics, satisfaction and profitability. This data set has been
included here. You also received a copy of last year’s internal annual report that included the following
infographics on patients:
Use this data set to build a managerial summary outlining your findings and recommendations. Your
analysis should answer all of the following questions and should have outputs of the graphs or the
statistical tests being used.
1. Do the gender and age range distributions in the sample data match your expectations from the
infographics in the annual report? If not, which demographic groups seem to be either over- or
under-represented?
In your response, describe why you selected the test you did and verify its assumptions.
Adequately explain how you interpret the output of the statistical test to answer these
questions.
Barras
_MATH810ProjectII.docx
0
