Interpreting Linear Regression Results

[@hwylsoliloquy2959]

I FINALLY UNDERSTOOD THIS REGRESSION TABLE, GOT A 100 ON MY STATS TEST BC OF U YOURE MY HEROOOOO THANK YOU VERY MUCH DR

[@sergiogarcia9044]

I am humbled by your comments and encouraged by your success. Thank you and congratulations to you.

[@Hcooper14]

Hello dude please do you know how to calculate actual tip values?

[@tom_fors]

I read the reading material for school, but you explained it in a way that made much more sense. Thank you so much!

[@gutibokeron]

Thanks Sergio, I studied this years ago during my Degree but it got rusty for not using it. Now with your tutorial I remember it even better than then and I think this is one of the most detailed tutorials here! Most of them don't talk about the Alfa coeficient or not going on depth like you did. Thanks again!

[@sergiogarciaphd7142]

thanks for the comment. I appreciate it.

[@MichaelMooreboston]

This is the best video on explaining significance. Learned so much from this!

[@yuviydv00]

you taught in this Vedio more than I learned in my whole semester. Thank you very much for upload this Vedio

[@pooranir1062]

Amazing video. I can see the light at the end of the tunnel 😅 Clearly explained. Thank you so much!

[@Bruhmaster20084]

I can't tell you thank you enough!!!! literally gearing up to do my predictive analytics project and this was a lifesaver!!! THANK YOU!!

[@roylam3083]

Best video I've seen on this topic. Thanks! Love how you broke it down in to answering the 4 core questions and how to answer them

[@Sandra6797]

I was so overwhelmed by the subject but you made it so easy to understand! Thanks Dr. Garcia~

[@sergiogarciaphd7142]

Glad to hear it!

[@aslihanakin1999]

Thank you Sergio Perez, this will help me a lot for my final paper. Keep up the side hustle 👍

[@morganharris507]

Wow this helped me so much with my data analytics major project. Thank!

[@ajaynairexperience8239]

Superb!! Dr. Garcia guides how to pick up the right data points from the noise and how the relevant data points support answering the problem statement, thank you !!

[@blue-jay748]

Hi, I like the way you explain statistics. I really appreciate the colors you use; I can focus better with no need to stop the video for a long time. Clear voice and speed just perfect. I'm an education psychologist graduate student; thinking on going further, probably statistics. Thanks for sharing.

[@zepaie69420]

Thank you so much, really helpful video for my dissertation project I'm working on at the moment. Only 3 weeks left 😢but this will definitely get me through it!

[@sergiogarcia9044]

Good Luck! It'll be over before you know it!

[@yamoo62]

Thank Sergio for this detailed explanation for the linear regression, very useful when i need to explain the result!

[@sergiogarciaphd7142]

good to hear. thank you

[@makda.G]

Excellent and straight to the point. THANK YOU!

[@santiagocardenas4661]

Dr. Garcia is a literal god at statistics

[@Christian-wm5bq]

He dident interpret the coefficients.

[@fredtheman211]

this was an amzing video saved a student today thankyou

[@gracesJewelryAndDesign]

Your video is very clear and easily understand the linear regression results. Thanks !

[@anthonykavindi6901]

So helpful, this video is so amazing

[@Fammyy.]

Currently doing my dissertation & one of my analysis methods is using regression models. Cannot express enough how helpful this video was! Thank you so much🥹

[@sergiogarciaphd7142]

thank you and good luck.

[@EdidiongUdofia-vt8ib]

Excellent explanation. Thank you.

[@RitahNamirimu]

you really helped me as i was doing my final year research project,cant thank you enough

[@kennychan1162]

Thank you sir! This is such a great explanation, I was working on a project at work and you helped me a great deal!

[@tatendamushore4315]

I finally understand i have been struggling to understand this topic

[@DelilahLutengano]

wonderful explanation, bravo

[@forydas-l5b]

Super Explanation... Amazing

[@billwindsor4224]

Hello Sergio, this is an excellent walk-through; thank you for presenting this, and thank you for your dataset reference. I appreciate your clarification on your presentation focusing on a "single independent variable linear regression."

[@zishanahmed1461]

