Levey Jennings 10-20-30% Chart in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Levey Jennings (10-20-30%) Control Charts in Excel

Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose. The Levey Jennings chart, unlike other SPC charts, uses 10 percent of the average as a way of calculating control limits.

The Levey Jennings (10-20-30%) Chart consists of :

• A line graph of each data point
• An average line
• And 10-20-30% control limit lines
• Performs stability analysis and turns any unstable point or condition RED
• Allows you to add data to existing control charts and create control charts with multiple (stair step) control limits

Once the chart is created, you can click on the data sheet and change the percentage in cell I1 or J1 to 5% or whatever if needed.

According to SOFT / AAFS FORENSIC TOXICOLOGY LABORATORY GUIDELINES 9.1.12 standard deviation may represent an unacceptably large percentage deviation from the mean. Therefore, a realistic percentage deviation should be used, such as ±20% or ±30%. This was added to the QI Macros Levey Jennings Fill in the Blanks template in July 2009 and QI Macros menu in December 2010.

Levey Jennings chart Video

Levey Jennings Chart templates for Excel

Other control charts in Excel

The Levey Jennings chart and all of the variable and attribute control charts are included in the QI Macros for Excel SPC Software.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!