Functions
LOGEST
Returns exponential regression statistics
Try it
When to use it
When should I use LOGEST?
Use LOGEST to fit an exponential regression curve to data and return the base and coefficient, useful when growth is multiplicative rather than additive.
Used in
Syntax
LOGEST(known_y, [known_x], [const], [stats])Examples
=LOGEST({2,4,8,16},{1,2,3,4}) // => 1.9999999999999996
=LOGEST({2,4,8,16},{1,2,3,4},TRUE) // => 1.9999999999999996
=LOGEST({2,4,8,16},{1,2,3,4},FALSE) // => 2