Excel Function : FORECAST.LINEAR
Category
Statistical
Description
Returns a future value based on existing values
Microsoft Excel Reference Page
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.