LOGEST

Definition: LOGEST is a function that calculates an exponential curve that fits a set of data points using the least squares method.

Syntax: =LOGEST(known_y’s, [known_x’s], [const], [stats])

Situation: This formula is appropriate when you need to fit an exponential curve to a set of data points.

Example: If you have a set of known x and y values, the exponential curve can be found using the formula =LOGEST(B1:B10, A1:A10, TRUE, TRUE).