Excel Linear Regression The EASY Way!

Excel linear regression is easy with its built-in tools. In this tutorial, we'll explore what linear regression is, why it's useful, and the Excel tools that enable you to do it with the click of a few buttons.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Excel Linear Regression
0:13 What is Linear Regression
0:52 Linear Regression with Charts
2:02 How to use the equation
3:48 How to use the R squared value
4:26 Regression with the Data Analysis Toolpak
5:50 Regression Statistics
6:33 ANOVA Statistics
6:41 Coefficients Table
7:03 Residuals

[inisolation]

As someone who uses Regression Analysis on basically a daily basis this is a very good starting point for those new to the concept. The P values are also an important measure plus understanding that a final R Squared value might be more significant in one analysis vs another. Eg a 0.60 might be acceptable in one industry/product/test but totally insignificant in another. The outcome is a matter of context.
Enjoyed the very succinct presentation, congratulations.

[marjoriefrancis]

Thanks for always keeping us updated and informed on the latest. Much appreciated 🙏

[IvanCortinas_ES]

Excellent explanation of this topic, not much discussed on the internet. The Data Analysis Toolpak is a very appropriate field to make more video tutorials. It can be very helpful.
Thank you very much Mynda. Brilliant tutorial.

[sjn]

Nice! TREND and/or FORECAST are useful too for determining the Y value for a given new X value.

[barrettkaz]

Really useful video, I am learning regression in R Studio however do not have access to it at work, therefore this has helped me understand how to complete this in excel, thank you

[ahmadbinnaji]

Mynda thanks a lot for this important video 😍

[josecarlosconejo]

Extremely interesting 😮!! There is a whole world in this. Lots of new interesting things to learn. Thanks for the video 🙏. More on this please😅!!

[JVHeinzBar]

Great explanation using the analysis pack.

[KM-comx]

Very Cool and understandable. Thank you for sharing. 🙂

[williammerritt]

Mynda, at the end of the video you point out the equation as y=.08x+0.1667. However, at this point in the video you have now added another variable. Therefore, the new equation is y=0.066x1 + 0.038x2 + 0.14. (from the Coefficients part of the regression analysis)

[josecarlosgoncalves]

Awesome Video!! Hope to see more videos with good use cases of excel potential

[SGH-rtci]

I didnt know that from scatter plot you get the equation-) Thank you !

[aslhanaslhan]

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?

[m.farrukhali]

Plz share any tool to excel which replaces the use of eviews software

[kimyenchu]

Hi you had a video where you used the filter from the pivot table as a filter. I am looking for that video but can't find it. Could you please post it again?

[perryazzkidson]

So I'm doing lots of linear regression analysis in my bio class at the moment. But we're using office 365, the free version. I can never find the options to put in a trendline or how to show the formulas. So I wanted to ask, is it even possible to do it on the office 365 free version of excel? Do I need to download it/buy it?

[steven.h]

My wife and I refer to Mynda's lessons often and share with others 👍😎✊
I'll be asked something and reply, I know exactly the girl for you, and you can hit pause if you need to .. 🙂

[humayungul]

The link to download the file is not working.

[scg]

Really enjoyed this video. Best explanation I’ve seen and for a non-statistician, that’s saying something as I completely understood everything…… including the corrected points from @Williammerrit9517.