January 2016

man rolling earth uptrendHow can you use control charts with a process where you expect the average response to trend up or trend down over time?  Last month we took a look at global warming through the eyes of a control chart. 

The data indicated that there were periods of stability – where the temperature neither increased or decreased – until around 1997.  Since then, there appears to have been a steady upward trend in the global temperature on almost a yearly basis. 

Does this mean that we can’t use control charts anymore?  No, not at all.  In fact, we used a trend control chart last month to monitor the data from 1997 on.  In this month’s publication, we will examine how you construct and interpret a trend control chart using a slightly different set of global temperature data.

In this issue:

You may download a pdf version of this publication at this link.  Please feel free to leave a comment at the end of the newsletter

Classical Shewhart Control Charts

one earthThe classical Shewhart control chart consists of two control charts.  Examples of these classical control charts include the X-R and individuals (X-mR) control charts.  With the individuals control chart, one chart (X Chart) monitors the variation “between” individual results.  The second chart monitors the variation between consecutive results (mR chart).  This is the “within” variation.  One objective of this control chart is to determine if the process is in statistical control. 

If it is in statistical control, we typically think that the process has one average and one measure of variation.  The “one” average comes from the center line on the X chart.  The measure of variation (the estimated standard deviation) comes from the average range on the mR chart.   Of course, no process is unwavering, but it is helpful to think about statistical control, in the classical sense, as having one average and one measure of variation.  This is shown in Figure 1.  But what about processes where you don’t expect there to be just “one” average?  That is where the trend control chart comes in.

Figure 1: In Control Process

stable process over time

Trend Control Charts

There are processes where you don’t expect the average to stay the same over time.  You expect the average to move up or down.  Examples include catalyst activity, financial items affected by inflation, and tool wear.  If these parameters are plotted using the classical Shewhart control charts, the process will appear out of control because the average is not staying the same.  But the process is not out of control because the average naturally moves up or down over time.  This is shown in Figure 2.

Figure 2: Variation in a Process with a Trend

trending proces over time

Trend control charts provide a method of handling this type of situation.  A trend control chart still consists of two charts.  One is the moving range chart.  This is identical to the moving range used in the classical Shewhart control charts.  The other is the X chart, but in this X chart, the average is not horizontal but moves up or down.  The average represents the best-fit line for the data.  The process for creating a trend control chart is shown below using the global temperature data.

Global Temperature Data

land and oceanThe data used in this analysis was downloaded from the Goddard Institute for Space Studies (GISS) website at this link.  GISS is part of the National Aeronautics and Space Administration (NASA).  Last month, we looked at using a control chart to see periods of stability and periods when the global temperature was increasing.  The data covered the years from 1880 – 2015.   The annual data was used in last month’s publication.  The data were based on the meteorological station data, which is called the dTs data.  

There is also the LOTI (land-ocean temperature index).  According to the website, LOTI "provides a more realistic representation of the global mean trends than dTs; it slightly underestimates warming or cooling trends, since the much larger heat capacity of water compared to air causes a slower and diminished reaction to changes; dTs on the other hand overestimates trends, since it disregards most of the dampening effects of the oceans that cover about two thirds of the earth's surface."

This month we will use the LOTI data.  It, like the dTs data, is reported as anomalies (deviations), not an absolute temperature.  The website has this statement as well: “Temperature anomalies are computed relative to the base period 1951-1980. The reason to work with anomalies, rather than absolute temperature, is that absolute temperature varies markedly in short distances, while monthly or annual temperature anomalies are representative of a much larger region.”  In last month’s publication, we converted these anomalies from the baseline period to an absolute temperature by using 14 °C as the baseline temperature.  It is sometimes easier to understand an absolute temperature than the anomalies.  But 14 is not absolute.  Like everything, there is variation.

This time, however, we will use the anomalies as given on the website.  But, we will refer them as deviations from here on.    For example, for 2015, the deviation in temperature from the baseline period was reported as 87.  You divide this by 100 to get the deviations in degrees Celsius.  So, the deviation in 2015 from the base line period was 87/100 or 0.87 °C.   According to the press release on 1/20/2016, this is the largest increase in one year ever.

Our analysis last month showed that there was a long period of stability from 1936 to 1976.  The temperature then began to increase in 1977.  We will use the data from 1977 to 2015 in our trend control chart discussion.  These data are shown in Table 1.

Table 1: Temperature Deviations Based on Baseline Period of 1951 to 1980

YearDeviation YearDeviation
197718 199747
19787 199863
197917 199942
198028 200042
198133 200154
198213 200263
198331 200362
198416 200454
198512 200569
198619 200663
198734 200766
198840 200853
198929 200964
199044 201072
199142 201160
199223 201263
199324 201365
199432 201474
199546 201587
199634  

 

Classical Control Chart Approach

The data in Table 1 were used to construct an individuals control chart.   The X control chart for the data is shown in Figure 3.  You can easily see that the global temperature deviation is not consistent over time.  It appears to be steadily increasing.  There are runs above and below the average as well as points that are beyond the control limits.  This X control chart is not very useful for predicting what will occur in the future. 

Figure 3: X Chart for Global Temperature Deviations by Year

X chart on global warming

Figure 4 shows the moving range control chart.  The moving range is in statistical control.  It is consistent and predictable.  This means, that even though the average is changing over time, the variation about that average (the width of the histogram) is staying the same.  As long as this is true, we can use the trend control chart approach because the within variation (the moving range) is consistent over time. 

