Non-Linear Regression: Microsoft Excel Add-In

Calculates a model by means of the Non-Linear Regression method. It is included in the Regression group.

Select a series, to which results are loaded, in the Output Series drop-down list.

Arithmetic operations, numbers, round brackets can be used on creating a formula. It is also possible to use various series transformations when editing a formula: type in the name of the transformation, and then in round brackets specify its parameters separating them with commas. For example:

Cumulative(Benin|Annual[t],MsCumulativeMethodType.Average)

A formula must contain at least one coefficient and one explanatory series, otherwise the non-linear data transformation cannot be executed. For example:

(Benin|Annual+Sudan|Annual)/2*f1

This formula includes two explanatory series: Benin|Annual, Sudan|Annual, and one coefficient: f1.

To insert a function to a formula:

Enter the required formula in the formula area.
Use the IntelliSense technology:

Put the cursor to the formula area.
Press CTRL+SPACE.

The list of available functions and data will be shown. Click the function name in the list.

The function is inserted into the cursor position.

Available categories of functions match the set of functions available in the expression editor, and are given in the Functions Available in Expression Editor section.

To insert data to a formula:

Double-click the required data element in the series area.
Select the required data element in the series area and click the Insert into Formula button.

Use the IntelliSense technology:

Put the cursor to the formula area.
Press CTRL+SPACE.

The list of available data and functions will be shown. Click the data element in the list.

The series identifier is inserted into the formula next to the cursor position.

Lag value can be edited for all series in the formula. A lag controls shifting a series forward (positive values) or backwards (negative values) by the specified number of points in a time period. Clicking a series opens the Edit Lag dialog box, in which specify the required lag value.

To insert number to a formula:

Put the cursor to the required position.
Type the required number using the keyboard.

The number is inserted next to the cursor position.

When working with numbers, the clipboard standard operations are also available: copy, wrap and paste.

If a formula is set correctly, clicking the OK button closes the Calculation Options dialog box. A calculated series named Non-Linear Regression(<Explanatory_Series_List>) and containing the calculation results is added to the data table. For example:

Viewing Non-Linear Regression Formula

Setting Up Calculation Options

To change basic calculation options (output series and confidence limits relevance), use the Parameters tab in the side panel.

Make sure that the side panel is displayed.
Select the series calculated by the Non-Linear Regression method in the data table.
Select the Series radio button on the side panel.
Go to the Parameters tab.

To set up parameters of autofit of coefficient value used on method calculation, use the Estimation Parameters tab on the side panel: