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

 

Solution Interpretation

or back to Using Excel.


Learn the Procedure for calculating correlation coefficients

  

Regression Tutorial Menu    Dictionary

STATS @ MTSU