The LINEST Function in Excel Sales Forecasting

The LINEST (or linear estimate) function in Excel sales forecasting uses formulas to calculate a regression equation and related statistics. This chart shows the information the Excel LINEST function will give you:


































Column 1Column 2
Row 1The coefficient you multiply times the X valuesThe intercept
Row 2The standard error of the coefficientThe standard error of the intercept
Row 3The R-squared value, or coefficient of determination.The standard error of estimate
Row 4The F-ratioThe degrees of freedom
Row 5The sum of squares for the regressionThe sum of squares for the residual



dummies

Source:http://www.dummies.com/how-to/content/the-linest-function-in-excel-sales-forecasting.html

No comments:

Post a Comment