Excel functions / Statistics
GROWTH function
Values on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.
Syntax
=GROWTH(known_y, [known_x], [new_x], [const])
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, …new_x(optional): The x values to predict for. Default: known_x.const(optional): FALSE forces the curve to start from 1. Default TRUE.
When to use it
GROWTH predicts values for something that grows by a steady percentage: it fits an exponential curve to the numbers you have and reads new values off it. TREND and FORECAST do the same with a straight line, for things that grow by a steady amount.
Give it the known values, the known periods, and the periods to predict.
Examples
Next month, for sales that grow 10% a month
A B C D 1 Month Sales 2 1 1000 1464.1 3 2 1100 4 3 1210 5 4 1331 In D2:
=GROWTH(B2:B5, A2:A5, 5)→ 1464.1What a straight line would have said
A B C D 1 Month Sales 2 1 1000 28.1 3 2 1100 4 3 1210 5 4 1331 In D2:
=GROWTH(B2:B5, A2:A5, 5)-FORECAST(5, B2:B5, A2:A5)→ 28.1The curve is ahead of the line, and the gap widens every month.
Common mistakes
- Zero or negative values. An exponential curve never reaches zero, so every known value must be greater than 0, or the result is #NUM!.
- Forecasting too far. Steady percentage growth compounds quickly. A curve that fits four months can give absurd numbers for month 40.
- Using it on steady growth. If the values rise by about the same amount each period, not the same percentage, TREND or FORECAST fits better.
GROWTH 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: LOGLINTREND
- Danish: FORØGELSE
- Dutch: GROEI
- Finnish: KASVU
- French: CROISSANCE
- German: VARIATION
- Hungarian: NÖV
- Italian: CRESCITA
- Norwegian: VEKST
- Polish: REGEXPW
- Portuguese (Brazil): CRESCIMENTO
- Portuguese (Portugal): CRESCIMENTO
- Russian: РОСТ
- Spanish: CRECIMIENTO
- Swedish: EXPTREND
- Turkish: BÜYÜME
Related functions
- TREND: Values on the best-fit straight line (least squares): fitted values for the known data, or predictions for new x values. Spills.
- FORECAST: Predicts a y value for a new x from the best-fit straight line through known data.
- LOGEST: 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.
- 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).