Article 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:

=FORECAST.LINEAR(E6,C3:C7,B3:B7)

Excel Function Syntax

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

Arguments

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.

Comments

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