Levey Jennings 10-20-30% Chart in Excel

Uses 10% of the Average to Calculate Control Limits

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, has an option to use 10 percent of the average as a way of calculating control limits.

levey jennings percent control chart in Excel

Once the chart is created, you can click on the data sheet created when the macro was run and change the percentage (in cell I1) to 5% or whatever you desire.

change percent in levey jennings percent chart

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.

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual 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

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free