Calculates values based on an exponential trend.
Sample Usage
GROWTH(B2:B10,A2:A10)
GROWTH(B2:B10,A2:A10,A11:A13,FALSE)
Syntax
GROWTH(known_data_y, known_data_x, [new_data_x], [constant])
- known_data_y - The array or range containing dependent (y) values.
- known_data_x - The array or range containing independent (x) values corresponding with known_data_y.
- new_data_x - [OPTIONAL] The array or range containing new x-values for which you want the corresponding y-values.
- constant - [OPTIONAL] A logical value that determines whether to calculate the constant ‘b’ or to set it to 1.
- If set to TRUE or omitted, b is calculated normally.
- If set to FALSE, b is set equal to 1 and the m-values are adjusted so that y = m^x.
Examples
GROWTH(B2:B10,A2:A10)
GROWTH(B2:B10,A2:A10,A11:A13,FALSE)