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