GROWTH function

GROWTH(knownYValues, knownXValues?, newXValues?, useConstant?) GROWTH(knownYValues; knownXValues?; newXValues?; useConstant?)

knownYValues — { Number }

The set of known vertical values. This array must have the same size as the knownXValues parameter, if that parameter is provided.

knownXValues — { Number } (optional)

The set of known horizontal values. If provided, this array must have the same size as the knownYValues parameter. If omitted, this parameter is assumed to be equivalent to SEQUENCE(SIZE(knownYValues))SEQUENCE(SIZE(knownYValues)): { 1, 2, 3, ... }{ 1; 2; 3; ... }.

newXValues — { Number } (optional)

The horizonal coordinates of the sought data points. If omitted, this parameter is assumed to be identical to the knownXValues parameter.

useConstant — Logical (optional)

FALSE if the b factor in the equation should be set to 1, TRUE if it should be calculated from the data. If omitted, TRUE is assumed.

Returns — { Number }

Returns the points of an exponential curve through the given data points.

Returns the points of an exponential curve of the form y = b * m ^ x through the given data points using linear regression.

Example

GROWTH({ 4, 5, 6, 7 }, { 1.8, 3.2, 6.2, 8.2 })GROWTH({ 4; 5; 6; 7 }; { 1,8; 3,2; 6,2; 8,2 })

Returns an array roughly equivalent to { 4.2, 4.7, 6.0, 7.1 }{ 4,2; 4,7; 6,0; 7,1 }.