Author: Oscar Cronquist Article last updated on April 14, 2018

The FORECAST.LINEAR function calculates a value based on existing x and y values using linear regression.

Use this function to predict linear trends.

Formula in cell D3:


Excel Function Syntax

FORECAST.LINEAR(x, known_y's, known_x's)


x Required. The data point for which you want to predict a value.
known_y's Required. Known y points.
known_x's Required. Known x points.


The chart below shows the predicted value as a red dot, based on x and y values represented by the blue line.