LOGEST Function in Google Sheets

Perform exponential regression analysis using the LOGEST function.

LOGEST Function

The LOGEST function in Google Sheets performs exponential regression analysis on a dataset.

Syntax

LOGEST(known_data_y, [known_data_x], [b], [verbose])
  • known_data_y: The dependent data for regression.
  • known_data_x: The independent data (optional).
  • b: A logical value to force b to 0 (optional).
  • verbose: A logical value to return additional regression statistics (optional).

Examples

  1. Basic Example

Perform exponential regression on data in A1:A10 with independent data in B1:B10:

=LOGEST(A1:A10, B1:B10)

Notes

  • Returns regression statistics including exponential coefficients.
  • TREND: Calculate linear trends.