Watch How to Use QI Macros to Draw Charts Described in

Health Care Data Guide, by Provost and Murray

Health Care Data GuideA popular Healthcare book on performance measurement is the Health Care Data Guide, ©2011 by John Wiley & Sons. The book covers how to use control charts to analyze and maintain patient safety and quality.

It's easy to use the QI Macros to create the run charts, p/u charts and XmR charts that feature prominently in the book. If you have installed QI Macros (purchased or trial) you already have an Excel spreadsheet containing many of the data sets described in this book. Look in: My Documents > QI Macros Test Data > HealthcareData Guide.xlsx.

Watch the videos below to learn how to use QI Macros to create each chart. The page reference for the data used in each video is listed to the right. The book doesn't contain the data for all of the charts, but these should get you started.

Health Care Data Guide Chart Page
Patient Falls - Run Chart, p chart and XmR Chart 53
Unplanned Returns to the OR - p Chart 95
Patient Satisfaction - CUSUM 102
Wait Time vs Satisfaction - Scatter Chart 110
Infectious Waste - p Chart 156
Radiology Turnaround Time - XbarS Chart 160
Patient Harm - p Chart 167
Hospital Readmission Rate - p Chart 170
MRSA - p Chart 171
LVSD - p Chart 174
Needle Sticks - c Chart 177
Flash Sterizations - p Chart 180
Adverse Drug Events - u Chart 181
Complaints - p Chart 183
Patient Satisfaction - p Chart 240
Financial - Hotelling T2 Chart 240
Patient Management - p' Chart 270
Diabetic Self-manage goals - p Chart 273
Adverse Drug Events - p Chart 290
ADEs by location 293
Medication Harm Pareto 304
Patient Satisfaction Scores 339
Infection Rates - XmR Chart 357
CABG Infections - p Chart 389
Comparing CABG Infection Rates - p Chart 393
C Section - p Chart 401
CHF Readmissions - p Chart 420
Recommendations for p and XmR dashboards of measures  

How to create run chart, p charts and XmR Charts of Patient Falls

How to create p chart of Unplanned Returns to the OR

How to create CUSUM chart of Patient Satisfaction

How to create scatter chart of Wait Time vs Patient Satisfaction

How to create p chart of Infectious Waste

How to create an XbarS chart of Radiology Turnaround Times

How to create p chart of Patient Harm

How to create p chart of Hospital Readmissions

How to create p chart of MRSA

How to create p chart of LVSD

How to create c chart of Needle Sticks

How to create p chart of Flash Sterilizations

How to create u chart of Adverse Drug Events (ADE)

How to create u chart of Complaints

How to create p chart of Patient Satisfaction

How to create Hottelling T2 chart of Financials

How to create p' chart of Patient Management by Phone

How to create p chart of Diabetic Self-Managed Goals

How to create u chart of ADEs

How to create p chart of ADEs By Hospital

How to create Pareto Chart of Medication Harm

How to create p chart and Pareto Charts of Patient Satisfaction Scores

How to create p chart of Infection Rates

How to create u chart of CABG Infections

How to create p chart of CABG Infections

How to create p chart of C Sections by Hospital and physician

How to create p chart of CHF Readmissions

How to create p and XmR dashboards of health care data

Learn How QI Macros Meets or Exceeds IHI Improvement Advisor Requirements (Click Here)

Find the Health Care Data Guide Data in QI Macros Test Data

Health Care Data Guide Data in QIMacros

Create these charts and diagrams in just seconds using QI Macros for Excel...

« Back

Join 100,000+ Users
in 80 Countries
SPC Software review


Why Choose QI Macros ?

Affordable - Just $ 299 USD per license
- Less with Quantity Discounts
- No Recurring Annual Fees
- No Charge for Technical Support

Easy to Use
 - Adds New Tab to Excel's Menu
- Creates a Chart in Seconds
- PC / Mac: Excel Excel 2013-2019, Office 365

Trusted / Accurate
- 100,000 Users in 80 Countries
- Save Time vs Writing Formulas
- Our Formulas Are Tested

Download 30-day Trial Buy QI Macros Now

Read What Others Say
- CNET Five Star Review
- Industry Leaders

Our Customers

Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now