This function calculates a future value using existing values.
Syntax
FORECAST(value,Yarray,Xarray)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| value | Value for which to predict the future dependent value |
| Yarray | An array of known dependent values (y’s) |
| Xarray | An array of known independent values (x’s) |
Remarks
The predicted value is a y value for a given x value. The known values are existing x values and y values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.
This function is calculated as follows:
where v is the value argument, Y is the Yarray argument, X is the Xarray argument, and n is the size of the arrays.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
FORECAST(30,G1:G9,F1:F9)
FORECAST(30,R1C7:R9C7,R1C6:R9C6)
FORECAST(45,{53000,57000,58000,69000,74500,55620,80000, 68700},{35,31,47,51,37,31,58,39}) gives the result 67060.8665320360