Help please
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.
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.