estimation regression

please help i can't get the estimation regression equation right on studio always i get that Error: unexpected symbol in "model.frame(fdi~trade openness"

Hi @amarta and welcome the RStudio Community :partying_face: :partying_face: :partying_face: :partying_face:

I'd like to give you a quick tip. Whenever you ask a question on this forum (and on any forum really), it is important that you provide all the necessary information for people to help you. In your case, you tried to estimate a linear regression. So, helpful information to provide would be:

  • the relevant code and...
  • your data or any data that would help run your code

This is usually referred to as a reproducible example. You may want to consult this great article to learn more about it: FAQ: How to do a minimal reproducible example ( reprex ) for beginners

Now, about your question, even though we have limited information, it seems that the source of your problem is: trade openness. R variable do not usually have spaces in them (even though it's possible). So what is exactly the name of that variable? It may be trade_openness or trade.openness or something like that!

Thank you I think that what is happening
on my file i have trade openness with space,
thank

Then you should rename the variable.

These are my variables
(Fdi =dependent variable) trade openness, corruption, government effectiveness and political effectiveness =independent

excel_file <- read_excel("Desktop/excel file.xls")

View(excel_file)
library(readxl)
excel_file <- read_excel("Desktop/excel file.xls",

  • col_types = c("text", "blank", "numeric", 
    
  •     "numeric", "numeric", "numeric", 
    
  •     "numeric", "numeric", "numeric", 
    
  •     "numeric", "numeric"))
    

Dear Gueyenono

please help this what i am getting all the time

model=lm(fdi~trade_openness+governance_effectiveness+politicl_stability+corruption+GDP_total+GDP_per_capita+population_total,data=excel_file)
Error in eval(predvars, data, env) : object 'fdi' not found

@amarta Once you import your dataset, run the following code:

dput(excel_file)

then copy and paste the output here.

your help is very much apreciated

 dput(excel_file)

structure(list(FDI = c(-3.23, -3.02, -1.46, -7.12, 3.66, 10.03, 
-0.18, -7.4, -6.46, -4.1, 0.12, 0.1, 0.13, 0.09, 0.18, 0.1, 0.13, 
0.11, 0.11, 0.11, 2.73, 1.98, 0.99, 0.58, 0.17, 0.23, 0.05, 0.3, 
0.4, 0.45, 0.03, 0.03, 0.01, 0.02, 0.03, 0.02, 0.01, 0.02, 0.02, 
0.03, 1.26, 3.66, 5.64, 6.7, 5, 3.87, 3.13, 2.32, 2.68, 2.18, 
0.05, 0.03, 0.02, 0.01, 0.03, 0.03, 0.02, 0.03, 0.02, 0.03), 
    Trade_openness = c(104.12, 99.98, 91.8, 86.81, 79.33, 62.89, 
    53.37, 52.26, 66.38, 0, 94.44, 99.85, 100.28, 95.34, 101.05, 
    104.07, 104.19, 113.3, 117.27, 116.21, 144.67, 114.38, 116.68, 
    106.89, 104.38, 98.88, 92.6, 102.43, 104.51, 107.38, 50.13, 
    56.62, 41.17, 44.08, 51.59, 59.78, 57.81, 60.85, 57.79, 57.01, 
    70.79, 80.23, 101.87, 103.15, 111.47, 93.91, 105.64, 99.72, 
    131.99, 112.15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), Government_effectiveness = c(-1.12, 
    -1.15, -0.99, -1.22, -1.12, -1, -1.04, -1.03, -1.05, -1.12, 
    -0.02, 0.15, 0.12, 0.1, 0.07, 0.17, 0.13, 0.17, 0.32, 0.29, 
    -1.68, -1.63, -1.61, -1.54, -1.5, -1.42, -1.41, -1.44, -1.29, 
    -1.34, -1.03, -1.03, -1.23, -1.43, -1.58, -1.61, -1.64, -1.77, 
    -1.49, -1.51, -0.58, -0.64, -0.63, -0.61, -0.72, -0.75, -0.86, 
    -0.89, -0.87, -0.82, -0.79, -0.7, -0.68, -0.73, -0.82, -0.75, 
    -0.67, -0.75, -0.64, -0.63), Political_stability = c(-0.23, 
    -0.37, -0.39, -0.39, -0.33, -0.5, -0.32, -0.33, -0.32, -0.31, 
    0.84, 0.72, 0.81, 0.78, 0.35, 0.87, 0.89, 0.77, 0.85, 0.88, 
    0.24, 0.15, 0.23, 0.12, -0.37, -0.21, -0.14, -0.17, -0.08, 
    -0.19, -0.69, -0.75, -0.97, -0.9, -0.71, -0.52, -0.44, -0.5, 
    -0.68, -0.56, 0.39, 0.33, 0.39, -0.23, -0.34, -0.51, -1.09, 
    -0.93, -0.81, -0.75, 0.12, 0.01, 0.01, 0.11, 0.18, 0.14, 
    0.22, 0.19, 0.53, 0.52), Corruption = c(19, 20, 22, 23, 19, 
    15, 18, 19, 19, 26, 51, 55, 60, 58, 57, 55, 59, 55, 57, 58, 
    19, 19, 20, 19, 19, 0, 0, 17, 16, 16, 0, 0, 25, 19, 19, 17, 
    16, 17, 16, 18, 27, 27, 31, 30, 31, 31, 27, 25, 23, 26, 30, 
    30, 42, 42, 42, 42, 46, 46, 46, 46), Economic_freedom = c(48, 
    46, 47, 47, 48, 48, 49, 49, 49, 51, 62, 65, 64, 64, 66, 66, 
    67, 57, 60, 63, 49, 48, 43, 42, 44, 40, 44, 45, 42, 41, 44, 
    47, 50, 51, 51, 52, 52, 56, 57, 54, 56, 57, 57, 55, 55, 55, 
    53, 50, 46, 49, 49, 50, 50, 48, 49, 53, 57, 55, 54, 54), 
    GDP_total = c(83.8, 111.79, 128.05, 136.71, 145.71, 116.19, 
    101.12, 122.12, 101.35, 94.64, 1.66, 1.87, 1.74, 1.85, 1.86, 
    1.6, 1.66, 1.77, 1.97, 1.98, 16.31, 21.36, 22.39, 21.95, 
    21.77, 13.19, 11.24, 12.2, 13.28, 11.03, 0.85, 1.1, 0.99, 
    1.05, 1.05, 1.05, 1.18, 1.35, 1.46, 1.34, 11.09, 14.38, 16.35, 
    16.97, 17.72, 15.95, 11.94, 13.22, 14.72, 14.93, 0.2, 0.23, 
    0.25, 0.3, 0.35, 0.32, 0.35, 0.38, 0.42, 0.43), GDP_per_capita = c(3587.88, 
    4615.47, 5100.1, 5254.88, 5408.41, 4166.98, 3506.07, 4095.81, 
    3289.65, 2973.59, 3378.25, 3740.39, 3447.52, 3615.98, 3588.67, 
    3043.01, 3130.96, 3292.65, 3617.33, 3603.78, 17288.86, 21641.87, 
    21711.15, 20390.72, 19394.03, 11283.47, 9250.33, 9667.91, 
    10144.2, 8131.92, 557.63, 702.74, 616.41, 634.48, 622.48, 
    603.16, 661.01, 736.73, 777.97, 697.78, 471.18, 594.59, 657.65, 
    664.08, 673.97, 589.86, 428.93, 461.42, 498.96, 491.8, 1094.71, 
    1263.87, 1340.53, 1577.02, 1782.8, 1595.86, 1710.13, 1811.01, 
    2001.14, 1994.91), Population_total = c(23.36, 24.22, 25.11, 
    26.02, 26.94, 27.88, 28.84, 29.82, 30.81, 31.83, 0.49, 0.5, 
    0.51, 0.51, 0.52, 0.52, 0.53, 0.54, 0.54, 0.55, 0.94, 0.99, 
    1.03, 1.08, 1.12, 1.17, 1.22, 1.26, 1.31, 1.36, 1.52, 1.56, 
    1.6, 1.65, 1.69, 1.74, 1.78, 1.83, 1.87, 1.92, 23.53, 24.19, 
    24.86, 25.56, 26.29, 27.04, 27.83, 28.65, 29.5, 30.37, 0.18, 
    0.18, 0.19, 0.19, 0.2, 0.2, 0.2, 0.21, 0.21, 0.22)), row.names = c(NA, 
-60L), class = c("tbl_df", "tbl", "data.frame"))

Sorry is a very long observations

@amarta

Okay, I see where your problem comes from. You need to keep "case sensitivity" in mind. So, if your variable is Trade_openness, you should respect the fact that the first letter is a capital T. If you write trade_openness (with a lowercase t), you will get an error. In your code, you wrote fdi instead of FDI for example and you also made a few other typos. These kinds of mistakes are very frequent so be careful what you write :slight_smile:

The following code will work:

model <- lm(FDI ~ Trade_openness + Government_effectiveness + Political_stability + Corruption + GDP_total + GDP_per_capita + Population_total, data = excel_file)
summary(model)

Call:
lm(formula = FDI ~ Trade_openness + Government_effectiveness + 
    Political_stability + Corruption + GDP_total + GDP_per_capita + 
    Population_total, data = excel_file)

Residuals:
    Min      1Q  Median      3Q     Max 
-5.9142 -0.5985 -0.0902  0.4139 11.5099 

Coefficients:
                           Estimate Std. Error t value Pr(>|t|)    
(Intercept)               9.187e-01  2.753e+00   0.334 0.739996    
Trade_openness            4.982e-03  1.119e-02   0.445 0.658103    
Government_effectiveness  6.264e-01  1.573e+00   0.398 0.692123    
Political_stability       7.734e-02  1.322e+00   0.059 0.953562    
Corruption               -2.418e-02  4.693e-02  -0.515 0.608522    
GDP_total                -4.906e-02  1.265e-02  -3.879 0.000297 ***
GDP_per_capita            9.058e-05  1.107e-04   0.818 0.416986    
Population_total          1.305e-01  4.826e-02   2.704 0.009234 ** 
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 2.521 on 52 degrees of freedom
Multiple R-squared:  0.2812,	Adjusted R-squared:  0.1845 
F-statistic: 2.907 on 7 and 52 DF,  p-value: 0.01213

Dear Gueyenono

Thank you very much for your help,
mine did not come out as yours

Coefficients:
(Intercept) Trade_openness Government_effectiveness
-1.4164253 0.0018369 0.7860765
Political_stability Corruption Economic_freedom
-0.1272064 -0.0393625 0.0565633
GDP_total GDP_per_capita Population_total
-0.0489966 0.0001299 0.1329807

Would you please also share your code with me? Otherwise, I will not be able to tell you why our results are different.

Sorry, what is the code please can you specify

@amarta what code did you run that got you the results that you posted?

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.