50 200 233 300 292 400 371 460 450 300 300 333 05 in the full regression model

50 200 233 300 292 400 371 460 450 300 300 333 05 in

This preview shows page 86 - 121 out of 197 pages.

4.50 2.00 2.33 3.00 2.92 4.00 3.71 4.60 4.50 3.00 3.00 3.33 <= .05 in the full regression model. Place the results in J339. SUMMARY OUTPUT Regression Statistics Multiple R 0.923409 R Square 0.852684 Adjusted R Square 0.847423 Standard Error 0.198862 Observations 117 ANOVA df SS MS F Significance F Regression 4 25.636 6.409122 162.0677 0.000000
Image of page 86
Residual 112 4.4291 0.039546 Total 116 30.066 Coefficients ndard Er t Stat P-value Lower 95% Upper 95%Lower 95.0% Intercept 0.250174 0.145 1.725544 0.08719 -0.037090673 0.537439 -0.037091 org 0.45391 0.0457 9.941688 0.00000 0.363445791 0.544374 0.363446 prwc 0.158543 0.0404 3.922562 0.00015 0.078459615 0.238627 0.07846 icimo 0.184157 0.0301 6.119192 0.00000 0.124527927 0.243787 0.124528 su 0.179117 0.036 4.969972 0.00000 0.107708595 0.250525 0.107709
Image of page 87
Image of page 88
Image of page 89
Image of page 90
Image of page 91
Image of page 92
tr cptw itl 6.00 4.75 4.80 5.00 3.75 3.70 5.00 SUMMARY OUTPUT 3.50 3.50 3.25 3.75 3.20 4.00 Regression Statistics Using the Data Analysis Regression tool compute a multi After the analysis is complete go to cell B337 for further
Image of page 93
3.75 3.80 4.00 Multiple R 0.9307445153 3.25 4.00 4.75 R Square 0.8662853528 4.00 4.40 3.00 Adjusted R Squar 0.8448910092 4.00 3.40 4.75 Standard Error 0.2005047631 3.00 4.20 5.00 Observations 117 3.00 3.90 5.00 3.25 3.80 4.75 ANOVA 3.75 4.20 4.50 df SS 2.75 3.90 4.00 Regression 16 26.045420664 3.50 4.00 4.50 Residual 100 4.020216001 2.33 3.38 4.00 Total 116 30.0656366649 3.00 4.00 3.50 3.00 3.30 5.00 Coefficients Standard Error 4.50 3.50 5.00 Intercept 0.1742 0.2618 3.25 3.40 4.00 org 0.4921 0.0608 3.00 3.60 4.00 ini 0.0040 0.0395 3.25 3.50 4.00 indi -0.0872 0.0492 3.50 3.70 5.00 inf 0.0271 0.0333 3.00 4.00 5.00 prwe 0.0455 0.0463 3.00 4.30 5.00 preq -0.0155 0.0395 1.25 3.00 3.00 prwd 0.0520 0.0459 3.00 2.60 2.75 prwc 0.1868 0.0589 4.00 4.30 5.00 prwco -0.0248 0.0359 3.75 4.20 5.00 icad -0.0017 0.0463 3.25 4.00 4.75 icim 0.0259 0.0557 3.50 3.70 4.75 icimo 0.1702 0.0334 3.25 2.60 4.25 icpa 0.0027 0.0260 4.50 4.60 5.00 icpy -0.0376 0.0299 2.50 3.30 3.50 su 0.1893 0.0433 4.25 4.60 5.00 tr -0.0412 0.0350 3.25 4.10 5.00 3.00 3.00 4.00 GO TO CELL B337 1.50 3.00 3.75 2.50 4.40 5.00 2.00 3.90 3.50 3.25 2.70 3.50 3.67 4.30 4.25 2.75 3.50 3.50 3.00 3.50 4.25 3.75 4.30 5.00 4.00 3.80 4.00 3.50 3.60 5.00 3.00 3.60 5.00 3.75 3.80 3.50 3.75 3.90 3.50 3.75 4.30 4.50 3.50 4.30 5.00 3.50 4.00 4.50 3.75 3.70 4.00 3.00 3.50 5.00
Image of page 94
3.75 3.80 3.50 4.00 4.30 5.00 4.25 3.60 4.50 4.00 4.10 4.75 1.75 4.20 5.00 3.00 3.90 4.50 3.00 3.70 4.00 3.25 3.00 3.75 2.00 3.50 5.00 2.50 3.20 3.75 3.00 3.90 5.00 2.75 2.90 5.00 2.75 3.60 4.75 3.50 3.70 4.75 2.50 3.50 4.50 4.00 4.30 5.00 2.50 4.00 4.75 3.75 4.11 5.00 3.25 4.30 5.00 2.25 2.10 2.50 3.75 4.20 4.50 4.00 3.60 5.00 3.25 3.00 3.50 4.25 3.50 5.00 2.75 3.50 2.75 3.00 3.60 3.25 4.00 4.10 5.00 1.25 3.40 5.00 2.50 4.20 5.00 3.50 3.50 4.00 2.75 3.60 3.50 3.00 3.60 5.00 3.25 3.50 4.50 3.75 4.10 5.00 4.00 2.90 4.50 3.75 3.00 4.50 3.75 4.20 5.00 2.75 4.30 3.50 3.25 4.20 3.50 3.25 3.90 4.75 3.00 3.70 4.00 3.25 4.86 5.00 2.50 2.89 1.25 3.50 4.50 5.00 3.00 3.60 4.25 4.00 3.70 5.00 3.25 4.00 4.75 2.75 3.80 4.50 4.00 4.20 5.00 3.00 2.70 3.25
Image of page 95
4.25 2.90 4.25 3.75 3.50 5.00 4.00 3.78 4.00 3.00 3.90 4.50 3.50 4.75 5.00 3.50 3.90 5.00 2.75 3.70 5.00 3.75 3.20 1.75 2.75 2.80 2.00 2.50 4.00 2.75 3.75 3.70 2.50 2.75 3.89 5.00 3.00 3.80 5.00
Image of page 96
Upper 95.0% 0.537439 0.544374 0.238627 0.243787 0.250525
Image of page 97
Image of page 98
Image of page 99
Image of page 100
Image of page 101
Image of page 102
tiple regression using all the variables org to tr to predict cptw . Place the results in V198. instructions.
Image of page 103
MS F Significance F 1.627839 40.4913266131 0.0000000000 0.040202 t Stat P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% 0.6655 0.5072 -0.3452 0.6936 -0.3452 0.6936 8.0952 0.0000 0.3715 0.6127 0.3715 0.6127 0.1020 0.9190 -0.0744 0.0825 -0.0744 0.0825 -1.7730 0.0793 -0.1847 0.0104 -0.1847 0.0104 0.8137 0.4177 -0.0389 0.0931 -0.0389 0.0931 0.9828 0.3281 -0.0464 0.1374 -0.0464 0.1374 -0.3911 0.6966 -0.0939 0.0630 -0.0939 0.0630 1.1310 0.2607 -0.0392 0.1431 -0.0392 0.1431 3.1710 0.0020 0.0699 0.3037 0.0699 0.3037 -0.6913 0.4910 -0.0961 0.0465 -0.0961 0.0465 -0.0368 0.9707 -0.0935 0.0901 -0.0935 0.0901 0.4643 0.6435 -0.0846 0.1363 -0.0846 0.1363 5.0946 0.0000 0.1039 0.2365 0.1039 0.2365 0.1042 0.9172 -0.0488 0.0543 -0.0488 0.0543 -1.2563 0.2119 -0.0969 0.0218 -0.0969 0.0218 4.3723 0.0000 0.1034 0.2751 0.1034 0.2751 -1.1778 0.2417 -0.1107 0.0282 -0.1107 0.0282
Image of page 104
Image of page 105
Image of page 121

You've reached the end of your free preview.

Want to read all 197 pages?

  • Fall '09
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture