Case #10

Creating a regression model with a fitted line


Limiting the data sample

Performing a simple regression analysis

Adding a regression line in a scatter chart


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.


Learning resources for this case

Rate of change analysis

Scatter chart

Regression analysis

Graph layout

Setting time range

Dynamic text