# Documentation/Calc Functions/LOGEST

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

LOGEST

## Category:

Array

## Summary:

This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).

## Syntax:

LOGEST(**DataY**; **DataX**; **FunctionType**; **Stats**)

## Returns:

## Arguments:

**DataY** represents the Y Data array.

**DataX** (optional) represents the X Data array.

**FunctionType** (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.

**Stats** (optional). If Stats=0, only the regression coefficient is calculated.

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

More explanations on top of this page.

## Additional details:

## Examples:

See LINEST. However, no square sum will be returned.