GROWTH

GROWTH(arg1, arg2, arg3, arg4) → { number }

Calculates predicted exponential growth by using existing data.

Parameters:

Name Type Description
arg1 ApiRange | Array.<number>

The set of y-values from the y = b*m^x equation, an array or range of positive numbers.

arg2 ApiRange | Array.<number>

An optional set of x-values from the y = b*m^x equation, an array or range of positive numbers that has the same size as the set of y-values.

arg3 ApiRange | Array.<number>

New x-values for which the function will return the corresponding y-values.

arg4 boolean

A logical value: the constant b is calculated normally if this parameter is set to true, and b is set equal to 1 if the parameter is false or omitted.

Returns:

Type
number