Levey Jennings Standard Deviation Chart in Excel

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

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



  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 standard deviation as a way of calculating control limits.

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

Levey Jennings Chart

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

QI Macros - One License Per Computer
- Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer
- Download Only - No Shipping or Customs Duties (#W230) $199

 

 

Download
QI Macros

30-Day Trial Now!


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training