Levey Jennings Template in Excel

Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose.

Example of a QI Macros Levey Jennings Control Chart Template in Excel

Example of QI Macros Levey Jennings Chart Excel template

The template opens to the standard Levey Jennings chart. However, there are several other template options including percent, target and fixed standard deviation charts:

levey-jennings-template-tabs

Here is how each Levey Jennings Control Chart Template works

Chart Center Line Sigma Lines Input Area
Levey Jennings 1-Chg Calculated from the data

Calculated from the data and drawn at 1, 2 and 3 standard deviations

 process change
Levey Jennings Percent Calculated from the data

Default draws sigma lines at 10, 20, and 30% from the center line.

Percentages can be changed using the drop down menu.

process change
Levey Jennings Target

Calculated from the data but can be overridden by inputting a different value in the Target cell

Default draws sigma lines at 5, 10 and 15% from the center line.

Percentages can be changed using the drop down menu.

 target value
Levey Jennings Fixed Stdev

Calculated from the data but can be overridden by inputting a different value in the Center Line cell

Calculated from the data but can be overridden by inputting a different value in the Stdev cell

 Center Line and Fixed Standard Deviation input

 

Note: 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 is available in the Levey Jennings Percent template and the Percent Macro.

 

Levey Jennings Templates in QI Macros for Excel:

Find the Levey Jennings templates by clicking on the QI Macros menu > Control Chart Templates > Special (CUSUM, EWMA) > Levey Jennings Stdev or Levey Jennings 10%:

control-chart-cusum-menu

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $329 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free
Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now