How to Read Regression Analysis Summary in Excel
Find the intercept., Find the slope., Create your equation using these two values., Find the Adjusted R Square value.
4 Steps
1 min read
Easy
Step-by-Step Guide
-
Step 1: Find the intercept.
In the picture above, it is cell B17
- 12,226.92. -
Step 2: Find the slope.
In the picture above, it is cell B18
- 1,833.016. , Using the values above:
Y = 12,226.92 + 1,833.016X , This is the percentage measurement of goodness of fit.
The higher this value, the more accurate your equation is.
In the picture above, it is cell B6
- approx 60%. -
Step 3: Create your equation using these two values.
-
Step 4: Find the Adjusted R Square value.
Detailed Guide
In the picture above, it is cell B17
- 12,226.92.
In the picture above, it is cell B18
- 1,833.016. , Using the values above:
Y = 12,226.92 + 1,833.016X , This is the percentage measurement of goodness of fit.
The higher this value, the more accurate your equation is.
In the picture above, it is cell B6
- approx 60%.
About the Author
P
Patricia Morgan
Creates helpful guides on lifestyle to inspire and educate readers.
44 articles
View all articles
Rate This Guide
--
Loading...
5
0
4
0
3
0
2
0
1
0
How helpful was this guide? Click to rate: