I didn't know Matthew Broderick made RU-vid tutorials?! Fantastic explanation by the way. Probably the best I've ever seen. Ferris Bueller's voice really eases me through the process, too.
PLS BRO, CAN U SEND ME THE VIDEO TO MY EMAIL? I REALLY NEED TO LEARN HW TO RUN REGRESSION ANALYSIS WITH EXCEL BUT MY PHONE CANT DOWNLOAD THIS VIDEO . THANS. MY EMAIL IS bartholomewdesmond@gmail.com
Good job! I really do not know what is your job, but I hope you teach statistics at a university or something! In 7 minutes you can explain really valuable things!
PLS BRO, CAN U SEND ME THE VIDEO TO MY EMAIL? I REALLY NEED TO LEARN HW TO RUN REGRESSION ANALYSIS WITH EXCEL BUT MY PHONE CANT DOWNLOAD THIS VIDEO . THANS. MY EMAIL IS bartholomewdesmond@gmail.com
Hi Dude, you're really good. I'd been trying to do this for almost an hour and got so frustrated, until I saw your video, boom I did it. I got real frustrated with 2010 version, it's not as user friendly as 2007 version.
Thanks for this. One correction: towards the end when it displays an error message "non numeric data" it did so not because you deleted data but because you still did not check the box next to "Labels"
Hi, I have ROA and ROE as my y independent variable and Gender diversity and board meeting frequency as my x1 and x2.. is it possible to fit everything together or separate the y-s into 2 different regression analysis? Thank you very much Reply
I'm a little confused by your words here, since "independent variable" is usually referred to as "x1" and "x2", while the dependent variable (the thing you're trying to predict) is your y variable in Excel. If you have two different dependent variables, you'd need two regressions. Just put the first y in the first column (A), the two x's in columns B and C, and the second y in the fourth column (D). Then you regress column A on B and C, then column D on B and C.
PLS BRO, CAN U SEND ME THE VIDEO TO MY EMAIL? I REALLY NEED TO LEARN HW TO RUN REGRESSION ANALYSIS WITH EXCEL BUT MY PHONE CANT DOWNLOAD THIS VIDEO . THANS. MY EMAIL IS bartholomewdesmond@gmail.com
For regression in Excel, don't use the Data Analysis Toolpak. It was a bad piece of work when it was introduced in 1995 and it has not been updated at all since then. See this web page for details: regressit.com/analysis-toolpak-problems.html. For a much more powerful and easy-to-use Excel add-in for regression analysis, try RegressIt (regressit.com). It takes full advantage of the dimensionality and interactivity of the Excel environment and it has many innovative features to support both teaching and practice, including built-in teaching notes on regression. See this blog post for details: www.datasciencecentral.com/profiles/blogs/linear-and-logistic-regression-in-excel-and-r-try-this-free-add. There is a also a separate version of RegressIt that performs logistic regression in Excel, with interactive table and chart output. All versions of RegressIt also include a menu interface for generating R code for linear and logistic regression. With it, you can use Excel as a menu-driven front end for performing regression analysis in R, which opens up more options such as stepwise regression, out-of-sample testing, and the ability to handle larger data sets than will fit in Excel. This tool produces output in both R and Excel and can be used without any knowledge of R programming.