Case #10

Creating a regression model with a fitted line

Objective

Limiting the data sample

Performing a simple regression analysis

Adding a regression line in a scatter chart

Solution

If you get stuck, use the 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.

Worksheet

Learning resources for this case

Rate of change analysis

Scatter chart

Regression analysis

Graph layout

Setting time range

Dynamic text