STOR 155 hw 5 excel

STOR 155 hw 5 excel - field 20.2 56 12.5 21.2 15.5 39 21...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
lab field pred field residual 20.2 18 19.621882 -1.621882 56 38 45.63631 -7.63631 12.5 15 14.0266 0.9734 21.2 20 20.348542 -0.348542 15.5 18 16.20658 1.79342 SUMMARY OUTPUT 39 36 33.28309 2.71691 21 20 20.20321 -0.20321 Regression Statistics 38.2 43 32.701762 10.29824 Multiple R 0.944485 55.6 45 45.345646 -0.345646 R Square 0.892051 81.9 65 64.456804 0.543196 Adjusted R 0.89095 39.5 43 33.64642 9.35358 Standard E 6.173804 56.4 38 45.926974 -7.926974 Observatio 100 40.5 33 34.37308 -1.37308 14.3 10 15.334588 -5.334588 ANOVA 81.5 50 64.16614 -14.16614 df SS MS F ignificance F 13.7 10 14.898592 -4.898592 Regression 1 30867.69 30867.69 809.8383 3.6E-049 81.5 50 64.16614 -14.16614 Residual 98 3735.354 38.11586 20.5 15 19.83988 -4.83988 The measurments found in the laboratory seem to Total 99 34603.04 56 53 45.63631 7.36369 be good predictors for what happens in the field 80.7 60 63.584812 -3.584812 seeing as how R squared is so close to one and r Coefficients tandard Err t Stat P-value Lower 95%Upper 95% Lower 95.0% Upper 95.0% 20 18 19.47655 -1.47655 by itself is even closer showing a very strong Intercept 4.943348 1.182381 4.180841 6.3E-005 2.596951 7.289745 2.596951 7.289745 56.5 38 45.99964 -7.99964 positive relationship. X Variable 0.726663 0.025535 28.45766 3.6E-049 0.67599 0.777336 0.67599 0.777336 12.1 15 13.735936 1.264064 19.6 20 19.185886 0.814114 15.5 18 16.20658 1.79342 38.8
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online