GROWTH

  • Updated

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)