Linear Regression in Excel 

I have an interview tomorrow and you have just saved my life! Your video is very clear! Many thanks :)

THANK YOU SO MUCH, my teacher never told me about the first minute of your video, could of save me so much time but oh well. You are a life saver.

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.

Thank you very much. I know you put effort into this because no-one can explain so elegantly first time around. Much appreciated.

This is the best OLS (Excel) tutorial ever on RU-vid! Thank you!

Great man. You point out the minute details. Great explanation.

Thank You.I can able to enable the "Data Analysis" option in my excel sheet only after seeing this video.Thanks a lot.

thank you soo much...i would of never knew how to do the regression if you did show how to get the data analysis tab on excel!!!

You make this so easy! Thank you!

thank you so much.. it took me long time to find out the data analysis function but I still could not find it. and you just told me here.

nicely done....easy and to the point...thanks for sharing

Great video! What a pity that there are only a few videos in this series.

u r the best bro.. would like to see many such videos from ur side. thanks

thxs you help me a lot for exams, great job

Excellent presentation; I would say the best I have ever seen. I wonder if you have others.

Thanks for making my life easier mate !

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!

Thank you for helping in my University assignments

Thanks, i forgot how to do that and you helped a lot.

Thank you. Just added Solver and Data analysis same time.

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 Bro, just what I was looking for

am really happy with this explanation.

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"

Super helpful video. Thanks!

You have made my life a lot easier with this tutorial.. Thanks a million. Do you have others?

Thank you, Sharp and Clear!

Helped very much, thanks!

Thank you for this excellent video.

Fantastic tutorial!

thanks buddy! great tutorial !

Thanks alot and you saved the day :) Awesome!!

lovely, thanks for the great help!

thank you very much! It is quite useful!

nice video. any chance to get the dataset to make some practise?

You don't need them in adjacent columns. First Highlight Column A, then hit control key then select second column and it works too.

Perfect explaination

appreciate it bud really helpful

Thank you very much!!! It's fantastic)))

Great Video...Thanks

He is a Professor of Economics in Minnesota, USA.

Many thanks God bless

realy thankful to you

Is there a way to do this in numbers on Mac? I do not have Excel

Please explain the components which are formed with regression answer

good job!

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

Can't find excel options under the window button :(

THANK YOU

you r great buddy, thanks a lotttt :))

Thank you!

Thanks a lot...

Thanks a lot!!!

You are amazing!! why dont you do more vids ?!?

thank you

Thaks!!!!

thanks mac

Wow... I feel kinda dumb for not noticing the "Labels" box... My professor didn't explain this very well. :/

guy sounds like hot office guy

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.

Thank you! My professor is a she thou..

Awesome Help! THANKS!