![]()
Solution for
Regression Equation of Temperature/Mowing
Time/Water example.
|
SUMMARY OUTPUT |
||||||||
|
Regression Statistics |
||||||||
|
Multiple R |
0.996822 |
|||||||
|
R Square |
0.993654 |
|||||||
|
Adjusted R Square |
0.990481 |
|||||||
|
Standard Error |
1.244877 |
|||||||
|
Observations |
7 |
|||||||
|
ANOVA |
||||||||
|
df |
SS |
MS |
F |
Significance F |
||||
|
Regression |
2 |
970.6583 |
485.3291 |
313.1723 |
4.03E-05 |
|||
|
Residual |
4 |
6.198878 |
1.549719 |
|||||
|
Total |
6 |
976.8571 |
||||||
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
|
Intercept |
-121.655 |
6.540348 |
-18.6007 |
4.92E-05 |
-139.814 |
-103.496 |
-139.814 |
-103.496 |
|
Temp. |
1.512364 |
0.060771 |
24.88626 |
1.55E-05 |
1.343636 |
1.681092 |
1.343636 |
1.681092 |
|
Time Mowing |
12.53168 |
1.93302 |
6.482954 |
0.002918 |
7.164746 |
17.89862 |
7.164746 |
17.89862 |
or back to Using Excel.
Learn the Procedure for calculating correlation coefficients
Regression Tutorial Menu Dictionary