Case #9

Using Correlation to determine the best lag

Objectives

  • Finding the optimal lag based on the correlation between series
  • Using the Lag analysis
  • Circling several values of a series

Solution

If you get stuck, use the video or worksheet to see what to do next.

If you need more detailed help, have a look at the learning resources below.

The Macrobond document is also available for download here.

Video (Note that since making this video we have further developed some elements in app and our structure of the data)

Worksheet

Learning resources for this case

Graph layout

Correlation analysis

Category chart

Lag analysis

Working with observation labels