# 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.

442 – 1471983475 – 68196

data analysis tools

## 43 thoughts on “Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools”

1. oscar giraldo says:

thank you

2. Joseph Davis says:

Thanks!

3. ronnie serfa juan says:

thank you Dr. Todd

4. Ashish Pandey says:

Super helpful, this is what I was looking for, thanks a lot 🙂

5. Kaelin Thibodeau says:

Thank you for this video. I spent hours trying to figure it out and got it in about 5 seconds after watching this video. 🙂

6. Alticroo says:

Thank you very much for this explanation.

7. Sudipta Debroy says:

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

8. KishoreK B says:

Thanks Dr. Todd for an excellent demonstration.

thanks

10. Mina Zakaria Fakhry says:

Thanks Dr. Todd

11. Coşkun FIRAT says:

Dr Grande, thanks for this video. I have another question: what if we have still 2 inputs but 2 outputs related to 2 inputs? how can we solve such a problem? Also would the results for 2 inputs 1 output model, Standard Error: 101,4823922
, and Significance F
: 0,038824662 be acceptable as a good regression or not? thank you.

12. jiffy crimso says:

Thanks Todd!

13. Rhythm Agarwal says:

Thankyou Dr. Grande! your solution was very thorough and you made it effortless for us to learn it.
One question: does there exist any professional regression tool to predict outcomes with more accuracy? what if the outcome variable is time dependent and result is delayed but not know which factors affect the ? how do we account for that?

14. Shaheer Malik says:

Can anyone help me with multiple regression. I followed your steps but it shows an error and I can't get the results

15. Bijan Rosen says:

Is there a reason you didn't use parenthesis when plugging values into your formula?

16. Nathan Whitten says:

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

17. Kresten Sckerl says:

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

18. Marland Mc says:

Excellent explanations….very well laid out. Thanks

19. manar shraideh says:

nicely explained

20. Sai lakshmi says:

Iam getting #NUM in significance and p value…what should i do??

21. eric.ingram says:

This was excellent! Thank you!

22. Grant Estep says:

Nicely done & many thanks.

23. kiran kumar Reddy says:

dear sir.. pl. also tell how to generate an eq. Y=m1x1+m2x2+m3x3… mnxn using the obtained result.

24. Stephen Troup says:

Dr. Grande, thank you. I need to perform a data analysis to predict costs, similar to this model with multiple known Xs (Up to possibly 10) and multiple known Ys. I have conducted models using the LINEST function and the Data Regression Analysis shown here. My problem is some of the Coefficients are coming up negative, which for this purpose is impossible, since all the X variables add to cost. I'm trying to figure out a work-around solution or a new regression model and I am hitting the limits of my brain power…can you or anyone here help me? Thank you.

God bless you

26. Surendran N says:

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

Very useful, thank you so much!

28. Ethan L says:

What's the difference between a Generalized Linear Model and a Multiple Regression?

29. Tan Le says:

Thank you Sir. for a clear explanation and great useful work!

30. Robert Ruff says:

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.

31. Jackson Reid says:

Amazing, thanks.

32. Jimmy says:

33. Bryce McCormick says:

ctrl+shift+down on the arrow keys selects all data after a cell you want if anyone wants to know that shortcut

34. miscellaneous says:

Very well explained. It was extremely helpful for me. Thanks a lot!

35. Hamizan Sam says:

how to know the multiple equation for the regression?

this is very useful! thanks! can you also make a video how to interpret different terms and coefficients please?

37. Katha Hirpara says:

I found it extremely useful! Great explanation Dr. Todd!! Thank you so much!!!

38. ChengMing Li says:

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

39. Syu-Ruei Jhang says:

40. Shannon Jackson says:

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

41. John says:

Very clear video, will share this with my professor as a resource to help those concerned students who ask for help via email.

42. MKlahn says:

Thank you very much for this walkthrough, most appreciated.

43. Claudia RP says:

Excellent explanation. Thank you.