LINESTB, LINESTM, LINESTR

LINESTB and LINESTM return, individually, the values that are returned as an array by Microsoft Excel's LINEST function. That is, they respectively return the values b and m 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.

Here is the syntax of each function::

• =LINESTB(y_values,x_values,[constant])
• =LINESTM(y_values,x_values,[constant])
• =LINESTR(y_values,x_values,[constant])

The constant parameter is optional and refers to the constant B, M, or R, depending on the function. Its value can be True or False. If True or omitted, the value of B, M, or R is treated normally. If False, the value of of B, M, or R is treated as 0.