LOGEST

LOGEST(arg1, arg2, arg3, arg4) → { number }

Returns statistics that describe an exponential curve matching known data points.

Parameters:

Name Type Description
arg1 ApiRange

The set of y-values from the y = b*m^x equation.

arg2 ApiRange

An optional set of x-values from the y = b*m^x equation.

arg3 boolean

A logical value: the constant b is calculated normally if this parameter is set to true or omitted, and b is set equal to 1 if the parameter is false.

arg4 boolean

A logical value: return additional regression statistics if this parameter is set to true, and return m-coefficients and the constant b if the parameter is false or omitted.

Returns:

Type
number