[R] Help please

Bert Gunter bgunter.4567 at gmail.com
Mon Jun 26 07:42:52 CEST 2017


On Sun, Jun 25, 2017 at 5:29 PM, Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi Rabby,
> Before you run your regression, try this:
>
> is.factor(Final$Cor)
>
> If this returns TRUE, then this variable is a factor and it will be
> treated as a number of levels rather than a set of numeric values.
> This usually happens when a text file is read in and there is at least
> one value that cannot be converted to numeric. So if you are doing
> something like this:
>
> Final<-read.csv("Final.csv")
>
> Try this:
>
> Final<-read.csv("Final.csv",stringsAsFactors=FALSE)
> Final$Cor<-as.numeric(Final$Cor)
>
> If there is at least one NA value in Final$Cor, that is probably what
> is causing your problem.

I don't think so. If Final$Cor is numeric to begin with, there should
be no problem with NA's. Commas or other stray characters might be the
problem, however. As always, consulting ?read.csv should be the first
stop.

The OP would probably benefit by spending some time with an R tutorial
or two(there are many good ones on teh web), I think, where such
issues are often discussed.

Cheers,
Bert


>
> Jim
>
> On Mon, Jun 26, 2017 at 9:38 AM, Sarpong, Rabby <es927716 at ohio.edu> wrote:
>> Hello Jim,
>>
>> Thanks for the response I really appreciate it. I have edited the data over
>> and over to correct that. But I am still getting the same results. Is that
>> the only way to resolve it please?
>>
>> -Rabby Sarpong
>>
>> ________________________________
>> From: Jim Lemon <drjimlemon at gmail.com>
>> Sent: Sunday, June 25, 2017 3:22:54 AM
>> To: Sarpong, Rabby
>> Cc: r-help at R-project.org
>> Subject: Re: [R] Help please
>>
>> 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.
>
> ______________________________________________
> 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.



More information about the R-help mailing list