Google Sheets-funktion

FORECAST

Calculates or predicts a future value by using existing values along a linear trend.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

FORECAST.LINEAR(x, known_ys, known_xs)

The FORECAST.LINEAR function uses linear regression to predict a value based on historical data. It is the updated version of the legacy FORECAST function, providing better compatibility and clarity for linear trend analysis.

Argument

xobligatorisktThe data point for which you want to predict a value.
known_ysobligatorisktThe dependent array or range of data.
known_xsobligatorisktThe independent array or range of data.

Exempel

=FORECAST.LINEAR(6, {10, 20}, {1, 2})

Resultat: 60

Predicts the y-value for x=6 based on the linear trend of points (1,10) and (2,20).

Vanliga frågor

What is the difference between FORECAST and FORECAST.LINEAR?

They are functionally identical; FORECAST.LINEAR is the modern naming convention introduced to improve clarity.

Relaterade funktioner

TREND LINEST SLOPE