Excel Linear Regression The EASY Way!

Рет қаралды 22,992

Күн бұрын

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.
🔻 DOWNLOAD EXCEL FILE HERE: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ 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

Пікірлер: 59

@marjoriefrancis4560 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

My pleasure!

@chrism9037 Жыл бұрын

Thanks Mynda!

@MyOnlineTrainingHub Жыл бұрын

Welcome, Chris 😊

@quentinbricard Жыл бұрын

Thank you for this video!

@MyOnlineTrainingHub Жыл бұрын

My pleasure!

@inisolation6582 Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Thank you! And thanks for adding some further info 🙏

@lordbaldwin6450 4 ай бұрын

What is a simple way to understand statistical concepts. I work with data but find it hard to grasp these concepts and recall them when dealing with day-to-day challenges. If you can be of any assistance, please drop your email. Thanks

@mrinalinimustafee9415 3 ай бұрын

@inisolation6582 I am new to regression analysis and currently doing it as part of a project. Would you be able to help with interpreting the output? I am using SPSS.

@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.

@MyOnlineTrainingHub Жыл бұрын

Thanks, Ivan!

@ahmadbinnaji4687 9 ай бұрын

Mynda thanks a lot for this important video 😍

@MyOnlineTrainingHub 9 ай бұрын

My pleasure 😊

@KM-co5mx Жыл бұрын

Very Cool and understandable. Thank you for sharing. 🙂

@MyOnlineTrainingHub Жыл бұрын

Great to hear!

@josecarlosconejo5724 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Great to hear you liked it 🙏

@JV44HeinzBar Жыл бұрын

Great explanation using the analysis pack.

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@okohlawrence2466 11 ай бұрын

Great content 👍👍👍👍

@MyOnlineTrainingHub 11 ай бұрын

Thank you!

@josecarlosgoncalves5065 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it!

@shawnward3494 Жыл бұрын

Wow thanks 😃

@MyOnlineTrainingHub Жыл бұрын

glad you liked it!

@barrettkaz 4 ай бұрын

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

@MyOnlineTrainingHub 4 ай бұрын

Glad it was helpful!

@hectorricardus Жыл бұрын

Excellent content

@MyOnlineTrainingHub Жыл бұрын

Thanks so much!

@sjn7220 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it!

@scg565081 10 ай бұрын

Perhaps a topic for a video as I’m quite new to the statistics but enjoying a very accelerated Excel learning path.

@kleinboertjie Жыл бұрын

Awesome channel

@MyOnlineTrainingHub Жыл бұрын

Thanks so much!

@bagnon Жыл бұрын

Congratulations!

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@williammerritt9517 Жыл бұрын

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)

@RayCottam Жыл бұрын

I was just about to comment with the same point!

@pkoomson1 Жыл бұрын

My prof will say this means you understand it better. Thank you William. And thank you, Mynda.

@MyOnlineTrainingHub Жыл бұрын

Thanks for the added info @willaimmerritt9517 🙏

@lchase7858 Жыл бұрын

Great video

@SGH-rt6ci Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Glad my video was helpful 😊

@aslhanaslhan1092 3 ай бұрын

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?

@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?

@MyOnlineTrainingHub Жыл бұрын

Do you mean this one: www.myonlinetraininghub.com/searchable-drop-down-list-in-excel

@perryazzkidson 4 ай бұрын

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?

@MyOnlineTrainingHub 4 ай бұрын

Not in Excel Online (Yet). You would have to calculate the trend and then add it as another series to the chart yourself.

@m.farrukhali1791 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

You could try the data analysis toolpak which is a free add-in available in Excel: support.microsoft.com/en-au/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4

@steven.h0629 Жыл бұрын

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 .. 🙂

@MyOnlineTrainingHub Жыл бұрын

Aw, that's awesome to hear, Steven 🙏

@IamTheReaper911 Жыл бұрын

💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯

@MyOnlineTrainingHub Жыл бұрын

🙏🙏🙏🙏🙏🙏🙏

@humayungul2120 Жыл бұрын

The link to download the file is not working.

@MyOnlineTrainingHub Жыл бұрын

Oops, this video posted at the wrong time... link is fixed now!

@scg565081 10 ай бұрын

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.

@MyOnlineTrainingHub 10 ай бұрын

Great to hear 🙏😊