Figure 4: mR Chart of Global Temperature Deviation by Year

mR chart global warming

The problem is the X control chart.   The control limits for the X control chart are given below.

UCLx = X + 2.66R

LCLx = X - 2.66R

Note that the control limits are based on the overall average (X) and the average range (R).  The problem is the average in the global temperature deviations. It looks to be increasing in a predictable pattern.  Let’s check this with the trend control chart.

Trend Control Chart Approach

chartng trendThe trend control chart will help handle situations where the data are increasing or decreasing in a predictable fashion.  The first step is to determine the best-fit line of the data.  This equation has the following form:

Xt = mt + b

where (for our example) Xt is yearly temperature deviation, t is the year, m is the slope of the line and b is the y-intercept.  You then substitute this equation for the average in the control limit equations.  So, the control limits for the trend control chart are given by:

UCLx = mt + b + 2.66R

LCLx = mt + b - 2.66R

There are a number of ways to find the best-fit equation.  The results below are from the SPC for Excel program.  You can also use Excel’s built-in regression function.  The best-fit equation is:

Global Temperature Deviation = 1.631(Year) - 3211.3

The slope represents the rate of change in the global temperature deviation per year for this time period.   That rate of change is given by 1.631.  Remember that to convert this to degrees Celsius, you need to divide by 100.  So the rate of change is 0.01631 °C per year.

You must ask a question at this point about this best-fit equation.  “Is it statistically significant?"  You judge this by the p-value from the regression.  If the p-value is less than 0.05, you conclude it is statistically significant.  The p-value for this regression is much lower than 0.05, so it is statistically significant.  For more information on regression, please see our publication at this link.

One more questions to ask.  “Is the statistically significant correlation between the global temperature deviation and the year “worth” anything in real life?”  You get this from the R-squared value.  R-squared for this regression is 82.37%, which means that 82.37% of the variation in global temperature deviation can be explained by the increasing year number.  That is a pretty good percentage.  So, this best-fit equation can be used to help analyze the increase in global temperature deviation from year to year.

The control limits become:

UCLx = b + mt + 2.66R = -3211.3 + 1.631(Year) + 2.66(10)

LCLx = b + mt - 2.66R = -3211.3 + 1.631(Year) – 2.66(10)

Note that the control limits will trend with the average and the distance between the average and the control limits will be 2.66 times R.  Figure 5 shows the trend control chart for the global temperature deviation.

Figure 5: Trend Control Chart for Global Temperature Deviation

trend chart global warming

You can use the best-fit equation to determine the values for the average, UCL and LCL in 2015.

UCL = 101.8

Average = 75.2

LCL = 48.6

When you look at the trend control chart, it appears to be in statistical control.  The usual out of control tests apply to the trend control chart – points beyond the limits, zones tests, etc. 

You can now use the trend control chart to predict, within a range, what the deviation in the global temperature will be in 2016.

UCL = 103.4

2016 Prediction = 76.8

LCL = 50.2

earth heated by matchThis “model” predicts that the 2016 results will be 76.8 and in between 50.2 and 103.4.  Remember that the control limits are set at +/- three standard deviations, so there is a “wide”” range of possible results.  Most the time, the results will be within +/1 one standard deviation which would place the 2016 result from about 70 to 86.

The trend control chart performs just like a classical control chart.  It monitors the process for any special causes of variation and, if it is in statistical control, it can be used to predict future values- at least, within a range.

Summary

This month we took a look at how to handle data that is increasing or decreasing in a predictable fashion using a trend control chart.  The calculations involve determining the best-fit line for the data and using that as the center line on the X chart.  The center line and the control limits trend either up or down on a trend control chart.  The global temperature deviation per year was used as an example.

Quick Links

SPC for Excel Software

Visit our home page

SPC Training

SPC Consulting

Ordering Information

Thanks so much for reading our publication. We hope you find it informative and useful. Happy charting and may the data always support your position.

Sincerely,

Dr. Bill McNeese
BPI Consulting, LLC

View Bill McNeese's profile on LinkedIn

Connect with Us

       

Comments (4)

  • anon

    You deserve my Congratulations for your (pedagogical) work.I suggest you illustrate this and other examples with your software. You may also provide a trial/student version. If so, I can use it, and promote your software, in my classes.Best regards

    Jan 31, 2016
  • anon

    Thanks for your comment.   All the charts in our publications are made using the SPC for Excel software.  And we do have free 20-day demo of the software here:https://www.spcforexcel.com/spc-software/demo

    We do a studenet version that can be rented for 6 monhts.  Please contact me if you interested.

    Bill

    Jan 31, 2016
  • anon

    This sentence, "R-squared for this regression is 82.37%, which means that 82.37% of the variation in global temperature deviation can be explained by the increasing year number", I suggest is better stated as," ...82.37% of the variation in gobal temperature deviation is accounted for by the increasing year number."Isn't R-squared an accounting? Or are accounting and explaining synonyms?

    Jul 18, 2017
  • anon

    I think, in this case, they are synonyms.  But I like your sentence better.  

    Jul 18, 2017

Leave a comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <h1> <h2> <h3> <h4> <h5> <h6> <img> <hr> <div> <span> <strike> <b> <i> <u> <table> <tbody> <tr> <td> <th>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.