Lag Tool

Summary

The Lag tool is supported in the Time Series Analysis App. It is used to calculate lag or lead of a time series. This tutorial uses App's built-in sample project. To open this sample OPJU file:

  1. Right click the Time Series Analysis App icon Time Series Analysis icon.png in the Apps Gallery and choose Show Samples Folder.
  2. A folder will open. Drag-and-drop the project file TSA Sample.opju into Origin.

Lag

  1. Expand Project Explorer docked on the left. Select folder Transform and Decompose and go to sheet "Sheet1" in workbook "Annual electricity sales for South Australia from 1989 to 2008 - Copy".
    LagTool TSA 00.png
  2. Click the Time Series Analysis App icon Time Series Analysis icon.png in the Apps Gallery. Click the button Lag under the Tranform and Decompose tab to open the app dialog.
    LagTool TSA 01.png
  3. Select the col(B) as Time Series; Enter -1 for Lag.
    Imple Time Series Analysis 02 a.png
  4. Click OK button to perfrom the analysis.
    Imple Time Series Analysis 02 b.png
The results are gotten by moving col(B) forward one row but keeping the original col(A).

Algorithm

Lag tool can shift a time series down by a number of rows.

Given a time series xi, i = 1, 2, ..., n, when lag k > 0, the first k elements in the result will be missing values, and the time series will be shifted down by k units. If k < 0, the last |k| elements in the result will be missing values, and the time series will be back shifted by |k| units.