|
<< Click to Display Table of Contents >> GROWTH (values of an exponential regression) |
Syntax:
GROWTH(y_values [, x_values] [, New_x_values] [, Constant])
Description:
Returns the values of an exponential regression.
Exponential regression is a statistical technique that adapts an exponential curve to a set of data points (for example, the results of a series of measurements).
The GROWTH function returns an array with the y values of a best-fit exponential curve based on the given y values and x values.
In detail, the function expects the following arguments:
y_values: Here you specify the existing y-coordinates, that is, the dependent values. y_values can be either a cell reference or an array. All of them must be positive, otherwise a #NUM! error value is returned.
x_values: Here you can optionally specify the x-coordinates, that is, the independent values. Also x_values can be either a cell reference or an array. If x_values are omitted, the values 1, 2, 3, ... will be used automatically. (according to the number of existing y_values).
New_x_values (optional) are the x values for which you want to determine the corresponding y values on the curve. If omitted, the values in x_values will be used. However, if required, you can specify other x-coordinates with New_x_values. New_x_values can also be either a cell reference or an array.
Constant (optional) is a logical value that lets you specify if the constant b should be calculated automatically or forced to equal 1:
TRUE or omitted: b will be calculated from the given data.
FALSE: b is forced to equal 1 (one), the m values are adjusted accordingly.
Note:
Formulas using this function have to be entered as an array formula. For more information, see Working with arrays.
See also: