LINEST(y,x,const,stats) returns the parameters of a linear trend : LINEST « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. LINEST
If stats is TRUE, LINEST returns the additional regression statistics

If stats is FALSE or omitted, LINEST returns only the m-coefficients and the constant b.

Input the formula: =LINEST(B2:B5,C2:C5,,FALSE). Press Enter to get the result.
Input the formula: =LINEST(B2:B5,C2:C5,,FALSE)

Referenced from Excel Help

21.40.LINEST
21.40.1.LINEST(y,x,const,stats) returns the parameters of a linear trendLINEST(y,x,const,stats) returns the parameters of a linear trend