Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools

This video demonstrates how to conduct and interpret a multiple linear regression (multiple regression) using Microsoft Excel data analysis tools. Multiple regressions return the contribution of multiple predictor variables on one outcome variable. Predicted values for the outcome variable are calculated using the estimated regression equation.

[suryasurendran]

Dear Dr. Todd, the Statistics I learnt at School was about 40 years ago. At that time, I had no clue where it would prove useful in life. Nor did my Teachers have any clue either - they were merely tasked with holding Statistics Classes, grading us, and moving on to the next batch of Students!

I went through most of my working life without bothering about Multiple Factor Regression, until it suddenly took on possibilities of becoming significant! And now, I had no way to turn back to School!

Although I have used Excel constantly throughout my career - even the Data Analysis Pack, it does not come back too easily... Your Video makes it so easy, not just to do a Multiple Factor Regression Analysis, but to understand the important components of the Table that Excel spews out at you!

All Power to you Sir! Thanks!!

[ms.bunnies]

YOU ARE MY HERO 😭😭😭My doctor asked for us to make a regression analysis with out explaining what we are supposed to do or how to analyze it even but your video literally saved me

I will update you if i hopefully get the full mark !! fingers crossed !!

[hannahl.]

My mom watches your more recent psychological analyses, I watch the stat explanation videos :D You've got two fans in the family Dr. Grande!

[HamletNOR]

Best intro-video to multiple regression I've ever seen. Well done Dr.!

[nathanwhitten]

You did a very good job. I am a retired math teacher(community college). Until this last week I had no idea of how versatile Excel has become. So, I wanted to see if I could learn how to do multiple regression for purposes of studying Major League Baseball. I had absolutely no idea how to go about using Excel. I followed your video. Bingo! Thank you very much. I wish I could have used this when teaching stat. We just did linear regression(1 independent variable) using TI-84's. The students were required to buy those and were not required to have access to Excel. If I was still teaching, that would change!!

[danielmoss]

I started off watching your commentary on current events and stuff and now im over here learning statistics from you for my business economics class. Thanks man! I really appreciate your content!

[AlexJoneses]

Thank you so much for an intuitive tutorial in this way of data analysis, I really like how you don't skip over small and important things and make an effort to try to be as helpful as possible, I hold a lot of respect for you in that.

[chengmingli]

mr. todd grande tyvm for helping me out in my times of need! my teacher did not teach me this yet they dared to put it in my weekly homework to try and get me. but they will not thanks to you mr. todd grande. i hold u in high esteem and extraordinary regard

[oldbeean]

I was looking for clarification on how to apply the coefficients in a multiple regression to predict an outcome and you explained it perfectly, thank you.

[randomtopicsfromcomputersc]

Thanks Dr. Todd for an excellent demonstration.

[meia_noite]

Thank you so much for this video. Just what I needed. Very easy to understand multiple regression!

[ShannonJacksonSNJ]

Hi, I wanted to say thank you for this video! I'm taking a stats class right now and the book wasn't great at explaining how to run a regression analysis. This was extremely helpful! Much appreciated!!

[marcdipaolo]

This is an excellent, easy-to-follow video. It was such a help to me!

[WobblycogsUk]

Now that is what I call a clear and well presented video, many thanks.

[flashgordo]

Thank you, sir, appreciate your help in explaining how to turn this feature on in excel, as well as explaining how to use the results.

[ShahrukhKhan-jyly]

outstanding demonstration, I was searching for such stuff for long

[kressckerl]

Thank you so much for explaining what R^2 is, it just clicked for me :D

[marlandm]

Excellent explanations....very well laid out. Thanks

[bobbydacanay]

very comprehensive. Thank you dr Grande

[SudiptaDebroy]

Thank you so much, Dr. Todd, for such a lucid demonstration.