Cecilia Martinez - Improving Health Care Quality

1 Cover

2 Foreword

3 Preface

4 Acknowledgments

5 Acronyms and Synonyms

6 About the Companion Website

7 1 Introduction1.1 Key Concepts 1.2 Quality Improvement in Healthcare 1.3 Understanding Variability: The Key to QI 1.4 Quality Improvement Frameworks 1.5 Statistical Tools for Quality Improvement 1.6 Using this Casebook 1.7 Summary References

8 2 Improving Patient Satisfaction2.1 Key Concepts 2.2 DMAIC 2.3 PDCA 2.4 Background 2.5 The Task 2.6 The Data: ComplaintData.xlsx and PatientFeedback.jmp 2.7 Data Management 2.8 Analysis 2.9 Summary Reference

9 3 Length of Stay and Readmission for Hospitalized Diabetes Patients3.1 Key Concepts 3.2 DMAIC 3.3 PDCA 3.4 Background 3.5 The Task 3.6 The Data: HospitalReadmission.jmp 3.7 Data Management 3.8 Analysis 3.9 Summary

10 4 Identify and Communicate Opportunities for Reducing Hospital Length of Stay Using JMP ®Dashboards4.1 Key Concepts 4.2 DMAIC 4.3 PDCA 4.4 Background 4.5 The Task 4.6 The Data: HospitalReadmission.jmp 4.7 Data Management 4.8 Analysis 4.9 Summary References

11 5 Variability in the Cost of Hip Replacement5.1 Key Concepts 5.2 DMAIC 5.3 PDCA 5.4 Background 5.5 The Task 5.6 The Data: SouthernTier_HipReplacement.csv 5.7 Data Management 5.8 Analysis 5.9 Summary References

12 6 Benchmarking the Cost of Hip Replacement6.1 Key Concepts 6.2 DMAIC 6.3 PDCA 6.4 Background 6.5 The Task 6.6 The Data: HipNYSPARCS_SouthernTier.jmp 6.7 Data Management 6.8 Analysis 6.9 Summary References

13 7 Nursing Survey7.1 Key Concepts 7.2 DMAIC 7.3 PDCA 7.4 Background 7.5 The Task 7.6 The Data: NursingResearch_Survey_Responses.jmp 7.7 Data Management 7.8 Analysis 7.9 Summary References

14 8 Determining the Sample Size for a Nursing Research Study8.1 Key Concepts 8.2 DMAIC 8.3 PDCA 8.4 Background 8.5 The Task 8.6 The Data 8.7 Study Design and Data Collection Methodology 8.8 Analysis 8.9 Summary References

15 9 Mapping California Ambulance Diversion9.1 Key Concepts 9.2 DMAIC 9.3 PDCA 9.4 Background 9.5 The Task 9.6 The Data: ED_ambulance:diversion_trend.xlsx and CA_healthcare_facility_locations.xlsx 9.7 Data Management 9.8 Analysis 9.9 Summary References

16 10 Monitoring Ambulance Diversion Hours10.1 Key Concepts 10.2 DMAIC 10.3 PDCA 10.4 Background 10.5 The Task 10.6 The Data: CedarsSinai_Diversion_Hours.jmp 10.7 Data Management 10.8 Analysis 10.9 Summary References

17 11 Ambulatory Surgery Start Times11.1 Key Concepts 11.2 DMAIC 11.3 PDCA 11.4 Background 11.5 The Task 11.6 The Data: ASU.jmp 11.7 Data Management 11.8 Analysis 11.9 Summary Reference

18 12 Pre‐Op TJR Process Improvement – Part 112.1 Key Concepts 12.2 DMAIC 12.3 PDCA 12.4 Background 12.5 The Task 12.6 The Data: TJR.xlsx 12.7 Data Management 12.8 Analysis 12.9 Summary Reference

19 13 Pre‐Op TJR Process Improvement – Part 213.1 Key Concepts 13.2 DMAIC 13.3 PDCA 13.4 Background 13.5 The Task 13.6 The Data: TJR.jmp 13.7 Data Management 13.8 Analysis 13.9 Summary References

20 14 Pre‐Op TJR Process Improvement – Part 314.1 Key Concepts 14.2 DMAIC 14.3 PDCA 14.4 Background 14.5 The Task 14.6 The Data: TJR.jmp 14.7 Data Management 14.8 Analysis 14.9 Summary References

