Solution for Regression Equation of Water/Temperature example.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
|
Multiple R |
0.962797233 |
|
|
|
|
|
|
|
|
R Square |
0.926978513 |
|
|
|
|
|
|
|
|
Adjusted R Square |
0.912374215 |
|
|
|
|
|
|
|
|
Standard Error |
3.777077216 |
|
|
|
|
|
|
|
|
Observations |
7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
|
Regression |
1 |
905.5256 |
905.5256 |
63.473 |
0.000503 |
|
|
|
|
Residual |
5 |
71.33156 |
14.26631 |
|
|
|
|
|
|
Total |
6 |
976.8571 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
-96.84518272 |
16.09237 |
-6.01808 |
0.001821 |
-138.212 |
-55.4785 |
-138.212 |
-55.4785 |
|
Temperature (F) |
1.451162791 |
0.182147 |
7.966994 |
0.000503 |
0.98294 |
1.919385 |
0.98294 |
1.919385 |
or back to Using Excel.
Learn the Procedure for calculating the Regression Equation
Simple Linear Regression Menu Dictionary