Statistical
GROWTH function: fit an exponential curve y = b * m^x to positive historical series
Project compounding series along a least-squares exponential curve with GROWTH, and see why zero or negative Y values return #NUM!.
Least-squares regression in log-Y space
GROWTH(known_y's, [known_x's], [new_x's], [const]) fits an exponential curve y = b * m^x by regressing ln(y) on x and evaluating the fitted curve at new_x.
All known_y values must be strictly positive; zero or negative values return #NUM!.
=ROUND(GROWTH(B2:B5, A2:A5, D2), 2)Try the example
Use the original values or change them to test your understanding.