GROWTH function
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
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
Returns an array roughly equivalent to { 4.2, 4.7, 6.0, 7.1 }{ 4,2; 4,7; 6,0; 7,1 }.