Probability Charts

Objectives

87 people have rated this page an average of 4.15 out of 5 stars.  See their  suggestions and  questions.  Rate this page.  P-chart lecture Risk adjusted P-chart lecture Calculating expected deviations for risk adjusted p-charts (SWF file) Creating risk adjusted P-chart  Video► SWF► Excel 2003► Objectives Why chart? Which chart is right? Assumptions P-chart Risk adjusted P-chart Presentations Example Analyze  Data More Recently asked questions Suggested changes See table of Student t-values Recently asked:  how to measure by severity index.do every disease has different value  See answer to this and other questions.

In this section, we show you how to analyze the data from  improvement efforts involving frequency of events.  We assume that you have  collected data about a key indicator over several weeks and that you need to  analyze the data.  We will teach you how to analyze the data and we will  even provide you with templates that you can use to quickly complete your tasks.  

The objectives of this session are:

• Chart data using P-chart.

• Chart data using risk-adjusted P-charts.

• Decide if the changes you have introduced have led to real  improvements.

Why chart?

There are two reasons why to construct a  control chart.

1. To discipline intuitions. Data on human judgment show  that we, meaning all of us including you, have a tendency to attribute  system improvements to our own effort and skill and system failure to chance  events. In essence, we tend to fool ourselves. Control charts help see  through these gimmicks. It helps us see if the improvement is real or we  have just been lucky.

   An example may help you understand my point. In an air force,  a program was put in place to motivate more accurate bombing of targets  during practice run. The pilot who most accurately bombed a target site, was  given a $2,000 bonus for that month. After a year of continuing the program,  we found an unusual relationship. Every pilot who received a reward did  worse the month after. How is this possible? Rewards are supposed to  encourage and not discourage positive behavior. Why would pilots who did  well before do worse now just because they received a reward? The  explanation is simple. Each month, the pilot who won did so not because  he/she was better than the others but because he/she was lucky. We were  rewarding luck; thus, it was difficult to repeat the performance next month.  Control chart helps us focus on patterns of changes and go beyond a focus on  luck.

   In a field like medicine, over time a poor outcome occurs  the natural tendency is to think of it as poor care. But such rash judgments  are misleading. In an uncertain field such as medicine, from time to time  there will be unusual outcomes. If you focus on these occasional outcomes,  you would be punishing good clinicians whose efforts have failed by chance.  Instead, focus on patterns of good or bad outcomes. Then you know that the  outcomes are associated with the skills of the people and the underlying  features of the process and not just chance events. Control charts help you  see if there is a pattern in the data and move you away from making  judgments about quality through case by case review.
    

2. To tell a story. P-charts display the change over time.  These charts tell how the system was performing before and after we changed  it. They are testimonials to the success of our improvement efforts. Telling  these types of stories helps the organization to:
    

   • celebrate small scale successes, an important step in  keeping the momentum for continuous improvement.

   • communicate to others not part of the cross functional  team. Such communications help pave the way for eventual organization  wide implementation of the change.

   You can of course present the data without plotting it and  showing it. But without charts and plots, people not be able to see the  data. Numbers makes people understand the data but plots and charts,  especially those drawn over time, make people connect a story with the data,  they end up feeling what they have understood. For many people seeing the  data is believing it. When these charts are posted publicly in the  organization, control charts prepare the organization for change. They  transfer and explain the experience of one unit of the organization to other  units.

Which chart is right?

Figure 1:  P-chart is best when there are multiple observations  & outcomes are dichotomous and not rare

When tracking data over time, you have a number of options.   You could use a P-chart, designed specifically to track mortality or adverse  health events over time.   You could use an X-bar chart designed for  tracking health status and satisfaction surveys of a group of patients over  time.  You could use a moving average chart to help you construct control  chart for an individual patient's data over time.  This section helps you  decide which of these various charts are appropriate for your application.   If you do not have a specific application in mind or if you wish to learn more  about each of the various different charts, skip this section.  In the  following, we ask you 4-7 questions and based on your answers advise you which  chart is right for the application that you have in mind.

Have you collected observations  over different time periods?

• Yes►

• No►

Assumptions

When analyzing adverse health outcomes,  such as mortality, a useful method of analysis is P-chart. In the P-chart we  assume the following:

