How To Perform Simple Linear Regression In Excel

In this video tutorial, I’m going to show you how you can perform a simple linear regression test by using Microsoft Excel. Not only will I show you how to perform the linear regression, but I’ll show you how to analyse the outputs of the regression test.
VIDEO CHAPTERS
00:00 Intro
00:22 My example data
00:54 Installing Analysis ToolPak
01:32 Performing linear regression
04:01 Summary output table
06:05 ANOVA table
07:04 Coefficients table
09:04 Residuals
10:58 Residual plot
11:43 Standardized residuals
12:21 Line fit plot
13:31 Normal probability plot
14:27 Summary
ONLINE GUIDE
toptipbio.com/linear-regressi...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
KZbin SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@StevenBradburn]

ONLINE GUIDE toptipbio.com/linear-regression-excel/

[@mohitsingha1809]

Thanks so much.

[@albertoclemente6071]

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.

[@marialavinia3365]

thank you so much! you did a better job at explaining than a lot of my teachers!!

[@divy03]

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

[@StevenBradburn]

Thanks mate appreciate the feedback

[@Ryan-nh3mt]

better job explaining this than a lot of other videos out there. good job

[@ngobamartyns-yellowe5555]

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

[@pippinbloom]

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

[@julescaruso4398]

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

[@mohitsingha1809]

Great explanation, this is the first really useful one for a novice to learn about how to interpret a simple linear regression model.

[@David-lp1br]

Thank you for this detailed tutorial! The explanatory part was really helpful to determine which value was important in my research!

[@jessicaescobar7549]

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

[@anusingh164]

Thanks a lot. This video was very helpful if one wants to get a quick understanding on regression model .

[@user-jg9rs1mr2k]

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

[@Chic.Geek75]

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

[@RyanHolstad]

Extremely helpful, great example and well explained. It helped immensely with my Statics class. Thank you!

[@MrKalerender]

Clean video on using that technique. Perfect for my students to refer to.

[@benedictnuvye5277]

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

[@StevenBradburn]

Thanks for the feedback Benedict 👍

[@martinnhantran]

Thank you so much for the video. Simple and easy to understand.

[@loranscott3174]

This was a really great tutorial and very helpful.

[@shubhamsirsikar1461]

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

[@epdelavega]

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

[@StevenBradburn]

Thanks mate. Appreciate it 👍

[@ThePokenger]

This was a lifesaver

[@titantitus3133]

This is so helpful. Thank you so much! I am working on a research project and was having trouble getting started with regressions on excel

[@StevenBradburn]

You're so welcome! Good luck!

[@priyanshijoshi1394]

You are doing a great job. Keep it up 👍👍👍

[@EnrqSan]

Best tutorial ever developed

[@kasmindanil5527]

this one is quite clear i found so far, thanks a lot sir.

[@evaschoenfeld3186]

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

[@hamayonkhaleqyar7286]

The best video for Regression ,1000000 likes

[@danielkwawuvi_tutorials]

detailed explanatory tutorial. thank you very much, Sir

[@vasiliostantanis4627]

Excellent job! Congratulations!

[@nasrollahrajaei4477]

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

[@StevenBradburn]

Thanks very much for the kind feedback

[@mariamatunrase9312]

Very insightful ... thanks

[@maintainyoursanitywhenbein6660]

Thansk - very helpful ... I am going to watch many more of your videos ...

[@zinimbita9789]

Thank you so much this is very helpful

[@williamodela]

This is helpful. Thank you, sir

[@ReesYou]

So helpful. Thank you so much!!!

[@HaciendoLQMDLG]

Very helpful video thank you so much!

[@becomingdr.e952]

Very helpful! Thank you.

[@nkwanwighogomudonald5415]

Fantastic in teaching and explaining. GOOOOOOOOD JOB

[@marcstla]

thank you very much! Very clear!

[@jainabatrawally7123]

This is superb 🎉. Keep up the momentum.

[@saraparedes1666]

Thanks for this video! Helped me with a lab :)

[@leahiennguyen8440]

very helpful, thank you!

[@prasadbishetti9879]

Thanks a lot for such clear explaination

[@gavinelias6272]

Solved my 10 day confusion in just 9 minutes

[@davidkariuki3967]

Very helpful tutorial...step by step

[@chinnapatbuachart4217]

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

[@clementn240]

thanks! great explanation!

[@bobmilani6109]

I'm a rock star thanks to you!

[@gmanova]

superb little tutorial thanks.

[@DVGgames-od3tb]

Thank you so much!

