XmR Trend Control Chart in Excel

Use an XmR Trend Control Chart to evaluate stability of processes using trended data - costs (e.g., inflation).

XmR Trend Control Chart created using QI Macros for Excel.

xmr trend chart in excel

The Chart will calculate the fit of the data to the trend:

xmr trend calculations

  • R² gives the fit of the line to the trend. Greater than 0.80 is a good fit.
  • Ryx is the linear correlation coefficient. Compare to probability for df = n - 2.
  • Slope is the positive or negative slope of the trend
  • Sigma is the estimated standard deviation Rbar/d2
  • Probability is critical value for Ryx. If Ryx > Probability then a statistically significant correlation exists.

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

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

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