• The outcome is dichotomous, mutually exclusive and exhaustive events. Dichotomous means that there are only two outcomes. Mutually exclusive means that these two outcomes cannot both occur. Mutually exhaustive means than one of these two outcomes must happen. Thus p-chart may be considered appropriate for analysis of mortality rates if we agree that there are only two outcomes of interest (alive and dead) and that it is not possible to be both alive and dead, or to be in a state other than alive or dead.
   

• The outcome is measured over time to track improvements in the process.
   

• The observations over time are independent. Meaning that the probability of adverse outcomes for one patient does not affect the adverse outcome of the other patient. This is not always true. In infectious diseases, one patient affects another. When infection breaks in a hospital ward, the use of P-chart to analyze the outcomes of the process is inappropriate.
   

• Risk adjustment of the P-chart requires the availability of accurate predictions of risk faced by each patient in our sample. These predictions can be made based on a number of commercially available severity indices or based on the clinician's opinions. In either case, the quality of the analysis depends on the quality and the availability of these predictions.
   

• The analysis assumes that the sample of patients examined represent the population of patients treated at the specific time period.

These assumptions are important and should be verified before  proceeding further with the use of risk adjusted P-charts. When these  assumptions are not met, alternative approaches such as bootstrapping  distributions should be used.

P-chart

This section takes you through a step by step process of using a  P-chart; a type of control chart for analysis of mortality data. We introduce  the concepts behind P-charts in several steps. It is important that you take  each step and complete the assignment in the step before proceeding to the next.  To help you understand the concepts, the lecture focuses on data from one  hospital's mortality over 8 consecutive months.

Here is the data we need to analyze:

Calculate Mortality Rates

The first step is to create an x-y plot; where the x axis is  time and the y axis is mortality rates. Calculate mortality rates by dividing  number dead by the number of cases in that month.

Numbers are deceiving. They hide much. To understand numbers you  must see them by plotting them. Figure 1 shows the data plotted against time. 

Figure 2:  Observed Mortality in Eight Time Periods

What does the plot in Figure 1 tell you about unusual time  periods?  There are wide variations in the data.  It is difficult to  be sure if the apparent improvements are due to chance.  To understand if  these variations could be due to change, we can plot on the same chart two  limits in such a manner that 95% or 99% of points would by mere change fall  between the lower and upper limits. 

Setting limits

Figure 3 shows the steps in calculating control limits.

Figure 3:  Steps in Calculating Control Limits in P-charts

In step one the grand average p is calculated by dividing the total adverse  events by the total number of cases.  Note that averaging the rates at  different time periods will not yield the same results. Calculate the total  number of cases and the total number of deaths. The ratio of these two numbers  is the average P, the average mortality rate.

Next calculate the standard deviation of the data. In a binomial  distribution the standard deviation is the square root of grand average p  multiplied by one minus grand average p divided by the number of cases in that  time period. For example, if the grand average p is .25 and the number of cases  in the time period is 186, then the standard deviation is the square root of  (.25)*(.75)/(186). Table 3 shows the calculated standard deviations for each  time period:

Calculate the upper lower limit for each time period as grand  average p plus 3 times the standard deviation. This means that you are setting  the control limits so that 99% of the data should fall within the limits. If you  want limits for 90% or 95% of data you can use other constants besides 3.   The constant you use depends on number of observations in the time period and  can be read from table of t-values for different  sample sizes.  Table below shows the lower and upper control limits:

Please note that negative control limits in time periods 4, 6  and 8 are set to zero because it is not possible to have a negative mortality  rate.  Also note that the upper and lower control limit change in each time  period. This is to reflect the fact that we have different number of cases in  each time period. When we have many observations, we have more precision in our  estimates and the limits become tighter and closer to the average p. When we  have few observations, the limits go further away from each other.

Remember that we are trying to answer the question of whether  there has been improvements in the process. The control limits help answer this  question. If during a time period we have more mortality than can be expected  from chance then the process has deteriorated during that period. Any point  above the UCL indicates a potential change for the worst in the process. Any  point below the LCL indicates that mortality is lower than can be expected from  chance. It suggests that the process has improved. Figure 4 shows the resulting  plot:

Figure 4:  P-chart for Data in Table 1

Notice the peculiar construction of the plot, designed to help  attract the viewers attention to observed rates.  The observed rates are  shown as single marker connected with a line.  Any marker than falls  outside the limits is circled and highlighted.  The control limits are show  as a line without markers.   In the plot in Figure 3, all the data  points are within limit.

Risk Adjusted P-chart

See how to create risk adjusted P-charts in Excel  Video►   SWF►