[@michaelliu6323]

Thank you Steven for this great tutorial video! It is so helpful. Meanwhile, would you pls. explain why only the C.i. of the slope is considered to calculate the C.I. of the estimated y value in most textbooks? There are two parameters (slope and intercept) in the regression equation, and both parameters have C.I. calculated, shouldn't we put both C.I. into the calculation to estimate the CI of the y? thanks!

[@__Mako]

High quality explanation

[@deividasbalt]

You are a god. Thank you!

[@CLEFFJOE]

I just subscribed. Excellent video. Absolutely perfect analysis

[@StevenBradburn]

Cheers Jon Jon

[@user-ng4pp7fp6t]

SIMPLY WOW !!! . Can you suggest good tutorials for other ML models also pls like Supervised models (Classification models like Naive Bayes classifier, Decision Trees, Support Vector Machines, Random Forest, K Nearest Neighbours, Logistic Regression) (Regression models like Neural Network Regression, Support Vector Regression, Decision Tree Regression, Lasso and Ridge Regression) Unsupervised models (Clustering models like k-means clustering, mean shift clustering, DBSCAN clustering, Agglomerative Hierarchical clustering, Gaussian Mixture) Please brov. Thanks in anticipation.

[@NishanthPillaiOSCM-]

If my test is insignificant (Fstat

[@junisaresilvosa9430]

this is very helpful thank you

[@NavaneethaKrishnanA]

Clear and Concise

[@PrajwalKhanal-ox1is]

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

[@manishjargamagar9288]

Most useful. Thanks a lot

[@manuelgonzales2570]

EXCELLENT. Thanks!

[@mohitkaushik21]

Thanks a lot 😊

[@hichamitani6433]

amazing explanation prof

[@nishanthpillai6246]

If the significance F value would had been greater than 0.05..would the regression equation hence formulated be valid??

[@potatotrash8320]

Thanks for this. This is a super big help.

[@StevenBradburn]

Very welcome

[@mabvutobanda7699]

Perfect explanation

[@kimwaters3140]

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

[@vascopatricio2]

Very clear, detailed and useful, super class. Thank you so much :-). Ps: (not randomly) subscribed.

[@StevenBradburn]

Thanks Vasco!

[@noorakp9704]

This is easy to understand 😀

[@NishanthPillaiOSCM-]

Why can't I take null hypothesis as there is relationship between the two variables?

[@JD88784]

Great video

[@shankar167]

Top class video. Super like.

[@jedrixmotovlog]

Man your explanation is very clear. Thank you 👌👌

[@StevenBradburn]

Cheers mate

[@aslhanaslhan1092]

Hello I did linear regression, but my teacher did not accept it because the number of steps in the formula was low. How can I increase it?

[@antievtorduetrenchesvolley6658]

Very Clear

[@SunilPatil-tq5cb]

Hat's off to u sir for this great video

[@Eric-yu1ur]

I really enjoy your video can you show us how to do a logistic regression please

[@punpun6417]

Great video :)

[@Trigy100]

Very helpfull thank you

[@melekali5811]

thanks a lot? may God bless you.

[@thez00t6]

Much appreciated

[@farhanchowdhury1846]

Thanks man

[@AKMKGP]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@NebiyouMaseboMalore]

Too interesting !!!!!!!!!!!!!!!!!!!

[@amacox3126]

how can i get probability percentage from this linear regression?

[@chukwuochachineduzim2497]

Please in l will need more tutorials on basic econometrics calculations and these type of vids....if not am failing this course please

[@MichaelMooreboston]

Hello Steve, at 6:53 area, I thought you would say you'd 'reject the null hypothesis', and not 'fail to reject the null hypothesis'. Possibly just a mix-up of words, but given that your p-value is less than alpha you would reject and not fail to reject.

[@bongamav]

Thank You

[@khudahafiz478]

Thank you so much

[@uppijr7373]

How to interpret the accuracy of the linear Regression Model?

[@koushikyetukuri]

Thank you

[@mamunipradhan5279]

167.08 ? Where do you get it

[@mineguda7476]

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

[@neilsharma2793]

Thanks a lot man!

[@StevenBradburn]

Welcome mate!

[@saitejathota]

Thanks a tonn❤

[@jotarokujo9242]

thank you my G

[@latiefahmad920]

Show paird test in excel? And how why use mcnemars test?

[@ramamohangadiyaram9004]

Excellent presentation Sir!!

[@StevenBradburn]

Thank you kindly!

[@israelowolabi7523]

Can you please do a tutorial on multiple regression?