TREND(y,x,new_x,const) returns values along a linear trend : TREND « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. TREND
If const is TRUE or omitted, b is calculated normally.

If const is FALSE, b is set equal to 0 (zero), and the m-values are adjusted so that y = mx.

Input the formula: =TREND(B2:B10,A2:A10,C2:C10). Press Enter to get the result.
Input the formula: =TREND(B2:B13,A2:A13,C2:C13)

Referenced from Excel Help

21.74.TREND
21.74.1.TREND(y,x,new_x,const) returns values along a linear trendTREND(y,x,new_x,const) returns values along a linear trend