What You Get Out of the Excel LINEST Function for Sales Forecasting

By Conrad Carlberg

Part of Excel Sales Forecasting For Dummies Cheat Sheet

Excel’s LINEST function is a handy tool for sales forecasting. Knowing what you can do with it will make your forecasting endeavors easy work. Here is a quick rundown on Excel’s LINEST function, row by row:

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