LOGEST Function Explained
The LOGEST Function in Microsoft Excel is used to calculate an exponential curve that best fits a set of data points. It returns an array of values that describe the curve, including the slope, y-intercept, and the correlation coefficient. It can also be used to predict future values based on the curve. The syntax for the LOGEST Function is LOGEST(known_y's, [known_x's], [const], [stats]).
LOGEST Function Syntax
LOGEST(known_y's, [known_x's], [const], [stats])
- known_y’s: An array or range of dependent data points.
- known_x’s: An array or range of independent data points. If omitted, the array {1,2,3,…} is assumed.
- const: A logical value that specifies whether to force the constant b in the equation to equal 0. If omitted, TRUE is assumed.
- stats: A logical value that specifies whether to return additional regression statistics. If omitted, FALSE is assumed.