Precision Control Chart

It's Easy to Create a Precision Chart in Excel

Healthcare labs use the Precision Charts to monitor paired measures. In this data, there are two measurements on the same day. RPD is calculated using the formula shown:

Precision Control Chart Data

The Precision control chart can be created in two ways:

  1. as a Levey Jennings Chart of Relative Percent Difference (RPD)
  2. or the R Chart of an XbarR Chart of the two different measures.

Example of a Precision Control Chart

  1. To create a Precision Chart of RPD using QI Macros:
    • Select your Precision Chart data (dates and RPD) in an Excel worksheet.
    • Next, click on the QI Macros menu > Control Charts (SPC) > Special (CUSUM, EWMA) and then Levey Jennings Stdev:
    • control-charts-spc-special-menu

    • Precision Chart uses standard deviation to draw the 2 sigma (Warning Limit) lines and the upper and lower control limits.
    • Adjust the Y axis to cross at zero and Show the 1-2 Sigma lines using QI Macros Chart Menu. The 2-sigma line is known as the Warning Limit. One point is above the warning limit:

      Precision Control Chart RPD
  2. To create a Precision Control Chart of the ranges between two measures:
    • Select the data (dates and measures 1-2)
    • Next, click on the QI Macros menu, Control Charts and then the XbarR chart.
    • Use the R Chart and discard the X Chart:
    • Precision Control Chart XbarR

Why Choose QI Macros Over Other Control Chart Software?



  • Only $299 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