Statistical Process Improvement		 Georgetown University
 

Tukey Chart
 

This topic continues to examine control charts that require only 1 observation per time period.  These include time-between and Tukey control charts. This section focuses on Tukey chart. 

Assigned Reading

  • Chapter 9 in Big Data in Health Care: Statistical Analysis of Electronic Health Record Read►

Presentations

Assignments

Instruction for Submission of Assignments: Assignments should be submitted directly on Blackboard.  In rare situations assignments can be sent directly by email to the instructor. Submission should follow these rules:

  1. Each question should be answered in different section of your response document.  Each section should be labeled with the question number.  Use Jupyter Notebook to organize your response. 
  2. Make sure that any control charts follow the visual rules below:  (1) Control limits must be in red and without markers, (2) Observed lines must have markers, (3) X and Y axis must be labeled, and (4) Charts must be linked to the data. 
  3. The section in the file should be a summary page.  In the summary page you should list how your answers to the question differs from answers provided within the assignment (inside Teach One or other answers).  You must indicate for each question if your control chart is exactly the same as seen in Teach One or other formats.  For each question, you must indicate if the answers you have provided is the same as the answers supplied on the web.  If there are no answers provided, you must indicate that there were no answers available on the web to compare your answers to.

Question 1: In health administration programs, data on waiting time are examined in courses on quality and operations research.  Using the attached data, determine if the waiting time in our urgent care center has changed?

Question 2: In Hospital Administration Programs, time to adverse events is typically taught in courses on quality.  It also may be referred to in courses on strategy, if the hospital is focused on competing based on quality.

Hospital Compare reports the measure OP_21. The Score field provides time (in minutes) from emergency department arrival to initial oral, intranasal or parenteral pain medication administration for the patients with a diagnosis of a long bone fracture.  The field Sample provides the number of patients used to calculate the time to pain medication. In this assignment, we ask you to track the performance of "Inova Fairfax Medical Center" over two years. Focus on the Score variable.  Download Hospital Compare data; these years include data from 2013 to 2015.  Merge the file " HQI_HOSP_TimelyEffectiveCare" across all the databases that you have downloaded.  Select measure ID: "OP_21" .  Construct a control chart showing time between pain medications. The data are reported for a range of time; assume that the data are reported for the mid-point of the range. Download data using the following 9 files: 

Construct both a Tukey and a time-between control chart for the data.   For the time-between control chart assume that data points above median exceed and observations below median are less than the national average. 

Question 3: Analyze the following data using Tukey, XmR and Time-In-Between (more than 30 minutes of exercise considered a successful day) charts. Produce 3 charts and discuss if the findings from the 3 charts are similar.  To decide if the exercise time has changed, rely on the control chart with the smallest difference between upper and control limit.

Question 4: Analyze "Death rate for CABG surgery patients", this is measure code MORT_30_CABG. Choose George Washington University Hospital.  Choose for its competitors Medstar Washington, VHC, and INNOVA Fairfax. You will find this measure inside "Complications and Deaths - Hospital" file.  The measure was named this way in the year 2018. Include all years of data. The denominator reports the number of cases.  The numerator reports the risk-adjusted mortality rate. Note that the name of the file may change in different years but the measure code remains the same. Compare the performance of the hospital to the competing hospitals in its market, including Medstar Washington, INOVA Fairfax, and Virginia Hospital Center. Draw the observed rate at GWU.  The control limits should come from the experiences of its competitors, which is a weighted average of each of the competitor. 

More
 
Copyright © 1996 Farrokh Alemi, Ph.D. Most recent revision 11/04/2021.  This page is part of the course on Statistical Process Improvement.