Reference no: EM132352293
Assignment -
Patient Outcomes - 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. You also received a copy of last year's internal annual report that included the following infographics on patients:
Use this data to build a managerial summary outlining your findings and recommendations. Your analysis should answer all of the following questions and should have the outputs of the graphs or the statistical tests being used:
1. Provide summary for the observed data (FinalProject.xlsx) that is comparable to expected data from last year's internal annual report.
2. 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?
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?
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?
5. Your managerial summary should include a description of the statistical tests used to answer each question, the necessary results for each test (test statistics, p-values, etc.) and should show that any required assumptions for those tests are valid.
Note - Please answer all the questions mentioned above.
Attachment:- Biostatistics Assignment Files.rar