P-charts were designed for monitoring the performance of  manufacturing firms. These charts assume that the input to the system is the  same at each time period. In manufacturing this makes sense. The metal needed  for making a car changes little over time. But in health care this makes no  sense. People are different. People are different in their severity of illness,  in their ability and will to recover from their illness and in their attitudes  toward heroic interventions to save their lives. These differences affect the  outcomes of care. If these differences are not accounted for, we may mistakenly  blame the process when poor outcomes were inevitable and praise the process when  good outcomes were due to the type of patients arriving at our unit.

Some institutions receive many severely ill patients. These  institutions would be unfairly judged if their outcomes are not adjusted for  their case mix before comparing them to other institutions. Similarly, in some  months of the year, there are many more severely ill patients. For example,  seasonal variations affect the severity of asthma. Holidays affect both the  frequency and the severity of trauma cases.

But even more significant source of change in the severity of  illness of our patients is our own actions. Many process changes lead to changes  in the kinds of patients attracted to our unit. Consider for example, if we  aggressively try to educate patients for the need for avoiding C-section, we may  get a reputation for normal birth delivery and we may attract patients who have  less pregnancy complications and wish for normal birth delivery. In the end, we  have not really reduced c-sections in our unit, all we have done is to attract a  new kind of patient who does not need cesarean births. Nothing fundamentally has  changed in our processes, except for the input to the process.

Risk adjustment of control charts is one method of making sure  that the observed improvement in the process are not due to changes in the kind  of patients that we are attracting to our unit.  To help you understand  this method of analysis, suppose we have collected the data in Table 5 over 8  time periods.   This table shows the patients severity of illness  (risk of mortality).  If you have forgotten what is severity and how we  measure it please click  here to return to a previous lecture on this issue.  

