From the course: Time Series Modeling in Excel, R, and Power BI
Join today to access over 24,800 courses taught by industry experts.
Lags
From the course: Time Series Modeling in Excel, R, and Power BI
Lags
- [Instructor] Calculating lags in time series allows us to delay or move forward a time series by n periods in time. For example, we can use lags to line up separate time series data observations or we can use them to bootstrap data within a single time series. In Excel, let's copy the sheet for the fitted model as the yearly numbers and we're going to rename it autoregressive or AR. Just delete the chart and let's also rename sheet one Residuals. A lag of n equals zero periods means that our initial temperatures, the temperature we measured by month, is going to have a lag of zero. Let's note that it has a lag of zero above the column name. In this particular model, lag of n represents a number of years we want to lag our model. Let's create a new field for a lag of one year. We calculate a lag of one using relative references for our current cell to reference the previous month's temperature. We can calculate…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.