This is soooo clear!!! thank you so much.

[@DanChoiThon]

Thank you so much! Great and concise explanation paired with easy-to-understand language!

[@wassimwoof9485]

thank you for the explaining, it's clear a lot, but i have question what does mean by a good variable

[@ds-it9ej]

Sir thank you for your clear demonstration just got a question, if I am right the video is doing a single-tail test, if I am doing a two-tail test is it the same way to accept or reject the H0 by comparing the p-value of the coefficient with the significance level(i.e. 5%)?

[@sergiogarciaphd7142]

The Ftest by definition is a one tail test. You can't do a two tail test in a regression. Technically, it is the same process when testing the pvalue, but it is a different distribution.

[@ds-it9ej]

@@sergiogarciaphd7142 Thank you for the reply sir but I still wonder why a two-tail test cannot be carried out in a regression and also what distribution are you referring to? I apologise if the question is unnecessary, but I would greatly appreciate it if I can hear further explanation from you.

[@ngenoedmon7485]

This is supper explanation. Thank you very much, it enhances my class work and add me confidence.

[@sergiogarciaphd7142]

Confidence is key!

[@maloyaircraft1174]

Excellent video!

[@alanguan277]

Truly amazing video!

[@marwanelmounajjed]

It's a good video, it's ctrl+shift+down is a life savior

[@niamhbeattie4759]

I thought the coefficient have to be between 1 and 0, my results are pretty similar to yours with high coefficients and I was confused?

[@sergiogarciaphd7142]

There are other methodologies where that is true, like a logistic regression. You may also be confusing coefficients with traditional probabilities......(emoji with guy shrugging his shoulders here).

[@TR-rx5ej]

Can i use regression analysis for data collected at irregular intervals?

[@sergiogarcia9044]

maybe...but the words irregular intervals suggest you are running a time series analysis and that requires a different set of assumptions. The results of a simple linear regression may be misleading for that type of analysis, which is not to say that it sounds like you may have a lack of data as well.

[@dand7075]

If x variables are inputs, shouldn't those be independent variables? Since the output (y) depends on x variables?

[@sergiogarciaphd7142]

yes. you are correct. That is my mistake and it keeps me humble as more and more people watch (and correct) the video.

[@dand7075]

@sergiogarciaphd7142 Thank you for confirming. Your videos helped me pass my finals. I didn't forget this one since I had to dig. Worth it. Great videos!

[@hazlizaibrahim9930]

Thank you Dr. Garcia, appreciate it.

[@TomasTeitelbaum]

Being a simple linear regression, the p value will be the same as the sig F. They are both testing the same null hypothesis (coeff = 0). I don't see how the answer different questions here.

[@sergiogarcia9044]

no argument. but we're also setting up the future transitions into multiple regressions down the road.

[@rubyleopard]

came for the content, stayed for the *SSSSSSSSSSSSSSSSIP* at 6:54. nice video

[@sergiogarciaphd7142]

my students make fun of my coffee drinking all the time. lol.

[@besp7540]

i want to learn how you connected a pen to you computer. what pen do you use? This is amazing how it helps in explaining and understanding

[@sergiogarcia9044]

I have a Wacom tablet, which comes with a pen, and a screen capture software tool. easy cheesy.

[@monikamakuszynska9349]

Thank you so much for taking time to explain regression! This vid put my mind on rest! :-)

[@sergiogarciaphd7142]

My joy. Thanks.

[@farrukhnabiev9307]

thank you man for this fantastic explanation video was really helpful

[@jodielee6713]

Enjoyed that - great explanation!

[@aayushshukla342]

Such a perfect video ,thank you so much.

[@myandrobox3427]

Wow!!! Loved it!! 👍🏻👍🏻👌

[@M89-f4o]

If I have more than 1 independent variable, how may I know which factors are the strongest predictors?

[@Dolcesangue]

Fantastically explained ! Thank you very much for having taken your time to help us

[@sergiogarciaphd7142]

Thank you. Good luck in your course.

[@farshadsh3454]

The ultimate goal of running a regression is to be able to predict/estimate the dependent variable. Right? How would you predict if the intercept is negative when you know that neither dependent or independent variables can be negative? Can we force it to zero intercept? If so, how?

