Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Interpreting QA output in Excel > Interpreting mutiple regression results Share

Interpreting mutiple regression results

Excel Help for Interpreting Mutiple Regression Results in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Interpreting Mutiple Regression Results

Rate this:
(3/5 from 1 vote)
Fedup^^^Again, sorry I posted the regression output an an image but it never showed up.
Here again as a word document and I hope it does make sense.  

SUMMARY OUTPUT













Regression Statistics





Multiple R
0.950600603





R Square
0.903641506





Adjusted R Square
0.901788458





Standard Error
19828.391





Observations
319












ANOVA






 
df
SS
MS
F
Significance F

Regression
6
1.15037E+12
1.91728E+11
487.6514414
3.1114E-155

Residual
312
1.22668E+11
393165089.6



Total
318
1.27303E+12











 
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
-6817.339436
7273.961335
-0.937225141
0.349367668
-21129.5598
7494.880931
Sq. Feet
63.33335967
2.912313097
21.74675509
1.81495E-64
57.60310281
69.06361652
Age
-333.836386
94.88326877
-3.518390442
0.000498725
-520.528367
-147.1444049
Bedrooms
-8444.831058
2176.762127
-3.879537848
0.000127688
-12727.82045
-4161.841664
Bathrooms
-949.1948635
1176.548696
-0.806762072
0.42041812
-3264.167878
1365.778151
Garage #
26246.43488
2075.752197
12.64430067
7.20288E-30
22162.19227
30330.6775
Area
62040.98324
3684.608474
16.83787672
1.04501E-45
54791.16076
69290.80573
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Interpreting mutiple regression results in the