LOGEST

  • Updated

Returns an array that describes the exponential curve that fits the given data.

Sample Usage

LOGEST(B2:B10,A2:A10)
LOGEST(B2:B10,A2:A10,TRUE,TRUE)

Syntax

LOGEST(known_data_y, [known_data_x], [constant], [statistics])

  • known_data_y - The array or range containing dependent (y) values.
  • known_data_x - [OPTIONAL] The array or range containing independent (x) values corresponding with known_data_y.
  • constant - [OPTIONAL] A logical value that determines whether to calculate the constant ‘b’ or to set it to 1. 
    • If set to TRUE or omitted, b is calculated normally.
    • If set to FALSE, b is set equal to 1 and the m-values are adjusted so that y = m^x.
  • statistics - [OPTIONAL] A logical value that determines whether to return additional regression statistics. FALSE by default.

Examples

LOGEST(B2:B10,A2:A10) 
LOGEST(B2:B10,A2:A10,TRUE,TRUE)