Excel Function : TREND
Category
Statistical
Description
Returns values along a linear trend
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TREND-function-e2f135f0-8827-4096-9873-9a7cf7b51ef1
Syntax and Description of the TREND Excel Function
The syntax for the TREND function in Microsoft Excel is: TREND(known_y's, known_x's, new_x's, const) Arguments known_y's The known y-values that you want to use to predict unknown y-values. known_x's The known x-values that you want to use to predict unknown y-values. new_x's The new x-values that you want to use to predict unknown y-values. const A logical value that specifies whether to force the constant b to equal 0. Example TREND(A2:A6,B
About TREND Excel Function
The TREND function is used to calculate a linear trend line through a given set of y-values and to extend the line to predict additional y-values. The TREND function uses the least squares method to calculate the line of best fit.