# Documentation/Calc Functions/FORECAST

From The Document Foundation Wiki

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

## Function name:

FORECAST

## Category:

Statistical Analysis

## Summary:

Extrapolates future values based on existing x and y values.

## Syntax:

FORECAST(**Value**; **DataY**; **DataX**)

## Returns:

## Arguments:

**Value** is the x value, for which the y value on the linear regression is to be returned.

**DataY** is the array or range of known y's.

**DataX** is the array or range of known x's.

## Additional details:

## Examples:

=FORECAST(50;A1:A50;B1;B50) returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.

## Related LibreOffice functions:

FORECAST.ETS.ADD

FORECAST.ETS.MULT

FORECAST.ETS.PI.ADD

FORECAST.ETS.PI.MULT

FORECAST.ETS.SEASONALITY

FORECAST.ETS.STAT.ADD

FORECAST.ETS.STAT.MULT

FORECAST.LINEAR