Solution for
Regression Equation of Water/Temperature/Sun example
The coefficients for the model are shown below in red.
The resulting model is
Water = - 106.83 + 1.54*Temperature + 5.37*Sun
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
Multiple R |
0.986987 |
|
|
|
|
|
|
|
|
R Square |
0.974143 |
|
|
|
|
|
|
|
|
Adjusted R Square |
0.961214 |
|
|
|
|
|
|
|
|
Standard Error |
2.51291 |
|
|
|
|
|
|
|
|
Observations |
7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
Regression |
2 |
951.5983 |
475.7991 |
75.34764 |
0.000669 |
|
|
|
|
Residual |
4 |
25.25887 |
6.314719 |
|
|
|
|
|
|
Total |
6 |
976.8571 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
-106.831 |
11.32667 |
-9.43183 |
0.000705 |
-138.279 |
-75.3833 |
-138.279 |
-75.3833 |
|
Temperature |
1.538509 |
0.125424 |
12.26651 |
0.000254 |
1.190277 |
1.886742 |
1.190277 |
1.886742 |
|
Sun |
5.36558 |
1.986424 |
2.701126 |
0.054031 |
-0.14963 |
10.88079 |
-0.14963 |
10.88079 |
|
Solution
Interpretation
or
back
to Using Excel.
Learn the Procedure Modeling with Indicator Variables.
Regression
Tutorial Menu Dictionary
STATS @
MTSU