[@LA-cm9uo]

Hi, thanks. I have a large dataset of 100,000+ points. How does this affect the linear regression analysis? I got a very large F, an extremely small p value, and a small R^2.

[@sergiogarcia9044]

This can be tricky....you need to talk to your stats person directly. Sometimes when you have a very large number of observations, everything is significant. You'll want to talk to someone directly about your work and get better guidance.

[@insa.kohlbecker]

Thank you for helping us with your knowledge and experience

[@bluestar2253]

Great video! 4:09 May I ask what drawing software are you using to annotate the Excel file? Thanks.

[@sergiogarciaphd7142]

The new Excel allows for drawing right into the spreadsheet..the real trick is to get a screen that allows the use of a pen..like the Wacom tablets....

[@chamilasumathiratna4182]

Thank you! Well Explained!

[@heahkl]

Doesn’t X is independent variable and Y is dependent variable?

[@sergiogarciaphd7142]

yes..yes it does.....(#facepalm)

[@ashthatripathi000]

Yes

[@foodloverss84]

kzbin.info/www/bejne/hpK8oqOFmJKMhKs

[@my_nicholas]

Thank you very much for a wonderful explanation!

[@sergiogarciaphd7142]

Glad it helped!

[@evelynfurtado1240]

Hii, I have done my data analysis and the p value for the model as a whole is not significant, but one of the independent variable is significant. Can I still report it's results ?

[@jackhird2365]

Very helpful!

[@sedarathnadcd]

Finally I got it, Thank you

[@nauansarbasov1138]

Thanks for the video! Can you please send the link to the dataset?

[@sergiogarciaphd7142]

link is now included in the description! thanks.

[@tadarjamja2721]

Thank you very much Sir

[@roshnisaji9566]

Thank you for the great video..can you explain the analysis of standard error?

[@mohammadhiasat2544]

Thanks prof

[@7c_muhammadnadzmibinmohdza245]

Hi, I have produce a regression table just like yours in the vid, but with a different data sets. May I know the reasons why my significance-F is zero?

[@sergiogarcia9044]

The significance of this F is also zero. Excell simply used the (E-70) to detail the decimal numbers are so small they have 70 zeros in front of them. Your zero is probably the same....some super small number that the software shows zero when displaying a smaller (usually 3) decimal places.

[@kotchapornklomjai9427]

Thank you soooooo much.This is a great explanation!!!!!

[@sergiogarciaphd7142]

your happiness is my happiness.

[@Griffindor21]

Great video, I understand now. Only thing I don understand is the "alpha", where did that come from? The smaller value of alpha means more tighter requirement?

[@sergiogarcia9044]

You get to pick the alpha. (Your professor/supervisor/client will do this in practical application.) but when you are the decision maker, you pick the alpha...consider manufacturing where we use the six sigma process for quality....the alpha is, for all practical purposes about 0.01....that becomes the industry standard and it is in essence picked for you....but you get to decide the alpha...and more to the point when you use the decimals in the way you see it in the video...you can easily test any alpha.

[@amonoracheal9118]

Thanks, very clear explanation

[@tathianaarones380]

thank you!!

[@pulkitgupta981]

What Excel add-in are you using for the "Draw" panel in the worksheet?

[@sergiogarciaphd7142]

It's the basic Draw function. The real trick to have a pen screen like Wacom.

[@Chotimotimistakes102]

JazaKAllah ❤️very helpful

[@aaronteh6491]

13:07 you rejected null hypothesis but isnt the p-value (2.417) bigger than alpha 0.01? Where did you get 0.000? Im confused

[@sergiogarciaphd7142]

The p-value is NOT 2.417. It is 2.417e-70. which is 0.0000000...70 zeros....0002417. It is super super small. Excel is giving you a result of precision that is unnecessary and alerting you to the actual value by using the 'e'. This is NOT euler's constant. This is saying X 10^-70

[@aaronteh6491]

@@sergiogarciaphd7142 Thank you so much for the clarification! Have a great day!

[@zehramehdi8369]

Nice video! Just a little heads up: x is not dependant

[@sergiogarcia9044]

yes, I am aware of the error..thanks. I never intended for this video to explode, but I have decided to leave it up because it is helpful. I have placed comments under the video to address this issue...

[@fahmiafri4751]

Hi , i have got one silly question . at 11:02 , you said 'what is the relationship btwn dep(x) and indep(y) variable ?' does it not the dependant variable is the Y and the independent variable is the x actually ? I'm confused . Thankyou for your time .

[@sergiogarcia9044]

yes. this was my mistake in the video.... the Y should be DEPENDENT. It DEPENDS on what happens on the other side of the equation. The X stands alone. It is INDEPENDENT. If you think back to all your high school algebra, we most often put y on the left and did the heavy lifting on the right side of the equation......we've been setting you up for regressions since Freshmen year Algebra the whole time.

[@SergioGarcia-mz3rs]

Yea. You are correct. It is my mistake.

[@SoundBenda-ug1bz]

I'm lost, 11:05 . I thought x is the independant used to predict y, the dependent

[@sergiogarcia9044]

yes. this is an error in my video. I have commented on this many times. You are correct. Y is the DEPENDENT. X is the INDEPENENT

[@jeanicececilia6780]

hi sir, i really need your help. what if i got 0.00000 significant F? is that a good or bad sign? i mean.. it's too good? is it even possible? thankyou!!

[@cmartcinematography]

Which pen do you use

[@Sindibad007]

You are amazing! Thank you.

[@adylmanulat2465]

good day sir, I just wanted to ask if an independent variable is not significant or does not have an explanatory power to the model but when removing it lowers the adjusted r-square what does this imply? so far the reason that i know the reason is because the t-statistic is greater than one. With this information, what can we infer?

[@sergiogarciaphd7142]

It implies exactly what you described in the question. This is a classic trade-off situation. You, as the researcher, need to decide what is important. This is only one of many issues where researchers can disagree on results given the same data and methodologies. Sorry dude. no easy answer here. This is a classic, "What do YOU think?" question.

[@TheMRJ85]

thank you a lot I am 2 hour a way from my exam and I was winder when F-significance rejects the null hypotheses 🙏

[@BrokenRecord-i7q]

Can we conduct logistic regression analysis using excel?

[@4mfenme]

Hi Sergio, I have a question that has always troubled me. If the regression is significant (fvalue

[@sergiogarcia9044]

uh...that's interesting, but not exactly what significance means....when we talk about significance, we are discussing the probability that the relationship between the two variables can/will be replicable if we run the test again with another similar/random/representative sample...and therefore predictable moving into future and we can then make decisions. So we're really talking about the big picture relationship between the two variables. I suggest you look at the residuals (Expected Value minus Actual Value) to see differences between observations. This means that some observations will be closer to their expected value, but that does not mean that any one point is more/less significant than any other.

[@4mfenme]

@@sergiogarcia9044 Thank you very much for your reply! Regression analysis is often used in agricultural studies to examine the influence of rate on an outcome, say wheat yield. So, if three fertilizer rates, low, medium, and high, and applied to plots of wheat and the regression analysis result is that there is a significant positive linear relationship between fertilizer rate and wheat yield, can I say that the low rate is statistically different than the medium or high rate without performing pairwise tests between the yields from each rate of fertilizer? Or, is regression only saying that the relationship is significant, so if fertilizer is increased, yield will increase within the range tested (no extrapolation)?

[@sergiogarcia9044]

@@4mfenme not really. In that scenario, you have 3 data points which is woefully small for a regression. You may be better served doing a t-test for differences between two groups which would show if there is a difference between the two groups or an ANOVA, which could include more than two. That is a classic hypothesis test question and often used in stats Exams..probably more so for Ag specific majors, but the point is the same. You gotta make sure you are using the right tool for the right question.

[@4mfenme]

@@sergiogarcia9044 Thank you, Sergio!

[@LilySteinbach]

Thank you, so helpful!

[@harshitkhilani5796]

Is it a problem if standard error is around 300 if yes what might be the reason for it? I have taken small sample, so do I need to improve the data?

[@ruchajadhav7894]

Hello, did you get an answer for this? I have really good R squate values and significance value but my std error is way too high

[@sanityadav4194]

Hi, it is really very helpful, clearing many doubts in an easy way. the one thing which I would request you to help me understand is why you were referring P value as 0.0000, however it is 2.416 in the regression model. please help what is that I am missing here.

[@geoschool2022]

Sir how can I calculate y=mx+b equation

[@mikeb4070]

Thanks for the video

[@sergiogarciaphd7142]

my joy.

[@Simranjeetkaur-nh8vr]

X is independent and Y is dependent variable

[@sergiogarciaphd7142]

yes....*embarrased*

[@yazhini4367]

Great Explanation! I watched all your videos w.r.t univariate & multiple linear regression on the same dataset and I too tried doing this. It works fine but i have a question(This question is w.r.t your other video on multiple linear regression on the same dataset) - Why have you removed waterfront, view and grade columns from the dataset? I understand those columns might not be required for the regression analysis but if I keep those columns while doing multiple linear regression, it seems like these 3 columns also impact price a lot. P value is 0 for view and grade as well which is less than 0.05 & 0.01. Could you please explain this? if we assume these columns dont impact price value then their P value should be greater that 0.1 right? Looking forward for your response.. Thanks!

[@sergiogarciaphd7142]

I don't remember the results you are referencing off the top of my head, but there is a certain art to selecting variables of interest and measuring the impact. This is not usually a discussion for undergraduate courses but the impact of additional variables is a discussion for MULTIPLE linear regressions. That's a whole other ball game. This video is about interpreting the results of a simple single independent variable linear regression.

[@ahmedmali-wu4bz]

Thank you

[@asifaltaf13]

@Sergio Garcia, Phd: Thank you for the video, it was very helpful. I am currently writing my master thesis and I had cited this video, my supervisor asked me to cite the original literature instead of this video. Do you have any research paper of your own or a book where you have formulated these 5 questions that one should ask while interpreting the regression results? Thanks :)

[@SergioGarcia-mz3rs]

I do not. Any undergraduate stats book will tell you the same, you just have to learn how to read it. Your stats prof knows this and wants you to use your expertise which also relies on the texts you have already been presented with. Use your stats book and go back and read it again. It’ll make more sense. I promise.

[@vignesh047]

Which good stats book you recommend sir?

[@astepoutsidethecamp]

Nice

[@nikitasingh5271]

Use of tstat?

[@ganesharya3512]

have u performed multiple linear/nonlinear regression

[@emmaholm4358]

Can anyone help me explain these numbers? coefficient: .049652, _cons .5150066, t 6.12 t 68.62 p>t 0.00 0.00 number of obs 6.665 prob > F 0.0000, R-squared 0.0056, I am trying to find out whether socioeconomic status can influence whether students find it important to perform better than other students in tasks. I am really bad at understanding these numbers.

[@israelsamuel621]

my questi on is how is x axis dependent variable usually its the independent one

[@SergioGarcia-mz3rs]

Yes. This has been addressed in comments many times. It was my mistake and you correct. The Y is Dependent and the X is Independent.

[@growlife4779]

Why does rejecting the null mean it is a good equation please? Thanks

[@SergioGarcia-mz3rs]

This has to do with the way you set up the hypotheses and is past the scope of this one video. That question comes before you do the math to understand how the scientific method works.

[@munirumutebi5805]

THANK YOU SO MUCH ,BUT I GET LOST ON SIGN WHY WOULD YOU SAY TS SMALL YET WE HAVE 2.33 MORE BIG THAN 0.01

[@sergiogarcia9044]

You may be confusing the actual statistic with the P-value here. I am assuming that you are looking a classic back of the textbook table here. Consider what it is that you are getting out of the table and do not confuse the tstat (on the axis) with the pvalue (area under the curve).

[@lowqchannel]

the intercept's p-value is more than 0.1 How to interpret this

[@vousmavez]

What if I have only 20 observation but my R-squared is 0.99367. Is it normal for a small data to get this R-squared?

[@sergiogarciaphd7142]

so....it's nice to have more observations..but that Rsquare is really good....almost too good?