Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools

  Рет қаралды 286,063

Dr. Todd Grande

Dr. Todd Grande

8 жыл бұрын

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.

Пікірлер: 74
@suryasurendran5383
@suryasurendran5383 5 жыл бұрын
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!!
@hannahl.5305
@hannahl.5305 7 ай бұрын
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!
@AlexJoneses
@AlexJoneses 4 жыл бұрын
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.
@ms.bunnies3685
@ms.bunnies3685 7 ай бұрын
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 !!
@randomtopicsfromcomputersc8549
@randomtopicsfromcomputersc8549 4 жыл бұрын
Thanks Dr. Todd for an excellent demonstration.
@oldbeean
@oldbeean 5 жыл бұрын
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.
@ShannonJacksonSNJ
@ShannonJacksonSNJ 6 жыл бұрын
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!!
@HamletNOR
@HamletNOR 7 ай бұрын
Best intro-video to multiple regression I've ever seen. Well done Dr.!
@danielmoss7021
@danielmoss7021 Жыл бұрын
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!
@SudiptaDebroy
@SudiptaDebroy 4 жыл бұрын
Thank you so much, Dr. Todd, for such a lucid demonstration.
@kathahirpara4707
@kathahirpara4707 5 жыл бұрын
I found it extremely useful! Great explanation Dr. Todd!! Thank you so much!!!
@eric.ingram
@eric.ingram 5 жыл бұрын
This was excellent! Thank you!
@WobblycogsUk
@WobblycogsUk 4 жыл бұрын
Now that is what I call a clear and well presented video, many thanks.
@chengmingli1593
@chengmingli1593 5 жыл бұрын
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
@marcdipaolo5142
@marcdipaolo5142 9 ай бұрын
This is an excellent, easy-to-follow video. It was such a help to me!
@flashgordo6475
@flashgordo6475 4 жыл бұрын
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-jy4ly
@ShahrukhKhan-jy4ly 4 жыл бұрын
outstanding demonstration, I was searching for such stuff for long
@marlandm
@marlandm 5 жыл бұрын
Excellent explanations....very well laid out. Thanks
@nathanwhitten8950
@nathanwhitten8950 5 жыл бұрын
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!!
@kressckerl
@kressckerl 5 жыл бұрын
Thank you so much for explaining what R^2 is, it just clicked for me :D
@bobbydacanay7048
@bobbydacanay7048 2 ай бұрын
very comprehensive. Thank you dr Grande
@NugeriDwiantoro
@NugeriDwiantoro 4 жыл бұрын
Thanks for the great explanation Dr. Todd!
@miscellaneous714
@miscellaneous714 5 жыл бұрын
Very well explained. It was extremely helpful for me. Thanks a lot!
@meia_noite
@meia_noite Жыл бұрын
Thank you so much for this video. Just what I needed. Very easy to understand multiple regression!
@duytanmr
@duytanmr 5 жыл бұрын
Thank you Sir. for a clear explanation and great useful work!
@musicalpandey
@musicalpandey 4 жыл бұрын
Super helpful, this is what I was looking for, thanks a lot :)
@Ericlau1126
@Ericlau1126 4 жыл бұрын
Thanks! Your explanation is sooooo clean!
@MKlahn
@MKlahn 6 жыл бұрын
Thank you very much for this walkthrough, most appreciated.
@DrGrande
@DrGrande 6 жыл бұрын
You're welcome!
@nickmwenda5183
@nickmwenda5183 4 жыл бұрын
This is awesome. Thank you.
@LinhNguyen-uf7ue
@LinhNguyen-uf7ue 4 жыл бұрын
Thank you so much for your explanation!
@Alticroo
@Alticroo 4 жыл бұрын
Thank you very much for this explanation.
@salvadordeleon9393
@salvadordeleon9393 Жыл бұрын
An actual life saver, thank you!
@mohammedasadi
@mohammedasadi 5 жыл бұрын
Very useful, thank you so much!
@syu-rueijhang7966
@syu-rueijhang7966 6 жыл бұрын
Thanks for your video, it is very helpful
@bhavinsodha2700
@bhavinsodha2700 4 жыл бұрын
Thank you so much for this. You explained everything so well!
@Jimmmmmmmy
@Jimmmmmmmy 5 жыл бұрын
Thanks, this was helpful
@driedmango1914
@driedmango1914 2 жыл бұрын
brilliant tutorial. looking forward to using this at work
@austinfernald4972
@austinfernald4972 3 жыл бұрын
AWESOME! Thank you
@Urotsukidogi
@Urotsukidogi 4 жыл бұрын
yes, really good work ! Thanks a lot
@Invictus2600
@Invictus2600 5 жыл бұрын
this is very useful! thanks! can you also make a video how to interpret different terms and coefficients please?
@claudiarp5735
@claudiarp5735 6 жыл бұрын
Excellent explanation. Thank you.
@DrGrande
@DrGrande 6 жыл бұрын
You're welcome - thanks for watching -
@mayurbedmutha1388
@mayurbedmutha1388 4 жыл бұрын
Thanks a ton Sir!!!
@jacksonreid3280
@jacksonreid3280 5 жыл бұрын
Amazing, thanks.
@ronnieserfajuan
@ronnieserfajuan 4 жыл бұрын
thank you Dr. Todd
@davida.johnson8936
@davida.johnson8936 3 жыл бұрын
Got it! Thank you!
@rhythmagarwal3995
@rhythmagarwal3995 5 жыл бұрын
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?
@tomparatube6506
@tomparatube6506 4 жыл бұрын
Thank you!
@StephenPaulTroup
@StephenPaulTroup 5 жыл бұрын
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.
@sukwoohong6542
@sukwoohong6542 4 жыл бұрын
Thank you for excellent explanations. One question. When they talk about univariate analysis and multivariate analysis, is multivariate analysis the same as multiple regression here?
@minazakariafakhryfahmy7244
@minazakariafakhryfahmy7244 4 жыл бұрын
Thanks Dr. Todd
@jiffycrimso5691
@jiffycrimso5691 5 жыл бұрын
Thanks Todd!
@manarshraideh6028
@manarshraideh6028 5 жыл бұрын
nicely explained
@coskunfirat2777
@coskunfirat2777 4 жыл бұрын
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.
@ryanhessong8460
@ryanhessong8460 4 жыл бұрын
I'm wondering how could I use a predictor variable of low light and high light, with outputs being concentrations
@Rickmc1427b
@Rickmc1427b 4 жыл бұрын
This is great. Can you use this for 3+ independent variables?
@saavanrijsinghani
@saavanrijsinghani 5 жыл бұрын
God bless you
@bijanrosen1184
@bijanrosen1184 5 жыл бұрын
Is there a reason you didn't use parenthesis when plugging values into your formula?
@oscargiraldosanchez
@oscargiraldosanchez 4 жыл бұрын
thank you
@KIWu-th8wr
@KIWu-th8wr 4 жыл бұрын
Thanks!! I'm here for solving ISE homework. lol
@triple_adawa5855
@triple_adawa5855 7 ай бұрын
But how could you say Significance F is less than 0.05 where it is shown 7.50677 on the anova table in the video?
@TheMrHamizan
@TheMrHamizan 5 жыл бұрын
how to know the multiple equation for the regression?
@iBringTheRain24
@iBringTheRain24 5 жыл бұрын
What's the difference between a Generalized Linear Model and a Multiple Regression?
@mohammadkhajenasir7748
@mohammadkhajenasir7748 4 жыл бұрын
Thanks
@kirankumarreddy3681
@kirankumarreddy3681 5 жыл бұрын
dear sir.. pl. also tell how to generate an eq. Y=m1x1+m2x2+m3x3... mnxn using the obtained result.
@zhansayabauyrzhanova7919
@zhansayabauyrzhanova7919 4 жыл бұрын
Thank you a lot, it is very helpful!~ If it is possible I am a biology student and competiting to biostatistics course. Today after 3 hours is the deadline. I have to do Excel task for linear regression. 2 Excel files were submitted. What I have to do is to find outcome variable. To find it, I may not find residual. If it is possible, please help me, just give me a hint PLEASE. GOD BLESS YOU. thank you a lot in advance!~~~
@zhansayabauyrzhanova7919
@zhansayabauyrzhanova7919 4 жыл бұрын
I do not have residual and Y value too. If I had it, I might just minus it
@shaheermalik3516
@shaheermalik3516 5 жыл бұрын
Can anyone help me with multiple regression. I followed your steps but it shows an error and I can't get the results
@dr.ahmadsalahawad9497
@dr.ahmadsalahawad9497 4 жыл бұрын
thanks
@AeroAstrophotography
@AeroAstrophotography 5 жыл бұрын
ctrl+shift+down on the arrow keys selects all data after a cell you want if anyone wants to know that shortcut
@kressckerl
@kressckerl 5 жыл бұрын
I use ctrl, shift and arrow keys a lot when navigating sheets, just wanted to add that there is all sorts of combos with the modifiers
@sailakshmi4559
@sailakshmi4559 5 жыл бұрын
Iam getting #NUM in significance and p value...what should i do??
@austine6619
@austine6619 5 жыл бұрын
check your input, you gave it a reference it doesnt like
Interpreting Linear Regression Results
16:08
Sergio Garcia, PhD
Рет қаралды 296 М.
How To Perform Simple Linear Regression In Excel
14:51
Steven Bradburn
Рет қаралды 417 М.
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 135 МЛН
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
00:17
OKUNJATA
Рет қаралды 21 МЛН
NERF WAR HEAVY: Drone Battle!
00:30
MacDannyGun
Рет қаралды 53 МЛН
Predict Outcome Value with SLOPE and INTERCEPT Functions in Excel
6:12
Regression: Crash Course Statistics #32
12:40
CrashCourse
Рет қаралды 687 М.
Using Multiple Regression in Excel for Predictive Analysis
9:18
Management Information Systems
Рет қаралды 1,7 МЛН
Multiple Regression in Excel
11:02
Jalayer Academy
Рет қаралды 760 М.
Regression Analysis | Full Course
45:17
DATAtab
Рет қаралды 783 М.
Interpreting Output for Multiple Regression in SPSS
8:41
Dr. Todd Grande
Рет қаралды 591 М.
Calculating Descriptive Statistics Using Excel
12:34
Dr. Todd Grande
Рет қаралды 54 М.
Multiple Linear Regression in SPSS with Assumption Testing
14:54
Dr. Todd Grande
Рет қаралды 381 М.
Excel Multiple Regression
6:33
SoftTech Tutorials
Рет қаралды 146 М.
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 135 МЛН