LOGEST
Returns the parameters of an exponential trend
Syntax
LOGEST(known_y's, [known_x's], [const], [stats])
Parameters
- known_y's: Required. The set of y-values
- known_x's: Optional. The set of x-values
- const: Optional. TRUE to calculate b normally (default), FALSE to set b = 1
- stats: Optional. TRUE to return additional regression statistics
Example
=LOGEST(A1:A10, B1:B10, TRUE, TRUE)