LOGESTB, LOGESTM, LOGESTR

LOGESTB and LOGESTM return, individually, the values that are returned as an array by Microsoft Excel's LOGEST function. That is, they respectively return the values b and m in the equation y = b*m^x, used to calculate an exponential curve.

LOGESTR returns the correlation coefficient of an exponential trend analysis.

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

Here is the syntax of each function:

• =LOGESTB(y_values,x_values,constant)
• =LOGESTM(y_values,x_values,constant)
• =LOGESTR(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 1.