GROWTH function

GROWTH (KnownYValues, KnownXValues?, NewXValues?, UseConstant?) GROWTH (KnownYValues; KnownXValues?; NewXValues?; UseConstant?)

KnownYValues

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

KnownXValues

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

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

UseConstant

Logical 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

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 }.