How To Perform Simple Linear Regression In Excel

what if the null hyphosis is true, no significant correlation between these variables?

Hi, Can you run a regression when the y variable is a range and not a single number. For example range of income is the x variable and the years worked is the y variable

Thank you for sharing such a detailed and high quality video.

Thanks a lot for such clear explaination

I loved the fact that, the content is so simplified and easy to digest

Thanks for this. This is a super big help.

Thanks a lot 😊

Can you please do a tutorial on multiple regression?

Can you please do a tutorial on multiple regression

How to interpret the accuracy of the linear Regression Model?

Your teaching method, language, and presentation are just fantastic!

Man your explanation is very clear. Thank you 👌👌

Very rare to find a video that is detailed and easy to understand like this one... superb indeed.

Hi Steven! Why no one teach how to do the graphs as well? You used the tools but if you don't show how there is no difference between you and wikipedia. It can be seen that you put a lot of effort in the video but look back to the information delivered, there is no value! Take care and hope you do more next time!

This guy has help me a lot after struggling on how to do this analysis on data.

Can you put this data in description

Can you drop this excel data

Perfect explanation

WOW that video is super helpful, thank you so much for posting it.

this is very helpful thank you

Thank you so much

Great explanation!

If I would like to practice following your video, where I can download the data?

Hello. Thank you for your video. I have a question. I followed the steps and put your exact data in an Excel spreadsheet and performed the regression analysis. My results were very slightly different from yours. For example, your Multiple R is 0.657445249 but mine is 0.657525711. And a similar slight difference happned in the other variables, too. Can you please explain the reason? Thank you.

Top class video. Super like.

Thank you so much for such a wonderful video.
May I have the excel file, so one can practice along with the tutorial.

Do you have a video on how to do this but with a multiple regressor?

Thanks a tonn❤

High quality explanation

I just subscribed. Excellent video. Absolutely perfect analysis

Very helpful video thank you so much!

Excellent job! Congratulations!

Excellent! Best linear regression video I have seen. Thank you!

I freaking LOVE technology! this is amazing! The world is so lucky to have people like you!!! Thank you!

Thank you so much for going through this in such detail. This was extremely helpful for me. I appreciate you!

Finally a video that show in deeper detail all the coefficients and charts generated by Excel in a Regression analysis. Thank you very much for that.

Thanks a lot man!

What a legend

Superb! This is excellent. Very much appreciate your in-depth coverage of each of the elements in the output

superb little tutorial thanks.

Hi

Thank you for the most comprehensible piece, I am forever thankful!!!!

Hat's off to u sir for this great video

Thank you for sharing. Coming from a non statistical background, you really helped my understanding by the way you simplified the statistical analysis.

thank you, a thousand times, thank you, Dr. B, from a non-traditional (i.e., OLD) doctoral candidate dissertating in acoustic and socio-linguistics. Is that a Mancunian accent I hear, Oldham, perhaps? Peace, kw

Thank you! one of the best tutorials videos i have seen. Very clear and practical.

please share the excel file

thank you my G

I ran a simple linear regression in Excel twice, each time I swapped which variable was X and which was Y. While obviously the units of the standard error changes, and the residuals changed, the correlation coefficient remained the same and the p-value remained the same. I thought linear regression established cause and effect, but it seems it only establishes a better prediction of what you can expect to happen to one variable if the other variable changes by some amount. Basically, is it still only a measure of correlation rather than cause and effect?

So helpful. Thank you so much!!!