

Forecast Function in Excel 

A useful function for business 

FORECAST function in Excel is a
statistical function
that calculates, or predicts, a future value by using existing values.
The predicted value is a yvalue for a given xvalue. The known values
are existing xvalues and yvalues, and the new value is predicted by
using linear regression. You can use this Excel function to predict
future sales, inventory requirements, consumer trends or weight loss!. Syntax FORECAST(x,known_y's,known_x's) X is the data point for which you want to predict a value. Known_y's is the dependent array or range of data. Known_x's is the independent array or range of data. Remarks
The equation for FORECAST is a+bx, where: and: and where x and y are the sample means AVERAGE(known_x's) and AVERAGE(known y's). The Excel training video demonstrates the concept. 








