Is There A Trend in My Data?

A customer recently asked: How can I tell if there's really a trend in my data? He wanted to know if scans were increasing.

He had used Excel to add a trend tine to a bar chart, but wanted to know if there was a way to show control limits.

Line bar Chart with Trend

QI Macros XmR Trend Chart

Using QI Macros, you can create an XmR Trend Chart:

XmR Trend Chart of Patient Scans

  • In this case 0.8612 = 0.74 (a 74% fit).
  • Slope is increasing by 20 scans per month.
  • And the process is in control except for the range change in October.

He can count on a 20 patient increase per month.

Here's my Point: Use the QI Macros XmR Trend Chart to check your data for trends.

Trend Lines Can Lie

A trend line does not a trend make. Click here to find out why.

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!