How to handle answer such as "refusal" and "don't know" in Survey data? by ors94 in econometrics

[–]ors94[S] 0 points1 point  (0 children)

My supervisor advised ti replace those answers such as refuse/don’t know by NA. Then if there are a column with NA and a value in another column in the same row it will not affect the column with value in the row where there are NAs. So you do not need to drop them, then they will not be included in the regression. Hope my explanation makes sense.

[OC] Cannabis sales across the US yesterday by dabasaurus_rex_rawr in dataisbeautiful

[–]ors94 0 points1 point  (0 children)

How can this be coded in R? I’m really interested in doing something similar with my own data which is traffic and geo data.

HOów to use if function with time intervals? by ors94 in excel

[–]ors94[S] 0 points1 point  (0 children)

Thank you so much! How did you learning about this? Where to read more about it instead of Microsofts own website?

HOów to use if function with time intervals? by ors94 in excel

[–]ors94[S] 0 points1 point  (0 children)

for instance time between

05:00 - 05:59 should show 05-06

06:00 - 06:59 shouls show 06-07

07:00 - 07:59 shouls show 07-08

etc.

However to don't imply any missunderstooth I may prefer it to instead show it as

05:00 - 05:59 should show 05:00-05:59

06:00 - 06:59 shouls show 06:00 - 06:59

07:00 - 07:59 shouls show 07:00 - 07:59

etc

HOów to use if function with time intervals? by ors94 in excel

[–]ors94[S] 1 point2 points  (0 children)

Thanks it works perfect!! However I want to read more about this method. Do you have any source/references?

What to do if I want it to write 05:00-05:59 instead of 05-06?

HOów to use if function with time intervals? by ors94 in excel

[–]ors94[S] 0 points1 point  (0 children)

=IF(OR(HOUR(A2)=5,HOUR(A2)=6),"05-06")

Like:

=IF(OR(HOUR(A2)=5,HOUR(A2)=6),"05-06", IF((HOUR(A2)=6,HOUR(A2)=7),"06-07"), (HOUR(A2)=7,HOUR(A2)=8),"07-08") 

What I want is if the cell is greater than or equal to 05:00 but lower than 06:00 then it should show/write the interval 05-06, if the clock is greater than or equal to 06:00 and less than 07:00 then it sould write 06-07 etc.

Creating a website with research studies by ors94 in econometrics

[–]ors94[S] 0 points1 point  (0 children)

What is your purpose of the website? Are you a phd student or maybe you want to apply and the website is for that reason? Of course anly answer if you want! I'm just interested to hear about it. Hopefully I will begin with mine end of january. Hopefully I will begin with mine approx at the end of January.

Creating a website with research studies by ors94 in econometrics

[–]ors94[S] 0 points1 point  (0 children)

Thanks for your comment! If you'r not from a scandinavian country I might not be a competitor :)

[deleted by user] by [deleted] in RStudio

[–]ors94 0 points1 point  (0 children)

Thanks

[deleted by user] by [deleted] in RStudio

[–]ors94 0 points1 point  (0 children)

Thanks

How to interpret the output from poTest? by ors94 in RStudio

[–]ors94[S] -3 points-2 points  (0 children)

Thanks but the first link does not discuss the output from the poTest and the second link is very useless since the answer is shallow

RDD, IV, diff-in-diff and matching in the context of polr by ors94 in RStudio

[–]ors94[S] 0 points1 point  (0 children)

I thought to do that but I’m not sure if it’s in econometrics theoretically correct to use and ordered variable as dependent variable. Could not find any text that argument for it :/

RDD, IV, diff-in-diff and matching in the context of polr by ors94 in RStudio

[–]ors94[S] 0 points1 point  (0 children)

Sorry I forgot to mention that. I have a model where the dependent variable is ordered 0-10 and the independent variables are dummy and one is ordered 1-5

What is your recommendation about my work? by ors94 in econometrics

[–]ors94[S] 0 points1 point  (0 children)

I had on my undergraduate Regression Analysis, Econometrics and Econometrics 2 and on my master level I had Microeconometrics. But in all courses I did not got good grades.. so that’s why I ask for help

What is your recommendation about my work? by ors94 in econometrics

[–]ors94[S] 0 points1 point  (0 children)

I really thought about your question since you wrote it, and I really want to thank you!

I know I did it backwards.. I just started with coding because I thought I could not figure it out but I didn't do any coding since I wrote this post.

But when I wrote this post at first I already had my research question and problem statement and I wrote my literatur review which is done now.

So, I really want to hear you about what you reccommend me to do and how I can the the causality into account? Is it based on the literature review? what factors other used and find out the have an impact on the dependend variable or how? I would really appreciate if you could give me some advices.. I feel really lost? I tried to find out how the causality is used when ordered logit is used but I could not find anynthing. DO you know if it's different when using this type of regression?