Excel functions / Statistics

LOGEST function

Fits an exponential curve, y = b × m^x, and returns the growth factor m and the starting value b, with the regression statistics if you ask. Spills.

Syntax

=LOGEST(known_y, [known_x], [const], [stats])

Arguments

When to use it

LOGEST fits an exponential curve, y = b × m^x, to data and spills the growth factor m and the starting value b. With TRUE as the last argument it adds the regression statistics.

Examples

  1. Growth factor and start

    ABCDE
    1xy
    21100250
    32200
    43400

    In D2: =LOGEST(B2:B4, A2:A4) → 2, 50

    Try this example

Common mistakes

LOGEST in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try LOGEST in the playground

Related functions