Excel Function : FORECAST
Category
Statistical
Description
Returns a value along a linear trend
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FORECAST-function-50ca49c9-7b40-4892-94e4-7ad38bbeda99
Syntax and Description of the FORECAST Excel Function
? The syntax for the FORECAST function in Microsoft Excel is: =FORECAST(x, known_y's, known_x's) where x is the value for which you want to predict a y-value, known_y's are the y-values for the known x-values, and known_x's are the x-values for the known y-values.
About FORECAST Excel Function
The FORECAST function predicts future values based on existing values. The function uses the least squares method to find the line of best fit for the given data. The function then predicts the y-value for the given x-value.