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.
Table with predictions.