Description

The TREND function in Excel calculates values along a linear trend. It fits a straight line to the given data, and based on that line, calculates future (or unknown) values based on new specified x-values. It is useful for predicting future values based on historical data.

Specific number of previous observations

Number of years in the historical series to be observed..

Initial Projection Year

Initial Projection Year.

Final Projection Year

Final Projection Year.

Initial Historical Series Year

Initial Historical Series Year.

Final Historical Series Year

Final Historical Series Year.

Input Table Key

Name of the key column in the historical series table.

Historical Series Entry Table

Historical Series Entry Table.

Outputs

Table with predictions.