Include Top

Exponential Smoothing Control Chart

An Individuals control chart is created using the residuals of the Exponential Smoothing forecast model.

The Moving Limits chart uses the one step prediction as the center line, so the control limits will move with the center line. If a Box-Cox transformation is used then an inverse transformation is applied to calculate the control limits. If the residuals are exponential smoothing multiplicative, the control limits are approximate and out-of-control signals may not exactly match the Individuals Chart. If that occurs, the Individuals Chart should be used to determine what points are out-of-control.

The popular “Add Data”, “Show Last 30” and “Scroll” features in SigmaXL Chart Tools are available for these control charts. For “Add Data”, the time series models are not refitted, but used to compute the residual values for the new data.

Note that a Moving Range Chart and Tests for Special Causes are not available here, but the user can store and select Residuals, then create with SigmaXL > Control Charts > Individuals & Moving Range.

  1. Open Chemical Process Concentration – Series A.xlsx (Sheet 1 tab). This is the Series A data from Box and Jenkins, a set of 197 concentration values from a chemical process taken at two-hour intervals.
  2. Earlier we saw that this process has significant autocorrelation. In order to see the impact on a control chart, we will construct an Individuals chart on the raw data. Click SigmaXL > Control Charts > Individuals. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
  3. Select Concentration, click Numeric Data Variable (Y) >>. Click OK. An Individuals Control Chart is produced:


    EXPCC3
    There are 17 out-of-control data points, largely due to the autocorrelation. Searching for assignable causes using this chart as is would be futile.

  4. Now click Sheet 1 tab and SigmaXL > Time Series Forecasting > Exponential Smoothing Control Chart > Control Chart. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
  5. Select Concentration, click Numeric Time Series Data (Y) >>. Uncheck Display ACF/PACF/LB Plots. Leave Display Residual Plots, Specify Model Periods, Seasonal Frequency and Box-Cox Transformation unchecked.

    EXPCCStep5
    Since we will be running the same (A, N, N) model as used earlier, we will not need the ACF/PACF/LB and Residuals Plots.

  6. Click Model Options. Select Specify Model.

    EXPCCStep6
  7. We will use the default Error: Additive and Trend: None, which is a simple exponential smoothing model, or Exponentially Weighted Moving Average (EWMA). Click OK to return to the Exponential Smoothing Control Chart dialog. Click OK. The exponential smoothing control charts are produced:

    EXPCCStep7A
    EXPCCStep7B
    Now we only have two out-of-control data points on the Individuals chart to investigate. The Moving Limits chart uses the one step prediction as the center line, so the control limits move with the center line.

  8. You can scroll through the chart data points. Click SigmaXL Chart Tools > Enable Scrolling.

    EXPCCStep8
    You may be prompted with a warning message that custom formatting on the chart will be cleared. You can avoid seeing this warning by checking Save this choice as default and do not show this form again.

  9. Click OK. The scroll dialog appears allowing you to specify the Start Subgroup and Window Width. Enter Start Subgroup = 40 and Window Width = 30 to view the two out-of-control data points.

    EXPCCStep9
  10. Click OK. This allows us to zoom in on the out-of-control points at 43 and 64.

    EXPCCStep10A
    EXPCCStep10B
    Observation 43 is lower than expected from the exponential smoothing forecast model. Observation 64 is higher than expected.

  11. Click Cancel to exit the scroll dialog.
  12. Now we will add a new data point to the Series A Concentration Data. The residuals will be computed using the same model as above without re-estimation of the model parameters or recalculation of the control limits. This is also known as the “Phase II” application of a Control Chart, where an out-of-control signal should lead to an investigation into the assignable cause and corrective action or process adjustment applied. Click Sheet1, enter the value 19 as shown in cell B199 (and optionally Observation number 198 in cell A199).

    EXPCCStep12
  13. Click Exp. Smoothing Control Charts tab (if more than one control chart sheet exists in the workbook, please select the chart where the data will be added).
  14. Click SigmaXL Chart Tools > Add Data to this Control Chart.

    EXPCCStep14
  15. The Residuals Individuals Control Chart and Moving Limits Charts are now updated with the new data, showing this as an out-of-control data point:

    EXPCCStep15
    Now we have a chart that can be used to identify assignable causes. The number of out-of-control signals have been dramatically reduced.

  16. We recommend renaming the workbook to Chemical Process Concentration – Series A_AddData.xlsx, so that later use of the Concentration data does not include the added data point.





Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Ph: 1.888.SigmaXL (744.6295)

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com