The question we want to answer is whether the observed mortality  rate should have been expected from the patients severity of illness (individual  patient's risk of mortality).  To answer this question, we need to  calculate control limits.  Risk adjusted control limits for probability  charts are calculated using the steps in Figure 5:.

Figure 5:  Steps in Calculation of Risk Adjusted  Control Limits for Probability Charts

The upper and lower control limits are calculated from the  expected risk, E_i, the expected deviations, D_i, and the student-t distribution constant.  Each of these are further defined and  explained below. 
 

Expected Mortality

The expected mortality rate for each time period is calculated  as the average of the risks of mortality of all the patients in that time  period. These calculations are shown in Table 6:

Expected Deviation

Calculation of Expected Deviation  Video►SWF►   See table of Student t-values More►

Before we construct control limits for the expected mortality,  we need to measure the variation in these values.  The variation is  measured by a statistic that we call expected deviation.  It is calculated  in four steps:

1. The risk of each patient is multiplied by one minus the risk of the same patient.

2. The multiplied numbers are added for all patients in the same time period.

3. The square root of the sum is taken.

4. The expected deviation is the square root of the sum divided by the number of cases.

Figure 6:  Calculation of Expected Deviation

Figure 5 shows calculation of expected deviation for the first  time period.  The same calculation should be carried through for each time  period, resulting in the data in Table 7:

T-value

To calculate the control limits we need to estimate the  t-statistic that would make sure that 95% or 99% of data will fall within the  control limits.  T-values depend on the sample size.  To see a Table  of "t" values for different sample sizes click here.

Table 8 summarizes the estimated t-values for all time periods:

Plotting a Risk  Adjusted P-Chart

We are now reading to calculate the control limits and plot the chart.   The upper and lower control limits are calculated from the expected mortality  and expected deviation so that 95% of the data would fall within these limits  (i.e. we use a t-value appropriate for 95% confidence intervals):

Since negative probabilities do not make sense, we re-set the  negative numbers to 0.  In a risk adjusted p-chart, we plot the observed  rate against the control limits derived from expected values.  Figure 7  shows the resulting chart:

Figure 7:  Risk Adjusted P-Chart for Data in Table 5

One of the data points in Figure 6 falls outside the control  limits.  We have drawn a circle around this data point to attract attention  to it. Points above the upper control limit show time periods when outcomes have  been worse than expected from the patients' risks. Points below the control  limit show time periods when outcomes have been better than expected.  In  time period 3, mortality rates were less than expected.

Presentations

There are three sets of presentations for this lecture:

1. Lecture on P-chart  Slides► Listen► SWF►

2. Lecture on Risk Adjusted P-charts  Slides► Listen► SWF►

3. Introduction to Control Chart  Slides► SWF►

4. See how to calculate Expected Deviations  Excel 2003►  SWF►

5. Creating risk adjusted P-chart  Video► SWF► Excel 2003►

Narrated slides and videos require Flash.

Examples

• See a recent tutorial on how to create a risk adjust control chart.  More►

• Most health care managers do not publish the control charts of their data and therefore it is difficult to have access to these examples.  But some do, and their analysis and data are available through Medline.  PubMed►

• Michael Cleary, Ph.D. and iSixSigma give a case study for on-time medication delivery. More► 

• Seen an example of use of control charts in preventing hospital falls.  More► 

• For an example of risk-adjusted quality control charts see Gustafson's approach to infection control.  More►

Analyze Data

Step by step analysis of risk-adjusted P-chart similar to Analyze Data for this week.  Video► SWF► More details on calculations of Expected Deviations  Video► SWF► To analyze this week's data you would need the Student t-values.  More►

Advanced learners like you, often need different ways of understanding a  topic. Reading is just one way of understanding. Another way is through  analyzing data.  The enclosed questions are designed to get you to think  more about the concepts taught in this session.

1.  Assume that following data were obtained about number of falls in a Nursing Home facility. 

Produce a control chart.  Make sure that your control chart does not have any of the following typical errors:

1. The chart includes un-named labels such as "Series 1" and "Series 2."
2. The markers in the control line were not removed.
3. The X-axis does not have a title
4. The Y-axis does not have a title
5. Colors used in the chart and in the cell values, do not help in understanding of the work.
6. Except for the data, all cell values should be calculated as a formula.  If this is not the case, it is very important that you point this out.  You should be able to change a data value and all calculations should change automatically.

Email your instructor.  Attach your Excel file.  In the subject line include the course number and your name.  For example, subject line could be:  "Joe Smith from HAP 586 analysis of data in lecture on P-chart"   Please submit one file.  Please note that all cell values must be calculated using a formula from the data.  Do not enter values in any calculated cells.  Calculate each cell using Excel formulas.  Make sure that legend, the X-axis and the Y-axis are appropriately labeled in the chart.   Keep a copy of all assignments till end of semester.  Email►

More

Recently Asked Questions

Ask a question and we will answer it within the next 48 hours. If you  have no questions, please review the answer to the questions asked by others:

Question: how to measure by severity index.do every disease has different value Answer: Not sure I have understood your question. Are you asking how do we measure severity of an illness. If so here is the response. Each patient has a set of characteristics or diseases. These characteristics are scored and typically summed to obtain the total severity score.   This question was asked on 3/4/2008 1:11:33 AM and answered on 3/4/2008 6:52:26 AM.

Question: Could we have just followed your equation for the Expected Deviation from your video or do we have to do it the way it is spelled out in the lecture notes using the sum, sq root of sum, and divide? Answer: Both do it the same way, but you certainly can follow the steps you find easiest to do.    This question was asked on 3/3/2008 10:28:21 PM and answered on 3/4/2008 6:49:33 AM.

Question: In analyzing data for OR turnover time, what type of chart would you recommend? Answer: It sounds that you are analyzing an interval scale (time it took to finish an operation). If that is the case, and if you have one observation per time period, then I would recommend you look into Tukey and XmR charts.   This question was asked on 3/3/2008 9:07:30 PM and answered on 3/3/2008 9:20:22 PM.

Question: I just want to make sure I understand the p-chart and t-chart concept. Is this the same as null hypothesis testing, were you can have type I or type II errors for rejecting and failing to reject the null? Answer: Yes, the control limits in a P-chart can be thought of 99% confidence interval and in fact the test conducted in a control chart is to find if any of the observed points fall outside the confidence interval for the current mean of the process.   This question was asked on 3/3/2008 1:04:04 PM and answered on 3/3/2008 2:38:57 PM.

Question: What is the main function for the lower control limit? Answer: The same as for upper control limit. When data are between the two control limit then the process has not changed and the observations could be due to chance. When observations are above the UCL or below LCL then there has been changes in the work process and the variation in the data are unlikely to be due to chance.    This question was asked on 2/28/2008 11:06:12 AM and answered on 2/28/2008 12:22:43 PM.

Question: Is is OK to type in the T values from the student t values chart? I had trouble pasting. Answer: Yes that is ok.   This question was asked on 2/24/2008 5:27:12 PM and answered on 2/24/2008 6:14:28 PM.

Question: Are patients' self- ratings reliable for assessing risk? Answer: Some studies show that patients are a good predictor of their survival within a decade. They may be a poor prognosticator for other time frames.   This question was asked on 10/14/2007 9:27:52 PM and answered on 10/14/2007 9:30:50 PM.

Question: In talking about assumptions, you mentioned that if one of the assumptions cannot be verified then bootstrapping distributions would be a better approach. What do you mean by this? Specifically, what is the "bootstrapping distribution" approach? Answer: Good question. When the assumptions of common distributions (e.g. Normal or Binomial) are not met, we assume that the distribution has the general form of the observed data and estimate standard deviation and average of the distribution from the data without making a distribution assumption. The steps are you randomly select n observations from the data and calculate the average and standard deviation. You repeat this m times, each time calculating average and standard deviations. You estimate control limits (the average plus or minus 3 standard deviation) of the process from these m samples. Also keep in mind that the Tukey and XmR control charts make no distribution assumptions and can be used in these circumstances. More about these charts later.   This question was asked on 10/12/2007 1:23:20 AM and answered on 10/12/2007 6:36:42 AM.

Question: The lecture and reading material were clear enough so I don't really have a question. The presentation did not direct us to put a title. It seems to me giving the chart a title would be a good idea. Answer: Good point.   This question was asked on 10/11/2007 1:50:18 PM and answered on 10/11/2007 6:36:22 PM.

Question: In our sample data, what was the source of the expected probability? How was that assigned? Answer: Prognosis of patients can be established from different sources, including consensus of experts, commercial severity indices and published methods of measuring prognosis. The sample data provided is hypothetical but similar data can be constructed from clinician's judgments   This question was asked on 10/7/2007 8:52:17 PM and answered on 10/8/2007 10:09:44 PM.

Suggested Changes

Add your own suggestions in the left column or read below suggestions made by others regarding how to improve this session:

Suggestions: I liked this lecture.    This comment was left on 3/25/2008 4:33:36 PM. 

Suggestions: very interesting lecture! I sure learned a lot.   This comment was left on 3/10/2008 2:11:19 AM. 

Suggestions: The lecture was clear and concise. The examples and videos were very helpful. I'm learning so much about Excel through this class.   This comment was left on 3/5/2008 8:38:30 PM. 

Suggestions: It was very helpful having the steps broken down in the notes/presentation. It helped refresh the information on statistical analysis from my prior class.   This comment was left on 3/5/2008 12:19:35 AM. 

Suggestions: The lecture was very clear and easy to understand.   This comment was left on 3/4/2008 8:51:40 PM. 

Suggestions: Every thing from you is great I really respect your discussion with your students. Thank u.    This comment was left on 3/4/2008 4:45:12 PM. 

Suggestions: It would have been extremely helpful if all the examples could be combined and shown/done in one lecture. Especially the calculation of expected std values and knowing how to calculate degrees of freedom..Overall this lecture and the examples were very helpful in completing the homework..thank you..   This comment was left on 3/4/2008 12:12:23 PM. 

Suggestions: Exceptional page...it was very clear.    This comment was left on 3/4/2008 1:12:38 AM. 

Suggestions: everything explained well   This comment was left on 3/4/2008 1:00:24 AM. 

Suggestions: I suggest to include "Expected Deviation" in the list of sections on the top right section of the lecture for easy reference.   This comment was left on 3/3/2008 9:54:10 PM. 

Suggestions: I found the second video to be extremely helpful with homework. It would have been better if it were displayed as large as the first video.   This comment was left on 3/3/2008 9:17:44 PM. 

Suggestions: Slides were very helpful in doing the P-chart.   This comment was left on 3/3/2008 7:32:24 PM. 

Suggestions: It would have been extremely helpful if a link to the slides for the Lecture on Risk Adjusted P-charts had been in Plotting a Risk Adjusted P-Chart section of the lecture. I was confused on how to calculate the LCL and UCL until I found the slides at the end of the lecture. Granted I could have read ahead but I prefer to learn as I go and practice each step along the way and everything was clear up to this point. Thank you.    This comment was left on 3/3/2008 3:54:55 PM. 

Suggestions: The explanation about the Air Force incentive program was very helpful.   This comment was left on 3/3/2008 1:04:46 PM. 

Suggestions: I think it's wonderful there are examples of how to structure the analysis chart. When working on the homework, I use the video instruction as a guide.   This comment was left on 3/1/2008 10:40:46 AM.