21 Index

22 End User License Agreement

1 Chapter 1 Table 1.1 Summary of statistical tools.

2 Chapter 2 Table 2.1 Variable definitions for complaint data. Table 2.2 Variable definitions for patient feedback data.

3 Chapter 3Table 3.1 Variable definitions.

4 Chapter 4Table 4.1 Saving and sharing dashboards.

5 Chapter 7Table 7.1 Data definitions for nursing survey responses.

6 Chapter 8Table 8.1 Differences to detect for various sample sizes.Table 8.2 Summary of Tools and JMP Features.

7 Chapter 10Table 10.1 Data definitions for Cedars‐Sinai ambulance diversion.

8 Chapter 11Table 11.1 Variable definitions.Table 11.2 2018 data for surgeon 1.

9 Chapter 12Table 12.1 Variable definitions.

10 Chapter 14Table 14.1 Summary of ‐tests for process segments.

1 Chapter 1 Figure 1.1 Process map for the preoperative total joint replacement. Figure 1.2 Framework‐type of problem matrix. Figure 1.3 Statistical analysis process in QI framework. Figure 1.4 Types of control charts. Figure 1.5 Case structure and DMAIC and PDCA frameworks.

2 Chapter 2 Figure 2.1 Importing complaint data with JMP Excel Import Wizard.(Navigate t... Figure 2.2 The complaint data in JMP. Figure 2.3 Pareto chart of complaint data.(Analyze > Distribution; Select Co...Figure 2.4 Summary statistics – Percent Would Recommend.(Analyze > Tabulate;...Figure 2.5 Run chart – Percent Would Recommend.(Graph > Graph Builder; Drag ...Figure 2.6 Run chart – all four measures.(From Graph Builder report produced...Figure 2.7 Distributions with dynamic linking.(Analyze > Distribution; Drag ...Figure 2.8 Summary statistics – all four measures.(From Tabulate report prod...Figure 2.9 Correlations and Scatterplot Matrix.(Analyze > Multivariate Metho...

3 Chapter 3Figure 3.1 Run chart of time in hospital.(Click on Graph Graph Builder; Dr...Figure 3.2 Distributions of time in hospital and readmitted.(Click on Analyz...Figure 3.3 Distributions of time in hospital and readmitted with readmit 30...Figure 3.4 Bar charts for gender and race.(Follow same steps as in Figure 3....Figure 3.5 Line plot of time in hospital by gender.(Follow same steps as in ...Figure 3.6 Line plot of time in hospital by race.(Follow same steps as in Fi...Figure 3.7 Line plot of time in hospital by race with selected categories hi...Figure 3.8 Tree map of primary diagnosis and time in hospital.(Open Graph Bu...

4 Chapter 4Figure 4.1 Dashboard using combine windows.(Select Combine Windows from the ...Figure 4.2 Dashboard Builder Templates.(From the File menu select New Dash...Figure 4.3 Dashboard template.(Click on the Template.)Figure 4.4 Dashboard line plots of time in hospital.(Drag the Time in Hospit...Figure 4.5 dashboard line plots of time in hospital with Tabbed Report, Ti...Figure 4.6 Dashboard with local data filter. Panel (a) gives results for Fem...

5 Chapter 5Figure 5.1 Data table column list.Figure 5.2 Columns viewer summary of hip replacement data.(Cols Column Vie...Figure 5.3 Distribution of Facility Name.Figure 5.4 Setting value ordering for APR Risk of Mortality.(Right click in ...Figure 5.5 Recode dialog to create column for shortened Facility Name.(Cols Figure 5.6 Descriptive statistics for hospital geographic characteristics.(A...Figure 5.7 Descriptive statistics for patient admission.Figure 5.8 Distribution output for total cost.(Analyze Distribution.)Figure 5.9 Search dialog to find Our Lady of Lourdes Hospital observation.(E...Figure 5.10 Total cost histograms by hospital.(Graph Graph Builder. Drag T...Figure 5.11 Total cost box plots by hospital.(Graph Graph Builder. Drag To...Figure 5.12 Descriptive statistics for cost by hospital.(Analyze Tabulate....