how to quickly understand excel regression output

7
How To Quickly Read and Understand the Output of Excel Regression

Upload: excel-master-series

Post on 08-Jul-2015

3.451 views

Category:

Education


1 download

DESCRIPTION

Learn How To Quickly Read and Understand the Output of Regression Done in Excel. This SlideShare and Attached Video Will Walk You Through in Easy, Step-By-Step Instructions How To Quickly Identify and Understand the 4 Most Important Parts of the Output of Regression Done in Excel. You'll Soon Be a Master of Excel

TRANSCRIPT

Page 2: How To Quickly Understand Excel Regression Output

The 4 Most Important Parts of Regression Output

● Overall Regression Equation’s Accuracy

● Probability That This Output Was Not By Chance

● Accuracy of Regression Coefficients and Y-Intercept

● Visual Analysis of Residuals

http://blog.excelmasterseries.com/

Page 5: How To Quickly Understand Excel Regression Output

Individual Regression Coefficient Accuracy ● P Values of Coefficients and Y Intercept