# 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

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

### 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 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. 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. 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

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%:

### Affordable

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

### Easy to Use

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

### Proven and Trusted

• More than 100,000 users
• In More than 80 countries
• Five Star CNET Rating - Virus free