Creating a dummy variable for regression
If you found this useful, look for my ebook on Amazon, Straightforward Statistics using Excel and Tableau.
Mutliple regression with a dummy variable as an independent variable. Uses Excel. Converts a categorical variables into a dummy coded [0,1] using Excel's =if() tool. Interpretation of estimated regression equation
Пікірлер: 49
you saved my grade! My professor needs to learn from you
Thank you Stephen, that was a great videos: it had exactly the procedure and interpretation I was looking for.
Incredibly helpful - thank you for this video!
hi! i need to know why you dont use the error in the ecuation ?
Thank you, was stumped on an assignment. Very helpful
Thank you SOOOOOO MUCH!!!! This is really helpful!
Great presentation of the concept for 2 categorical values.. Could you consider doing one for 3 variables using 2 columns for dummy code? Thanks!
Thank you for simplifying this. much better than my professor
Awesome video! Thanks for posting
saved my life, thank you!
thank you so much! I was looking at how I can recode the martial status in my data that's written as dummies M, U, S into summary number variables. Whatever you did in excel worked in R
Thank youuu for a clear explanation
Thank you so so so much. God bless you Sir!
Very well explained and understandable
so far the best video I have come across, simple and clear! Than you & please post more about hypothesis analysis and normal distribution and sampling
Great job very useful guy
Thank you! It helps a lot
you're a life saver
Thank you so much, God bless you!
Brilliant video.
best video out there. kudos!
Great stuff thanks a bunch!
Why is it you didn't round up your numbers in the final function?
Thank you, this is good explain.
You save me and thank you for lecture god bless you
very helpful thank you very much
Excellent. Thanks a lot.
What if you need 2 dummy variables????
really appreciate this
Thank you so much !
Perfect video.
Great! Thank you
I wish you happiness!
Thanks a lot!
Thanks for this excellent video. What should one do if one of the independent variables is gender that has a finite range of multiple values, such as man, woman, non-binary, prefer not to say?
@evanjohnson8418
2 жыл бұрын
I'd imagine you would just divide it into 4 columns and give 1s and 0s. For example, if the person is a man, put a 1 in the man column, and a zero in the other 3.
Thank you!
Thank you 😊😊😊
how do we get the data for risk?
thank you sir
I did everything as follows but got 0 for my coefficents, Standard error, everything for 1 variable. Does anyone know why?
thank you so much~~~
You are the best
Gracias!
not sure why mine keeps saying 0 instead of 1 when I hit enter?... help please?!
@marisacurrie7800
6 жыл бұрын
check to make sure your =if( ) statement/function is correct
nice education.
Good
Thank you sir