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.

1. 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.

1. 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.

1. 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).

Gender Female Male 55% 45%