LOGESTB, LOGESTM, LOGESTR

LOGESTB and LOGESTM return, individually, the values which are returned as an array by Microsoft Excel's LOGEST function. That is, they return the values m and b 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.

So, the syntax is:

  • =LOGESTB(known_y_values,known_x_values,constant)
  • =LOGESTM(known_y_values,known_x_values,constant)
  • =LOGESTR(known_y_values,known_x_values,constant)
Parent topic: Formulas