Levey Jennings Standard Deviation 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

There are several ways to create Levey Jennings charts using the QI Macros:

1. Using the Levey Jennings Fill in the Blanks Template
2. Using one of the two Levey Jennings chart macros

To create a Levey Jennings chart using one of the macros: Select your data and then click on the QI Macros menu and then Control Charts. Next select one of the two Levey Jennings chart options. Levey Jennings Stdev, uses standard deviation to draw the 1, 2, sigma lines and upper and lower control limits Levey Jennings 10 % draws 1, 2 sigma lines and upper and lower control limits using 10 %, 20% and 30% of the average.

Here is an example of a QI Macros Levey Jennings chart created using standard deviation

The Levey Jennings (Standard Deviation) Chart consists of :

• A line graph of each data point
• An average line
• And1-2-3 standard deviation 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

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 option 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

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!