Excel Python SQL Worksheet
Which Chart Is Right?By Farrokh Alemi Ph.D.
HEALTH INFORMATICS PROGRAM
HI.GMU.EDU
Types of Charts
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
• XmR
• X-bar
• Tukey
• Time-in-between
• P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
• Risk-adjusted XmR
• Risk-adjusted X-bar
• Risk-adjusted Tukey
• Risk-adjusted Time-in-between
• Risk-adjusted P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
CONTINUOUS MEASURES
• Length of stay
• Average length of stay
• Average age of a specific
patient population
• Turn around time
• Staff salaries
• Severity of medication
errors
• Individual patient’s
weights
• Individual patient’s blood
sugar
HEALTH INFORMATICS PROGRAM
• Patient satisfaction
average scores
• Infectious waste
poundage generated
• Electrical usage
• Wait times
• Accounts receivable
balances
• Time in restraints
• Time before hanging up
the phone
• SF – 36 scores
GEORGE MASON UNIVERSITY
RATES & DISCRETE MEASURES
• Employee accidents
• Percent of patients with
• Patient falls
insurance
• Nosocomial infection rates • Percent of patients who
• Percent of patients in
rated the facility as
restraints
excellent
• Medication error rate
• Telephone abandonment
• Adverse event rate
rates
• C-Section rates
• Pressure ulcer rates
• Dietary tray errors
• Employee injuries rates
• Delinquent medical records • Percent with appropriate
• Patients who kept their
documentation
resolutions
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
If continuous variable
If one data point per time period
If outliers likely: Tukey chart
If outliers not likely: XmR chart
If multiple data points per time period: Xbar chart
If discrete event
If event is rare: Time-in-between chart
If event is not rare: P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
If continuous variable
If one data point per time period
If outliers likely: Tukey chart
If outliers not likely: XmR chart
If multiple data points per time period: Xbar chart
If discrete event
If event is rare: Time-in-between chart
If event is not rare: P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
If continuous variable
If one data point per time period
If outliers likely: Tukey chart
If outliers not likely: XmR chart
If multiple data points per time period: Xbar chart
If discrete event
If event is rare: Time-in-between chart
If event is not rare: P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
If continuous variable
If one data point per time period
If outliers likely: Tukey chart
If outliers not likely: XmR chart
If multiple data points per time period: Xbar chart
If discrete event
If event is rare: Time-in-between chart
If event is not rare: P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
If continuous variable
If one data point per time period
If outliers likely: Tukey chart
If outliers not likely: XmR chart
If multiple data points per time period: Xbar chart
If discrete event
If event is rare: Time-in-between chart
If event is not rare: P-chart
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
WHICH CHART IS RIGHT?
Case Mix Change
HEALTH INFORMATICS PROGRAM
GEORGE MASON UNIVERSITY
Select the Right Chart
for Your Data