Calculates or predicts a future value by using existing values along a linear trend.
Söz dizimi
FORECAST.LINEAR(x, known_ys, known_xs)Bağımsız değişkenler
xzorunlu
The data point for which you want to predict a value.
known_yszorunlu
The dependent array or range of data.
known_xszorunlu
The independent array or range of data.
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.
=FORECAST.LINEAR(6, {10, 20}, {1, 2})→60Predicts the y-value for x=6 based on the linear trend of points (1,10) and (2,20).
Prepare your data
Organize your known x and y values into two separate columns or arrays.
Enter the formula
Select a cell and input the function, referencing the target x-value and the ranges containing your known data.
They are functionally identical; FORECAST.LINEAR is the modern naming convention introduced to improve clarity.