Excel Function : FORECAST.LINEAR

Download now!

Excel Function : FORECAST.LINEAR

Category

Statistical

Description

Returns a future value based on existing values

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FORECASTLINEAR-function-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.linear

Syntax and Description of the FORECAST.LINEAR Excel Function

The syntax for the FORECAST.LINEAR function in Microsoft Excel is: FORECAST.LINEAR(x, known_y's, known_x's) x - The value for which you want to predict a value known_y's - The set of y-values known to exist known_x's - The set of x-values corresponding to the known_y's

About FORECAST.LINEAR Excel Function

The FORECAST.LINEAR function predicts a future value by using the linear relationship between a set of known values and values that are predicted for the future. The known values are plotted on a line, and the function uses this line to predict the value for a given x-value.