[R] Help please

Sun Jun 25 09:22:54 CEST 2017

Hi Rabby,
It looks to me as though your variable Final$Cor is being treated as a
factor rather than a numeric value. This may be due to one or more
non-numeric values occurring in the data that is read in. Also you do
not have to use the Final$* notation in the formula as you have
specified the data frame "Final".

Jim

On Sun, Jun 25, 2017 at 2:17 AM, Sarpong, Rabby <es927716 at ohio.edu> wrote:
> Hello,
>
>
> I need some help on a regression I am running please. I am running a multiple regression in R and I am getting weird outputs and would like your help in resolving it.
>
> This is the code I run:
>
>
> Reg = lm (Final$Y.t.-Final$Y.t.1.  ~ Final$ Y.t.1. + Final$Cor + Final$Gov+ Final$Inv+ Final$TrOp + Final$Pop+ Final$Sch  , data = Final)
> summary(Reg)
>
>
> And the output I get is pasted below. As shown, highlighted variable is regressed more than once which should not be the case and I am not sure why that is the case. I have checked my data and nothing seems out of the ordinary. What could be wrong please?
>
>
> PS. I am still learning to use R.
>
>
> Thank you,
>
> Rabby
>
>
>
> Residuals:
>      Min       1Q   Median       3Q      Max
> -1.04279 -0.06739  0.00124  0.06376  1.59115
>
> Coefficients:
>                Estimate Std. Error t value Pr(>|t|)
> (Intercept)   0.1045711  0.0867584   1.205 0.228308
> Final$Y.t.1. -0.0313686  0.0058536  -5.359 9.95e-08 ***
> Final$Cor10   0.0009784  0.1622916   0.006 0.995191
> Final$Cor11   0.1230775  0.1165864   1.056 0.291318
> Final$Cor12   0.1615939  0.1086529   1.487 0.137199
> Final$Cor13   0.1934974  0.1160577   1.667 0.095713 .
> Final$Cor14   0.2341660  0.1286909   1.820 0.069057 .
> Final$Cor15   0.0744373  0.1036776   0.718 0.472909
> Final$Cor16   0.1964904  0.0932540   2.107 0.035311 *
> Final$Cor17   0.1989502  0.0908614   2.190 0.028736 *
> Final$Cor18   0.1993614  0.0886491   2.249 0.024692 *
> Final$Cor19   0.2062234  0.0878018   2.349 0.018991 *
> Final$Cor20   0.1889846  0.0868192   2.177 0.029683 *
> Final$Cor21   0.1717589  0.0855883   2.007 0.044984 *
> Final$Cor22   0.1453460  0.0856982   1.696 0.090129 .
> Final$Cor23   0.1976086  0.0871142   2.268 0.023474 *
> Final$Cor24   0.1471384  0.0859318   1.712 0.087093 .
> Final$Cor25   0.1447194  0.0851309   1.700 0.089384 .
> Final$Cor26   0.1553640  0.0855425   1.816 0.069574 .
> Final$Cor27   0.1220044  0.0854661   1.428 0.153678
> Final$Cor28   0.1406044  0.0854213   1.646 0.100011
> Final$Cor29   0.1594371  0.0860525   1.853 0.064146 .
> Final$Cor30   0.1792005  0.0863734   2.075 0.038215 *
> Final$Cor31   0.1376306  0.0871176   1.580 0.114398
> Final$Cor32   0.1521694  0.0865125   1.759 0.078832 .
> Final$Cor33   0.1535856  0.0863890   1.778 0.075671 .
> Final$Cor34   0.1327356  0.0865482   1.534 0.125364
> Final$Cor35   0.1501163  0.0864312   1.737 0.082661 .
> Final$Cor36   0.1114404  0.0866389   1.286 0.198587
> Final$Cor37   0.1326494  0.0873405   1.519 0.129073
> Final$Cor38   0.0993100  0.0869474   1.142 0.253594
> Final$Cor39   0.1346916  0.0885424   1.521 0.128458
> Final$Cor4    0.0306186  0.1625561   0.188 0.850627
> Final$Cor40   0.1596858  0.0906725   1.761 0.078459 .
> Final$Cor41   0.1330054  0.0881280   1.509 0.131491
> Final$Cor42   0.1355948  0.0911754   1.487 0.137216
> Final$Cor43   0.1106947  0.0921995   1.201 0.230132
> Final$Cor44   0.1525535  0.0923625   1.652 0.098848 .
> Final$Cor45   0.0885523  0.0918222   0.964 0.335036
> Final$Cor46   0.1594086  0.0911042   1.750 0.080406 .
> Final$Cor47   0.1874162  0.0909010   2.062 0.039435 *
> Final$Cor48   0.1746566  0.0901044   1.938 0.052800 .
> Final$Cor49   0.1248750  0.0915038   1.365 0.172592
> Final$Cor50   0.1270500  0.0900791   1.410 0.158660
> Final$Cor51   0.0798476  0.0906523   0.881 0.378587
> Final$Cor52   0.0697894  0.0918425   0.760 0.447468
> Final$Cor53   0.1632391  0.0930509   1.754 0.079622 .
> Final$Cor54   0.1143655  0.0933946   1.225 0.220977
> Final$Cor55   0.0991357  0.0928684   1.067 0.285957
> Final$Cor56   0.1191313  0.0975565   1.221 0.222257
> Final$Cor57   0.1288024  0.0939890   1.370 0.170807
> Final$Cor58   0.1249315  0.0951040   1.314 0.189209
> Final$Cor59   0.2100375  0.1020216   2.059 0.039723 *
> Final$Cor60   0.1303076  0.0944493   1.380 0.167937
> Final$Cor61   0.0928124  0.1056764   0.878 0.379964
> Final$Cor62   0.0767684  0.1296343   0.592 0.553828
> Final$Cor63   0.1133221  0.1174685   0.965 0.334879
> Final$Cor64   0.1412303  0.0978915   1.443 0.149347
> Final$Cor65   0.1382271  0.1098535   1.258 0.208522
> Final$Cor66   0.0982404  0.1057428   0.929 0.353041
> Final$Cor67   0.1893438  0.1022572   1.852 0.064311 .
> Final$Cor68   0.1578940  0.1634072   0.966 0.334099
> Final$Cor69   0.2166677  0.1021570   2.121 0.034123 *
> Final$Cor70   0.1143033  0.1054570   1.084 0.278623
> Final$Cor71   0.1469311  0.1637571   0.897 0.369757
> Final$Cor72   0.2268878  0.1103408   2.056 0.039964 *
> Final$Cor73   0.1925218  0.1055544   1.824 0.068402 .
> Final$Cor74   0.1574432  0.1020634   1.543 0.123178
> Final$Cor75   0.0571227  0.1166594   0.490 0.624464
> Final$Cor76   0.1096049  0.1634571   0.671 0.502635
> Final$Cor78   0.0949307  0.1305748   0.727 0.467347
> Final$Cor8    0.1082102  0.1289245   0.839 0.401443
> Final$Gov    -0.0016397  0.0008084  -2.028 0.042736 *
> Final$Inv     0.0016819  0.0004667   3.604 0.000326 ***
> Final$TrOp    0.0002904  0.0001209   2.402 0.016445 *
> Final$Pop    -0.0130554  0.0038839  -3.361 0.000799 ***
> Final$Sch     0.0005785  0.0002696   2.146 0.032064 *
> ---
>
>
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.