Spread.Sheets Documentation
LOGEST

This function calculates an exponential curve that fits the data and returns an array of values that describes the curve.

Syntax

LOGEST(y,x,constant,stats)

Arguments

The equation for the curve is y=b*m^x or y=(b*(m1^x1)*(m2^x2)*_).

This function has these arguments:

Argument Description
y Set of y values that are known in the relationship y=b*m^x
x (Optional) X is an optional set of x values that may be known in the relationship y=mx+b
constant Logical value that specifies whether to force the constant b to equal 0. If true or omitted then b is calculated normally; if false then b is equal to 0 and the m values are adjusted so that y=m^x.
stats Logical value that specifies whether to return additional regression statistics. If true, then the additional regression statistics are returned if false or omitted then only the m-coefficients and b are returned.

If x is omitted then x defaults to the array {1,2,3...}, that has the same dimensions as y.

Remarks

Use the INDEX function to get individual elements from the returned array.

Data Types

Accepts an array. Returns an array.

Examples

LOGEST(A2:A7,C2:C7,TRUE,FALSE)

See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.