Linear Regression in Excel

This video shows you how run a multivariate linear regression in Excel. It also explains some common mistakes people make that results in Excel being unable to perform the regression. It also shows how to enable the Data Analysis Toolpak, although the screen capture software glitched a bit when I recorded this, so I recommend you watch the video entitled "Enabling the Data Analysis Toolpak". Author: David Switzer

[TheRustyMooseForLife]

I didn't know Matthew Broderick made YouTube tutorials?! Fantastic explanation by the way. Probably the best I've ever seen. Ferris Bueller's voice really eases me through the process, too.

[dorianmodify]

Thank you SO VERY much for this extremely helpful video. You speak slowly, clearly, and go step by step, (unlike SO many others). This was THE best video on the subject I ever found. I would PAY for any more tutorials from you. Great job sir, you have a serious talent at teaching.

[leemallon]

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.

[danonnathaniel]

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

[welcome]

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"

[icangetyoursnap]

i am not gonna miss stats but i can appreciate the grind and journey it was

[johnhughes]

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

[TheWowwa]

This is the best OLS (Excel) tutorial ever on Youtube! Thank you!

[camieljohnson]

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

[brittanywells]

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!!!

[tvenkatraman]

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

[ekkiwurm]

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

[jasonsmithwick]

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

[sumankaur]

Please explain the components which are formed with regression answer

[KALIGAD]

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!

[sao_rav]

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

[cindyramphal]

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

[itodohaugustine]

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

[winemansion]

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.

[mepowell]

He is a Professor of Economics in Minnesota, USA.