options ls=78 ps=54; data one; infile 'wine.dat'; input state $ pop wine prod; pcwc=wine/pop; run; proc plot; plot wine*pop; proc glm; model wine=pop; title 'Regression of Wine Consumtion on Population'; proc reg; model wine=pop/influence; data nocal; set one; if state ^= 'CA'; run; proc glm; model wine=pop; title2 'California Removed From Data Set'; run; Plot of WINE*POP. Legend: A = 1 obs, B = 2 obs, etc. WINE | 140000 + | | | A | | 120000 + | | | | | 100000 + | | | | | 80000 + | | | | | 60000 + | A | | | | 40000 + | | A | A | A A | 20000 + A A | A A A | A | AC AAB B | A A A A | DEBAAAAAA A 0 + BA BAA | --+----------+----------+----------+----------+----------+----------+-- 0 5000 10000 15000 20000 25000 30000 POP Regression of Wine Consumtion on Population 3 13:38 Tuesday, October 5, 1993 General Linear Models Procedure Dependent Variable: WINE Sum of Mean Source DF Squares Square F Value Pr > F Model 1 15961616065 15961616065 204.74 0.0001 Error 49 3820060690 77960422 Corrected Total 50 19781676755 R-Square C.V. Root MSE WINE Mean 0.806889 77.04286 8829.520 11460.53 Source DF Type I SS Mean Square F Value Pr > F POP 1 15961616065 15961616065 204.74 0.0001 Source DF Type III SS Mean Square F Value Pr > F POP 1 15961616065 15961616065 204.74 0.0001 T for H0: Pr > |T| Std Error of Parameter Estimate Parameter=0 Estimate INTERCEPT -4995.650145 -2.96 0.0047 1688.5844568 POP 3.480883 14.31 0.0001 0.24326971 ---------------------------------------------------------------------------- Regression of Wine Consumtion on Population 4 13:38 Tuesday, October 5, 1993 Model: MODEL1 Dependent Variable: WINE Analysis of Variance Sum of Mean Source DF Squares Square F Value Prob>F Model 1 15961616065 15961616065 204.740 0.0001 Error 49 3820060689.9 77960422.242 C Total 50 19781676755 Root MSE 8829.51993 R-square 0.8069 Dep Mean 11460.52941 Adj R-sq 0.8029 C.V. 77.04286 Parameter Estimates Parameter Standard T for H0: Variable DF Estimate Error Parameter=0 Prob > |T| INTERCEP 1 -4995.650145 1688.5844568 -2.958 0.0047 POP 1 3.480883 0.24326971 14.309 0.0001 Regression of Wine Consumtion on Population 5 Hat Diag Cov INTERCEP POP Obs Residual Rstudent H Ratio Dffits Dfbetas Dfbetas 1 3656.5 0.4168 0.0292 1.0657 0.0723 0.0716 -0.0414 2 4773.8 0.5450 0.0300 1.0612 0.0959 0.0952 -0.0564 3 5093.0 0.5826 0.0329 1.0625 0.1075 0.1073 -0.0684 4 4431.7 0.5033 0.0205 1.0528 0.0729 0.0416 0.0155 5 4902.8 0.5599 0.0303 1.0608 0.0990 0.0983 -0.0588 6 4325.7 0.4914 0.0214 1.0542 0.0727 0.0652 -0.0210 7 -591.5 -0.0719 0.1494 1.2249 -0.0301 0.0111 -0.0281 8 5647.9 0.6443 0.0260 1.0516 0.1052 0.0314 0.0521 9 -20785.4 -2.5601 0.0586 0.8570 -0.6387 0.0844 -0.5210 10 -15696.3 -1.8670 0.0474 0.9508 -0.4165 0.0211 -0.3189 11 -6349.6 -0.7229 0.0201 1.0407 -0.1034 -0.0642 -0.0156 12 -7539.0 -0.8762 0.0550 1.0683 -0.2113 0.0230 -0.1695 13 -7993.1 -0.9198 0.0344 1.0422 -0.1736 -0.0184 -0.1139 14 -2931.9 -0.3323 0.0196 1.0581 -0.0470 -0.0341 -0.0005 15 -951.3 -0.1077 0.0198 1.0626 -0.0153 -0.0122 0.0015 16 -808.1 -0.0916 0.0223 1.0655 -0.0138 -0.0128 0.0048 17 -3935.5 -0.4465 0.0197 1.0543 -0.0633 -0.0434 -0.0042 18 3528.6 0.4027 0.0321 1.0694 0.0733 0.0731 -0.0457 19 3357.2 0.3831 0.0319 1.0699 0.0695 0.0693 -0.0431 20 1664.2 0.1892 0.0270 1.0695 0.0315 0.0309 -0.0165 21 -1054.8 -0.1197 0.0235 1.0666 -0.0186 -0.0176 0.0076 22 4536.3 0.5184 0.0323 1.0649 0.0947 0.0945 -0.0594 23 427.4 0.0484 0.0197 1.0629 0.0069 0.0053 -0.0004 24 6943.1 0.7964 0.0324 1.0491 0.1457 0.1453 -0.0915 25 -5348.5 -0.6081 0.0205 1.0477 -0.0879 -0.0507 -0.0181 26 -99.2018 -0.0113 0.0256 1.0695 -0.0018 -0.0018 0.0009 27 -5246.9 -0.5968 0.0215 1.0494 -0.0886 -0.0438 -0.0266 28 -1174.2 -0.1331 0.0210 1.0637 -0.0195 -0.0172 0.0050 29 -6339.2 -0.7221 0.0210 1.0417 -0.1059 -0.0560 -0.0276 30 -3699.9 -0.4278 0.0564 1.0960 -0.1046 0.0124 -0.0844 31 -4796.2 -0.5449 0.0204 1.0507 -0.0786 -0.0668 0.0153 32 -6942.6 -0.7911 0.0196 1.0358 -0.1119 -0.0808 -0.0016 33 -4757.4 -0.5403 0.0200 1.0505 -0.0771 -0.0629 0.0102 34 -2616.2 -0.2970 0.0230 1.0627 -0.0455 -0.0427 0.0174 35 -1915.5 -0.2174 0.0238 1.0654 -0.0340 -0.0323 0.0143 36 -3829.9 -0.4344 0.0196 1.0547 -0.0615 -0.0469 0.0028 37 -3431.3 -0.3894 0.0212 1.0579 -0.0572 -0.0509 0.0155 38 -23323.4 -3.0610 0.1281 0.8367 -1.1732 0.3993 -1.0797 39 3827.8 0.4368 0.0312 1.0672 0.0784 0.0781 -0.0478 40 3738.3 0.4263 0.0301 1.0664 0.0752 0.0746 -0.0444 41 3993.8 0.4563 0.0331 1.0685 0.0845 0.0843 -0.0540 42 2930.6 0.3324 0.0212 1.0598 0.0490 0.0437 -0.0135 43 2957.4 0.3366 0.0276 1.0667 0.0567 0.0558 -0.0306 44 2624.4 0.2976 0.0212 1.0608 0.0438 0.0390 -0.0120 45 684.5 0.0778 0.0267 1.0705 0.0129 0.0126 -0.0067 46 6931.1 0.7942 0.0303 1.0470 0.1405 0.1396 -0.0836 47 6227.4 0.7087 0.0197 1.0411 0.1004 0.0770 -0.0053 48 4748.8 0.5401 0.0227 1.0535 0.0824 0.0768 -0.0305 49 41181.3 11.5410 0.3961 0.1211 9.3462 -4.6834 9.1119 50 4857.3 0.5555 0.0330 1.0639 0.1026 0.1024 -0.0653 51 4166.0 0.4752 0.0298 1.0641 0.0833 0.0826 -0.0487 Regression of Wine Consumtion on Population 8 California Removed From Data Set 13:38 Tuesday, October 5, 1993 General Linear Models Procedure Dependent Variable: WINE Sum of Mean Source DF Squares Square F Value Pr > F Model 1 4398595735 4398595735 208.64 0.0001 Error 48 1011967561 21082658 Corrected Total 49 5410563296 R-Square C.V. Root MSE WINE Mean 0.812964 50.53161 4591.586 9086.560 Source DF Type I SS Mean Square F Value Pr > F POP 1 4398595735 4398595735 208.64 0.0001 Source DF Type III SS Mean Square F Value Pr > F POP 1 4398595735 4398595735 208.64 0.0001 T for H0: Pr > |T| Std Error of Parameter Estimate Parameter=0 Estimate INTERCEPT -883.1131646 -0.93 0.3561 947.65747000 POP 2.3281662 14.44 0.0001 0.16118315