LINESTB, LINESTM, LINESTR

LINESTB and LINESTM return, individually, the values which are returned as an array by Microsoft Excel's LINEST function. That is, they return the values m and b in the equation y = mx + b, used for linear trend analysis.

LINESTR returns the correlation coefficient of a linear trend analysis.

The syntax of all three functions is the same. And, the syntax is the same as for Excel's LINEST, except that it does not include the fourth, Stats, argument of LINEST.

So, the syntax is:

  • =LINESTB(known_y_values,known_x_values,constant)
  • =LINESTM(known_y_values,known_x_values,constant)
  • =LINESTR(known_y_values,known_x_values,constant)
Parent topic: Formulas