X bar R Chart Formulas
The X bar R chart can help you evaluate the stability of processes using variable data--time, cost, length, weight when you have 2 to 10 samples per period.
Here are the X bar R chart formulas used in the QI Macros for both the Range and Average (Xbar) charts.
Conforms with ANSI/ASQC B1, B2, B3 1996
Process: Calculate, plot, and evaluate the range chart first. If it is "out of control," so is the process. If the range chart looks okay, then calculate, plot, and evaluate the X chart.
- Create a X bar R chart in Excel using the QI Macros
- X bar R chart video
- X bar R chart template in Excel
- Other control chart formulas
The X bar R chart is just one of the tools included in the QI Macros for Excel SPC Software for Excel.
To create an XbarR Control Chart in Excel, purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!