Documentation/Calc Functions/FORECAST.LINEAR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

FORECAST.LINEAR

Category:

Statistical Analysis

Summary:

Extrapolates future values based on existing x and y values.

Syntax:

FORECAST.LINEAR(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.LINEAR(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
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

ODF standard:

Equivalent Excel functions: