Menu
EXCEL FORECAST FUNCTION
Excel FORECAST Function Introduction
Calculate or forecast a future value based on present data. For a given x-value, the future value is a y-value. Existing values are known as x-values and y-values, and future values are forecasted using linear regression. These capabilities can be used to forecast future sales, inventory needs, or customer patterns.
Description of Excel FORECAST Function
Syntax :
=FORECAST(x, known_y’s, known_x’s)
Parameters :
- The FORECAST function syntax consists of the following arguments:
x –
- The data point where a value is to be predicted.
known y’s –
- The dependant array or data range.
known x’s –
- The data range or independent array.
Step By Step Guide of FORECAST Function
Example :
To see the results of formulae, select them, press F2, and then Enter. You can alter the column widths to see all of the data if necessary.
Key Points
- If x is not a number, FORECAST and FORECAST are used. The #VALUE! error value is returned by LINEAR.
- If either known ys or known xs are empty, or if one has more data points than the other, FORECAST and FORECAST.
- The #N/A error value is returned by LINEAR. If the variance of known x’s is equal to zero, then FORECAST and FORECAST are used.
- The #DIV/0! error value is returned by LINEAR.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
