Watch How to Use QI Macros to Draw Charts Described in
Health Care Data Guide, by Provost and Murray
A 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.
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
Create these charts and diagrams in just seconds using QI Macros for Excel...
« Back
Join 100,000+ Users
in 80 Countries
Why Choose QI Macros ?
Affordable - Just $
249 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 XL2007-2016
Trusted /
Accurate
- 100,000 Users in 80 Countries
- Save Time vs Writing Formulas
- Our Formulas Are Tested
Read What Others Say
- CNET Five Star Review
- Industry Leaders
