On Sun, Jun 25, 2017 at 5:29 PM, Jim Lemon <drjimle...@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 <es927...@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 <drjimle...@gmail.com> >> Sent: Sunday, June 25, 2017 3:22:54 AM >> To: Sarpong, Rabby >> Cc: r-help@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 <es927...@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@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@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@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.
