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
known_y: The dependent values: what you want to explain or predict.known_x(optional): The independent values; several columns for several variables. Default 1, 2, 3, …const(optional): FALSE forces b to be 1. Default TRUE.stats(optional): TRUE adds four rows of statistics under the coefficients. Default FALSE.
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
Growth factor and start
A B C D E 1 x y 2 1 100 2 50 3 2 200 4 3 400 In D2:
=LOGEST(B2:B4, A2:A4)→ 2, 50
Common mistakes
- Zero or negative values. Every y must be greater than 0.
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.
- Czech: LOGLINREGRESE
- Danish: LOGREGR
- Dutch: LOGSCH
- Finnish: LOGREGR
- French: LOGREG
- German: RKP
- Hungarian: LOG.ILL
- Italian: REGR.LOG
- Norwegian: KURVE
- Polish: REGEXPP
- Portuguese (Brazil): PROJ.LOG
- Portuguese (Portugal): PROJ.LOG
- Russian: ЛГРФПРИБЛ
- Spanish: ESTIMACION.LOGARITMICA
- Swedish: EXPREGR
- Turkish: LOT
Related functions
- GROWTH: Values on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
- LINEST: Fits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills.
- RRI: The steady growth rate per period that turns one amount into another (CAGR).