In This Topic

LOGEST

In This Topic

This function calculates an exponential curve that fits the data and returns an array of values that describes the curve.

LOGEST(*y*,*x*,*constant*,*stats*)

The equation for the curve is y=b*m^x or y=(b*(m1^x1)*(m2^x2)*_).

This function has these arguments:

Argument | Description |
---|---|

y |
Set of y values that are known in the relationship y=b*m^x |

x | (Optional) X is an optional set of x values that may be known in the relationship y=mx+b |

constant |
Logical value that specifies whether to force the constant b to equal 0. If true or omitted then b is calculated normally; if false then b is equal to 0 and the m values are adjusted so that y=m^x. |

stats |
Logical value that specifies whether to return additional regression statistics. If true, then the additional regression statistics are returned if false or omitted then only the m-coefficients and b are returned. |

If x is omitted then x defaults to the array {1,2,3...}, that has the same dimensions as y.

Use the INDEX function to get individual elements from the returned array.

Accepts an array. Returns an array.

LOGEST(A2:A7,C2:C7,TRUE,FALSE)

This function is available in product version 2.0 or later.

GROWTH | TREND | LINEST | DEVSQ | MEDIAN | VAR | Statistical Functions