g Chart in Excel

Use a g Chart to analyze the time or procedures BETWEEN rare events.

The g Chart is used to evaluate process stability when analyzing the time or procedures BETWEEN rare events. For example, never events in healthcare such as retained foreign objects during surgery (you could use days or surgeries between events). (See QI Macros Test Data/healthcare spc.xlsx)

g Chart example created by QI Macros for Excel (added January 2017)

g Chart of Retained Foreign Objects using QI Macros

g Chart data consists of one column of integers:

g Chart data example in Excel

To create a g Chart in Excel using QI Macros:

  1. Just click and drag over the data to select it.
  2. Then click on the QI Macros menu, Control Charts, then g Chart.
  3. QI Macros will do all the math and draw the g Chart for you. QI Macros will also turn any unstable points or conditions on the g Chart red. These should be investigated.

Learn More...

To create a G Chart Excel using QI Macros...
Try It Now!