Include Top

Utilities Lag Data

The Lag Data utility is a useful utility to create Lag (or Lead) columns of data. This was demonstrated previously in the section Autocorrelation (ACF/PACF) Plots.

  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. Click SigmaXL > Time Series Forecasting > Utilities > Lag Data. Ensure that the entire data table is selected. If not, Use Entire Data Table. Click Next.
  3. Click Concentration, click Numeric Time Series Data (Y) >>. Use the default Number of Lags = 1.


  4. Click OK. A new sheet is created with the Lag 1 data.

  5. Click Recall SigmaXL Dialog menu or press F3 to recall last dialog. Enter Lag = 2. Click OK. Repeat for Lag = 3. The Lag columns are appended as shown:


Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

Lean Six Sigma Software Excel Add-in

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

Phone: 1.888.SigmaXL (744.6295)