Mini Project 2 In Mini Project 2, you are required to use the data and the business scenario provided and the research you do on your own to answer some questions You will need to manipulate the data provided in order to answer questions and provide a managerial report Patient Survey Data Analysis 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 Thisdata sethas been included here Download here You also received a copy of last year's internal annual report, which included the following infographics on patients Use the data set provided above 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 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 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 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 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 NOTES Thedata fileis in Excel format and has a second worksheet that defines the variables provided, shows their possible values, and provides additional explanation of the data You can find theproject documentin Word here Download here You may also utilizeSmarthinkingtutoring to help you with this assignment REMEMBER that in Module 12, you will present your Mini Project 1, 2, or 3 report (based on the condition you were assigned to) in a class meeting You will discuss your problem and solution with other students Submission Instructions PatientlD Anonymous patient numerical identifier Gender M male F female Age Range 18 to 34, 35 to 54, 55 to 74, 75 to 90, and 90 Procedure Bariatric, Orthopedic, Cardiovascular, or Oncology Outcome Short Average or shorter than expected length of stay (possibly outpatient) Long Longer than expected stay, but no post procedure infection(s) Longlnf Longer than expected stay with post procedure infection(s) Satisfaction Very Dissatisfied, Somewhat Dissatisfied, Somewhat Satisfied, and Very Satisfied (post procedure patient reported data) WouldRec Y Yes, N No (post procedure patient reported data) LTV Lifetime Value Index of patient to health system profitability predictive model assigned by health system analytics team 100 average patient value (200 twice the average patient value, 80 80 of average patient value, etc )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

Mini Project 2 In Mini Project 2, you are required to use the data and the business scenario provided and the research you do on

Mini Project 2

In Mini Project 2, you are required to use the data and the business scenario provided and the research you do on your own to answer some questions. You will need to manipulate the data provided in order to answer questions and provide a managerial report.

Patient Survey Data Analysis

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. Thisdata sethas been includedhereDownload here. You also received a copy of last year's internal annual report, which included the following infographics on patients:

Use the data set provided above to build amanagerial summaryoutlining 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.
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)
5. 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.

NOTES:

Thedata fileis in Excel format and has asecond worksheetthat defines the variables provided, shows their possible values, and provides additional explanation of the data.
You can find theproject documentin WordhereDownload here.
You may also utilizeSmarthinkingtutoring to help you with this assignment.

REMEMBERthat in Module 12, you will present your Mini-Project 1, 2, or 3 report (based on the condition you were assigned to) in a class meeting. You will discuss your problem and solution with other students.

Submission Instructions

PatientlD Anonymous patient numerical identifier Gender M = male; F = female Age_Range 18 to 34, 35 to 54, 55 to 74, 75 to 90, and 90+ Procedure Bariatric, Orthopedic, Cardiovascular, or Oncology Outcome Short = Average or shorter than expected length of stay (possibly outpatient); Long = Longer than expected stay, but no post-procedure infection(s); Longlnf = Longer than expected stay with post-procedure infection(s) Satisfaction Very Dissatisfied, Somewhat Dissatisfied, Somewhat Satisfied, and Very Satisfied (post- procedure patient reported data) WouldRec Y = Yes, N = No (post-procedure patient reported data) LTV Lifetime Value Index of patient to health system profitability; predictive model assigned by health system analytics team; 100 = average patient value (200 = twice the average patient value, 80 = 80% of average patient value, etc.)