Fluent Essays

Assignment 4- Presenting Statistical Results for Decision Making Overview Create an 8–10-slide PowerPoint presentation about the statistical results with recommendations to health system leadership and a 2–4-page executive summary that provides additional context to the results of data analysis. The ability to translate analytic results into clear, concise, and actionable results is a vital skill for health care administrators. Because decision making is increasingly data-driven and evidence-based, managers are frequently required to formally present statistical results to leadership. Sometimes, decision makers differ as to how well they comprehend the information being delivered. Your job as a health care professional is to know how to distill and synthesize data analytics and present complex concepts in the pursuit of value, quality, and safety. You must be able to clearly communicate the results of your teams data analysis that is both insightful and informative. How much your work is valued can depend heavily on how well the results of that analysis are articulated. Effectively communicating the results so the issues and recommendations are clear and explicit can greatly enhance the value of your analytic work. For this assessment, you will evaluate the approach of an analytics team and interpret and present statistical results to support a health care recommendation. Competency 1: Plan for data collection, measurement, and analysis.Evaluate the data collection, measurement, and analysis tools and techniques used in the data analysis.Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice.Interpret statistical results used in the data analysis.Competency 4: Present results of data analysis to support a decision or recommendation.Present statistical results used in the data analysis to support a health care recommendation.Recommend solution based on results of the data analysis.Use media and technology to convey ideas and information.Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style. Write clearly and concisely, using correct grammar, mechanics, and APA formatting. Resources Evaluating Data Analysis Davenport, T. H. (2015, October 21). 5 essential principles for understanding analytics. Harvard Business Review Digital Articles, 2–4.Li, M. (2015, October 27). The two questions you need to ask your data analysts. Harvard Business Review Digital Articles, 2–4.Simpson, S. H. (2015). Creating a data analysis plan: What to consider when choosing statistics for a study. Canadian Journal of Hospital Pharmacy, 68(4), 311–317. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC45522... Communicating About Data Davenport, T. H. (2013, June 18). Data is worthless if you don’t communicate it. Harvard Business Review Digital Articles, 2–3. Presenting Analytic Results Presenting Analytics Results.Sue, V. M., & Griffin, M. T. (2016). Data visualization & presentation with Microsoft Office. Thousand Oaks, CA: Sage.Chapter 10, Creating Presentations. Reporting Statistics Darling, N. (2017). Reporting statistics in APA style. Retrieved from https://www.psychologytoday.com/us/blog/thinking-a... Effective Presentations Theobald, T. (2016). Develop your presentation skills. London, UK: Kogan Page.Faroult, S. (2016). Getting the message across: Using Slideware effectively in technical presentations. New York, NY: Apress. PowerPoint Capella University Library: PowerPoint Presentations.Microsoft. (n.d.). Create a presentation in PowerPoint. Retrieved from https://support.office.com/en-gb/article/create-a-... Assessment Instructions Preparation Complete the following simulation: Vila Health: Presenting Statistical Results for Decision Making. In this simulation, you will evaluate, interpret, and present statistical results to support a health care recommendation. Instructions This assessment has two deliverables: Prepare an 8–10-slide PowerPoint presentation about the statistical results with recommendations to health system leadership.Ensure the slides graphically communicate the findings.Ensure your presentation is relevant to and easily understood by everyone in the audience. Be sure your written communication is free of errors that detract from the overall messageInclude an APA-formatted references slide at the end of the presentation.Use Kaltura or similar software to record your presentation. The presentation should last no more than 3 minutes, and it should contain audio of you speaking. You may use alternative programs or technology, provided you can still create a presentation with visuals and recorded audio.Before you begin recording, create a script, speaker notes, or a detailed outline that you can refer to as you record. This professional best practice will help you prepare for your presentation and serve to clarify any insufficient or unclear audio in your recording.Write a 2–4-page executive summary to accompany the PowerPoint presentation that provides additional context to the results of data analysis. Include APA-formatted in-text citations where appropriate. Submit the recording of your presentation and the executive summary. Grading Criteria The numbered assessment instructions outlined below correspond to the grading criteria in the Presenting Statistical Results for Decision Making Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed. Evaluate the data collection, measurement, and analysis tools and techniques used in the data analysis. Interpret statistical results used in the data analysis.Present statistical results used in the data analysis to support a health care recommendation.Recommend solution based on results of the data analysis. Use media and technology to convey ideas and information.Write clearly and concisely, using correct grammar, mechanics, and APA formatting. Additional Requirements Your executive summary should meet the following requirements: Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.Length: 2–4 pages.Resources: Include sources where appropriate within the template, reference list last page.APA format: Cite your sources using current APA format.Font and font size: Times Roman, 10 point data_analysis_health_care_decisions_assignment_4_details_and_instructions.docx data_analysis_health_care_decisions_assignment_4_hac_analysis.xlsx data_analysis_health_care_decisions_assignment_4_vila_health__presenting_statistical_results_for_decision_making.pdf data_analysis_health_care_decisions_assignment_4_grading_rubrics.pdf Unformatted Attachment Preview Assignment 4- Presenting Statistical Results for Decision Making Overview Create an 8–10-slide PowerPoint presentation about the statistical results with recommendations to health system leadership and a 2–4-page executive summary that provides additional context to the results of data analysis. The ability to translate analytic results into clear, concise, and actionable results is a vital skill for health care administrators. Because decision making is increasingly data-driven and evidence-based, managers are frequently required to formally present statistical results to leadership. Sometimes, decision makers differ as to how well they comprehend the information being delivered. Your job as a health care professional is to know how to distill and synthesize data analytics and present complex concepts in the pursuit of value, quality, and safety. You must be able to clearly communicate the results of your teams data analysis that is both insightful and informative. How much your work is valued can depend heavily on how well the results of that analysis are articulated. Effectively communicating the results so the issues and recommendations are clear and explicit can greatly enhance the value of your analytic work. For this assessment, you will evaluate the approach of an analytics team and interpret and present statistical results to support a health care recommendation. • o • o • o o o • o Competency 1: Plan for data collection, measurement, and analysis. Evaluate the data collection, measurement, and analysis tools and techniques used in the data analysis. Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice. Interpret statistical results used in the data analysis. Competency 4: Present results of data analysis to support a decision or recommendation. Present statistical results used in the data analysis to support a health care recommendation. Recommend solution based on results of the data analysis. Use media and technology to convey ideas and information. Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style. Write clearly and concisely, using correct grammar, mechanics, and APA formatting. Resources Evaluating Data Analysis • • • Davenport, T. H. (2015, October 21). 5 essential principles for understanding analytics. Harvard Business Review Digital Articles, 2–4. Li, M. (2015, October 27). The two questions you need to ask your data analysts. Harvard Business Review Digital Articles, 2–4. Simpson, S. H. (2015). Creating a data analysis plan: What to consider when choosing statistics for a study. Canadian Journal of Hospital Pharmacy, 68(4), 311– 317. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4552232/ Communicating About Data • Davenport, T. H. (2013, June 18). Data is worthless if you don’t communicate it. Harvard Business Review Digital Articles, 2–3. Presenting Analytic Results • • o Presenting Analytics Results. Sue, V. M., & Griffin, M. T. (2016). Data visualization & presentation with Microsoft Office. Thousand Oaks, CA: Sage. Chapter 10, Creating Presentations. Reporting Statistics • Darling, N. (2017). Reporting statistics in APA style. Retrieved from https://www.psychologytoday.com/us/blog/thinking-aboutkids/201704/reporting-statistics-in-apa-style Effective Presentations • • Theobald, T. (2016). Develop your presentation skills. London, UK: Kogan Page. Faroult, S. (2016). Getting the message across: Using Slideware effectively in technical presentations. New York, NY: Apress. PowerPoint • • Capella University Library: PowerPoint Presentations. Microsoft. (n.d.). Create a presentation in PowerPoint. Retrieved from https://support.office.com/en-gb/article/create-a-presentation-in-powerpoint422250f8-5721-4cea-92cc-202fa7b89617 Assessment Instructions Preparation Complete the following simulation: • Vila Health: Presenting Statistical Results for Decision Making. In this simulation, you will evaluate, interpret, and present statistical results to support a health care recommendation. Instructions This assessment has two deliverables: 1. Prepare an 8–10-slide PowerPoint presentation about the statistical results with recommendations to health system leadership. o Ensure the slides graphically communicate the findings. o Ensure your presentation is relevant to and easily understood by everyone in the audience. o Be sure your written communication is free of errors that detract from the overall message o Include an APA-formatted references slide at the end of the presentation. o Use Kaltura or similar software to record your presentation. The presentation should last no more than 3 minutes, and it should contain audio of you speaking. You may use alternative programs or technology, provided you can still create a presentation with visuals and recorded audio. o Before you begin recording, create a script, speaker notes, or a detailed outline that you can refer to as you record. This professional best practice will help you prepare for your presentation and serve to clarify any insufficient or unclear audio in your recording. 2. Write a 2–4-page executive summary to accompany the PowerPoint presentation that provides additional context to the results of data analysis. o Include APA-formatted in-text citations where appropriate. Submit the recording of your presentation and the executive summary. Grading Criteria The numbered assessment instructions outlined below correspond to the grading criteria in the Presenting Statistical Results for Decision Making Scoring Guide, so be sure to address each point. You may also want to review the performancelevel descriptions for each criterion to see how your work will be assessed. 1. Evaluate the data collection, measurement, and analysis tools and techniques used in the data analysis. 2. Interpret statistical results used in the data analysis. 3. Present statistical results used in the data analysis to support a health care recommendation. 4. Recommend solution based on results of the data analysis. 5. Use media and technology to convey ideas and information. 6. Write clearly and concisely, using correct grammar, mechanics, and APA formatting. Additional Requirements Your executive summary should meet the following requirements: • • • • • Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately. Length: 2–4 pages. Resources: Include sources where appropriate within the template, reference list last page. APA format: Cite your sources using current APA format. Font and font size: Times Roman, 10 point Variable Name HAC_Rate Nursing_HPPD Skill_Mix ALOS Financial Assumptions: Hospital discharges Nursing cost per year RN cost per year LPN cost per year Hospital cost per inpatient day Hospital penalty per HAC Description Definition Hospital-acquired condition rate Nursing hours per patient day Number of hospital-acquired conditions (HAC) per 1,000 discharges; measures extent of hospital errors Number of nursing staff hours per patient day (HPPD); measures nurse staffing level Percentage of nursing staff hours provided by Registered Nurses (RN); measures skill mix of nursing staff Number of inpatient days per hospital discharge; measures hospital efficiency Nursing skill mix Average length of stay 10,000 Average of RN and LPN nursing cost; cost includes $72,000 salary, benefits, and overhead $85,000 $52,000 $2,600 $5,700 HAC_Rate Nursing_HPPD Skill_Mix ALOS 108 5.017 60.22 4.017 106 5.057 60.68 4.057 112 4.184 59.99 4.184 116 4.202 58.82 5.202 107 6.249 62.53 4.249 119 3.315 58.92 4.315 109 5.401 60.69 4.401 116 4.418 59.8 5.418 115 3.532 58.94 4.532 119 3.626 59.24 5.626 114 4.629 61.15 4.629 113 4.662 60.67 4.662 119 3.681 59.74 5.681 114 4.703 59.77 4.703 106 6.719 60.26 4.719 115 4.812 60.6 5.812 107 5.824 62.25 4.824 111 4.857 60.45 4.857 117 4.062 59.5 7.062 114 4.153 58.74 5.153 115 4.204 60.08 5.204 111 5.311 60.88 5.311 116 4.361 60.43 5.361 120 3.733 60.3 5.733 120 2.77 61.3 5.77 120 3.802 58.34 5.802 120 2.812 61.12 5.812 113 3.933 58.86 5.933 107 4.955 60.39 5.955 116 4.006 60.47 6.006 118 4.006 60.27 6.006 118 4.024 61.48 6.024 122 2.1 59.16 6.1 118 4.104 59.63 6.104 119 3.176 59.05 6.176 125 2.18 58.95 6.18 115 4.216 60.51 6.216 119 2.275 58.16 6.275 110 5.282 60.12 6.282 120 4.304 59.79 6.304 119 4.367 59.26 6.367 121 2.456 59.43 6.456 123 4.504 60.54 6.504 119 3.509 59.81 6.509 114 4.545 59.61 6.545 123 2.565 59.31 6.565 122 123 123 122 121 121 119 121 122 120 107 117 120 121 120 120 121 122 118 118 120 118 118 122 120 115 118 112 118 110 119 119 118 125 126 120 115 112 113 109 119 116 124 117 119 125 126 2.62 4.64 2.682 3.741 3.878 3.881 2.891 3.909 2.971 3.99 5.013 3.154 4.22 4.223 4.249 3.287 2.308 2.321 3.341 4.343 3.344 4.383 4.415 2.466 3.485 3.576 4.616 4.635 3.644 5.654 3.724 3.774 3.187 2.212 2.212 3.454 4.533 3.614 4.714 5.731 3.817 4.836 3.924 4.043 4.489 2.541 1.628 59.88 61.38 58.62 58.67 60.01 58.31 58.27 59.48 60.31 59.76 60.11 60.01 60.7 60.57 60.26 58.41 59.26 58.59 58.68 60.1 60.26 61.81 59.3 59.88 60.29 58.95 59.95 59.69 60.56 61.09 59.06 60.15 60.33 58.99 60.81 58.07 59.88 58.62 58.67 62.29 60.48 60.65 61.72 60.51 59.18 58.87 60.95 6.62 6.64 6.682 6.741 6.878 6.881 6.891 6.909 6.971 6.99 7.013 7.154 7.22 7.223 7.249 7.287 7.308 7.321 7.341 7.343 7.344 7.383 7.415 7.466 7.485 7.576 7.616 7.635 7.644 7.654 7.724 7.774 8.187 8.212 8.212 8.454 8.533 8.614 8.714 6.731 8.817 8.836 8.924 8.043 9.489 9.541 9.628 111 110 4.768 4.918 60.84 59.9 8.768 8.918 HAC_Rate HAC_Rate Nursing_HPPD Skill_Mix ALOS 1 -0.799400102 -0.304808429 0.417162987 Nursing_HPPD Skill_Mix 1 0.4617178 1 -0.312434971 -0.133376169 ALOS 1 HAC_Rate Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0\%) Nursing_HPPD 117.1578947 0.502026306 118 119 4.893147161 23.94288914 -0.30555851 -0.567810177 20 106 126 11130 95 0.996784999 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0\%) 3.943178947 0.100927519 4.006 4.006 0.983719775 0.967704595 0.064807972 -0.005149876 5.091 1.628 6.719 374.602 95 0.200393956 Skill_Mix Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0\%) ALOS 59.92989474 0.099670622 59.99 60.26 0.971469051 0.943752116 -0.13681883 0.26791489 4.46 58.07 62.53 5693.34 95 0.197898356 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0\%) 6.669494737 0.138704512 6.682 5.812 1.351924349 1.827699444 -0.490963757 0.034698395 5.611 4.017 9.628 633.602 95 0.275401059 106 108.2222222 110.4444444 112.6666667 114.8888889 117.1111111 119.3333333 121.5555556 123.7777778 More Frequency 2 5 5 6 7 14 22 18 10 6 Histogram 25 20 15 Frequency Bin 10 5 0 106 108.2222222 110.4444444 112.6666667 Histogram of HAC_Rate Frequency 112.6666667 114.8888889 117.1111111 119.3333333 121.5555556 123.7777778 Bin More SUMMARY OUTPUT Regression Statistics Multiple R 0.802678891 R Square 0.644293402 Adjusted R Square 0.63656065 Standard Error 2.949879331 Observations 95 ANOVA df Regression Residual Total Intercept Nursing_HPPD Skill_Mix 2 92 94 SS 1450.067077 800.5645022 2250.631579 MS F Significance F 725.0335384 83.32006396 2.2399E-21 8.701788068 Coefficients Standard Error t Stat P-value 108.9131046 20.56372053 5.296371559 8.01413E-07 -4.163970655 0.348684101 -11.94195733 2.1004E-20 0.411548722 0.353081187 1.165592327 0.246792365 Dependent variable: HAC_Rate Lower 95\% 68.07178059 -4.856487377 -0.289700992 Upper 95\% Lower 95.0\% Upper 95.0\% 149.7544285 68.07178059 149.7544285 -3.471453933 -4.856487377 -3.471453933 1.112798436 -0.289700992 1.112798436 SUMMARY OUTPUT Regression Statistics Multiple R 0.417162987 R Square 0.174024958 Adjusted R Square 0.165143506 Standard Error 1.235259791 Observations 95 ANOVA df Regression Residual Total Intercept HAC_Rate 1 93 94 SS 29.89813997 141.9056078 171.8037477 MS F Significance F 29.89813997 19.59420111 2.60411E-05 1.52586675 Coefficients Standard Error t Stat P-value -6.833852645 3.05317804 -2.238275186 0.027589369 0.115257682 0.026037909 4.426533758 2.60411E-05 Dependent variable: ALOS Lower 95\% -12.89685914 0.063551556 Upper 95\% Lower 95.0\% Upper 95.0\% -0.770846153 -12.89685914 -0.770846153 0.166963808 0.063551556 0.166963808 12/31/2019 Vila Health: Presenting Statistical Results for Decision Making Vila Health ® Activity Presenting Statistical Results for Decision Making Introduction Your Office Stakeholder Interviews Email Response Conclusion Introduction At any enterprise, statistical results can point the way to better decisions. This is especially true in health care, where trends or changes in patient care or results can have powerful effects on health care organizations — clinical effects, and financial effects. Knowing the facts about trends and changes is crucial to navigating them, which means that in many ways, statistical results are powerful tools. But they’re less powerful if nobody understands them. More often than not, stakeholders in health care organizations are not well versed in statistics or data analysis. Especially for these stakeholders, it’s critical to make careful choices about which numbers to include — and how to talk about those numbers. Doing so helps you to present statistical results in a way that’s understandable and actionable even for those with less data literacy. In this activity, you’ll have an opportunity to analyze a health trend at a large urban hospital, and to decide which results of the analysis are most important to communicate to the stakeholders concerned with it. Your Office You are an analyst in the Quality Assurance department at St. Anthony Medical Center, a large hospital in Minneapolis, Minnesota. You have an email from David Brooks, the manager of Quality Assurance, in which he media.capella.edu/CourseMedia/mhafp5017element17931/transcript.asp#introduction 1/5 12/31/2019 Vila Health: Presenting Statistical Results for Decision Making explains your next assignment. Email From: David Brooks Subject: HACs Hello! So I’m aware that you’re relatively new around here, but I’ve got to pull you in on an important project. Here’s the short version, and I can answer questions later if this isn’t enough background. Since you’re in health care, you must know that hospital-acquired conditions (HACs) are a big deal. Hospitals are designed from the ground up to minimize them, but the fact is that hospitals always have a lot of bugs floating around and that means they’re a constant danger. And while we try to minimize mistakes, health care professionals are human, and sometimes mistakes cause real problems. The hospital’s board is getting worked up about them again, because we’ve had some high-profile cases where a patient went home and had to be readmitted because of a mistake or an infection they picked up while they were here. They’re worried about PR, of course, but they’re worried about patient outcomes, and — of course — financial reimbursement and penalties, too. What I need you to do is start working on a presentation about HACs here, specifically as they relate to staffing levels and skill mix. That presentation should explain our recommendations to the board. You’ll want to include some statistics to bolster our case, so take a look at the AHRQ National Scorecard on Hospital-Acquired Conditions (https://www.ahrq.gov/sites/default/files/wysiwyg/professionals/qualitypatient-safety/pfp/hacreport-2019.pdf) and the CMS Hospital-Acquired Conditions Reduction Program (https://www.cms.gov/medicare/medicare-fee-for-servicepayment/acuteinpatientpps/hac-reduction-program.html). Look at published research about the relationship between HACs and staffing levels, too. Let’s get this right; this is our chance to get the board to understand that HACs will go down if they do what we recommend. Go talk to Rick Susskind first; he’s our senior data analyst and he’s already been working on this. He has completed a data analysis on this, and he can explain what the variables are. You’ll have to talk to a few other people too, to get everything you need. media.capella.edu/CourseMedia/mhafp5017element17931/transcript.asp#introduction 2/5 12/31/2019 Vila Health: Presenting Statistical Results for Decision Making David Email From: Rick Suskind Subject: HAC Data Hi! I got your message about the HAC question. I’ve attached a spreadsheet of the data analysis we’ve got on that. Here are a few variables that might be unclear: HAC_Rate: That’s the number of HACs per 1,000 discharges. You could say it’s the measure for the extent of hospital errors. Nursing_HPPD: That’s the number of nursing staff hours per patient day. It’s the hospital’s nurse staffing level. Skill_Mix: That’s obviously about skill mix, but specifically, it’s the percentage of nursing staff hours that are provided by registered nurses, as opposed to other professionals. ALOS: That stands for average length of stay; it’s the number of inpatient days per hospital discharge. It’s a measure of how efficient the hospital is. Let me know if you have other questions! Oh, you’ll need to find out how many discharges we have per year. I don’t know that, but Troy Holland, our vice president of patient services, will know. Attachment: HAC Analysis (downloads/HAC Analysis.xlsx) Stakeholder Interviews Troy Holland Vice President of Patient Services It’s nice to meet you! Yep, I’ve got those discharge stats. I’m assuming you’re confining your analysis to the last full year? If so, the number of discharges for last year was 10,000. That includes both adult and pediatric discharges. What I don’t have is information about nurse staffing or costs. For those, you’ll want to talk to Jackie, the chief nursing officer. media.capella.edu/CourseMedia/mhafp5017element17931/transcript.asp#introduction 3/5 12/31/2019 Vila Health: Presenting Statistical Results for Decision Making Jackie Sandoval Chief Nursing Officer Hello. I understand you need some data about our staff costs related to nursing. I’ve got three numbers for you. Our cost per nurse is $72,000. Now, that’s an average of nurses and registered nurses. Our cost per registered nurse is $85,000. Per licensed practical nurse, it’s $52,000. Those numbers include salary, benefits, and overhead. You had asked about some other costs, but I don’t have those. You’ll want to talk to the CFO, Owen Welch. Owen Welch Chief Financial Officer Hey, I’ve only got a couple of minutes but here’s what you asked about: Our cost per inpatient day is $2,600, and the penalty per HAC is $5,700. Email Response It looks like David has followed up with you about the data analysis project you’re working on. Review Davids latest message to you and send a reply with your initial thoughts. Email From: David Brooks Subject: HACs Thanks for doing all that running around. Now that you’ve got the data analysis you need, I’d like you to do some thinking about what results you’re going to include in the presentation. Remember, it’s the board, not a bunch of number geeks. You’ll want to give them the statistical results they need to make a decision, not just every bit of data we have. Write down a list of numbers you’re thinking about including in your presentation. We really need to make a data-driven recommendation to the board, and I’d really apprecia ... Purchase answer to see full attachment