Regression Analysis Microsoft® Excel®

4. Using the LINEST() Function

In This Chapter

Array-Entering LINEST()

Comparing LINEST() to SLOPE() and INTERCEPT()

The Standard Error of a Regression Coefficient

The Squared Correlation, R²

The Standard Error of Estimate

Understanding LINEST()’s F-ratio

The General Linear Model, ANOVA, and Regression Analysis

Other Ancillary Statistics from LINEST()

The worksheet function LINEST() is the heart of regression analysis in Excel. You could cobble together a regression analysis using Excel’s matrix analysis functions without resorting to LINEST(), but you would be working without your best tools. So here you are, three chapters into a book entirely about regression, and I haven’t even said anything about how to enter Excel’s most important regression ...