1 / 30

Runcharts 101 Geoff Schierbeck Quality Leader Surgery BCPSQC

Learn how to create and analyze run charts to track improvements over time. Understand data display principles and Excel tips. Run charts are essential for monitoring changes and identifying trends.

adeborah
Download Presentation

Runcharts 101 Geoff Schierbeck Quality Leader Surgery BCPSQC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Runcharts 101 Geoff Schierbeck Quality Leader Surgery BCPSQC

  2. A Simple Run Chart: Building Block of Measurement for Improvement • Data displayed in time order • Data is collected and displayed weekly or monthly.

  3. The Value of Data in Real Time • Run Charts can tell us what is happening in real time.

  4. Why not before and after? Pre = 8 days wait time Post = 3 days wait time Adapted from Health Care Data Guide, p. 16 Figure 1.5 and 1.6 , Provost and Murray, 2011. San Francisco: Jossey Boss

  5. Scenario 1 Adapted from Health Care Data Guide, p. 16 Figure 1.5 and 1.6 , Provost and Murray, 2011. San Francisco: Jossey Boss

  6. Scenario 2 Adapted from Health Care Data Guide, p. 16 Figure 1.5 and 1.6 , Provost and Murray, 2011. San Francisco: Jossey Boss

  7. Scenario 3 Adapted from Health Care Data Guide, p. 16 Figure 1.5 and 1.6 , Provost and Murray, 2011. San Francisco: Jossey Boss

  8. Scenario 4 change made between week 7 and 8 Adapted from Health Care Data Guide, p. 16 Figure 1.5 and 1.6 , Provost and Murray, 2011. San Francisco: Jossey Boss

  9. Run Chart Control Chart

  10. Displaying Key Measures over Time - Run Chart • Data displayed in time order • Time is along X axis • Result along Y axis • Centre line = median • One “dot” = one sample of data • Sample size = each “dot” should have the same n

  11. Showing improvement: No improvement. Random fluctuation. Improvement. Trend going up.

  12. Making the Run Chart in Excel • Data will be in two columns. Column A will have dates or times, and Column B will have the result of your data collection. • Highlight this data

  13. 3. With your mouse, choose Insert -- Line -- Line With Markers

  14. Making the Run Chart in Excel

  15. Making the Run Chart in Excel - adding the median line 4. Inserting the Median Line (needed to analyze the run chart): Calculate the Median Value from your Data

  16. Making the Run Chart in Excel – adding the median line 5. Enter the Median in Column C (we want a flat line for the median, i.e. all the same value)

  17. 8. The Run Chart is done and can be formatted: titles, gridlines, etc. Note – to make the median a flat line with no markers, right click on the line and change the Marker Options.

  18. How Do We Analyze a Run Chart? Visual analysis first If pattern is not clear, then apply probability based rules

  19. Non-Random Signals on Run Charts A Trend 5 or more A Shift: 6 or more Too many or too few runs An astronomical data point Evidence of a non-random signal if one or more of the circumstances depicted by these four rules are on the run chart. The first three rules are violations of random patterns and are based on a probability of less than 5% chance of occurring just by chance with no change. The Data Guide, p 78

  20. Data Display Principles

  21. *hypothetical data – illustrative purposes only

  22. SMALL MULTIPLES – all info on one page *hypothetical data – illustrative purposes only

More Related