It is a generalized linear model used for binomial regression.You can use these functions to predict future sales, inventory. The existing values are known x-values and y-values, and the future value is predicted by using linear regression. In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.It's a step by step guide to learn statistics with popular statistical tools such as SAS, R and Python.
With the aid of techniques such as least squares can estimate the parameters and by minimising the sum of the squares of the residuals, i.e the difference between an observed value, and the. is given by: where and are the parameters to be estimated to help us generate predictions.