#excel 25 - Predict sales using FORECAST.LINEAR function #Shorts

#excel 25 - Predict sales using FORECAST.LINEAR function
The FORECAST. LINEAR function is one of the statistical functions. It is used to calculate, or predict, a future value by using existing values; 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.

How do you calculate forecast using linear regression?
This equation, as the FORECAST.
So, the overall regression equation is Y = bX + a, where:
X is the independent variable (number of sales calls)
Y is the dependent variable (number of deals closed)
b is the slope of the line.
a is the point of interception, or what Y equals when X is zero. #MSExcel #ExcelTrick #Simpletricks #ExcelShort