Это видео недоступно.
Сожалеем об этом.
Excel Linear Regression The EASY Way!
HTML-код
- Опубликовано: 2 авг 2024
- 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
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.
Thank you! And thanks for adding some further info 🙏
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
@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.
Thanks for always keeping us updated and informed on the latest. Much appreciated 🙏
My pleasure!
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.
Thanks, Ivan!
Extremely interesting 😮!! There is a whole world in this. Lots of new interesting things to learn. Thanks for the video 🙏. More on this please😅!!
Great to hear you liked it 🙏
Thanks Mynda!
Welcome, Chris 😊
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)
I was just about to comment with the same point!
My prof will say this means you understand it better. Thank you William. And thank you, Mynda.
Thanks for the added info @willaimmerritt9517 🙏
Great video
Thank you for this video!
My pleasure!
Very Cool and understandable. Thank you for sharing. 🙂
Great to hear!
Awesome Video!! Hope to see more videos with good use cases of excel potential
Glad you liked it!
Mynda thanks a lot for this important video 😍
My pleasure 😊
Great explanation using the analysis pack.
Thank you!
Nice! TREND and/or FORECAST are useful too for determining the Y value for a given new X value.
Glad you liked it!
Perhaps a topic for a video as I’m quite new to the statistics but enjoying a very accelerated Excel learning path.
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
Glad it was helpful!
Wow thanks 😃
glad you liked it!
Great content 👍👍👍👍
Thank you!
Excellent content
Thanks so much!
Congratulations!
Thank you!
Awesome channel
Thanks so much!
I didnt know that from scatter plot you get the equation-) Thank you !
Glad my video was helpful 😊
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?
Do you mean this one: www.myonlinetraininghub.com/searchable-drop-down-list-in-excel
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?
Not in Excel Online (Yet). You would have to calculate the trend and then add it as another series to the chart yourself.
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?
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 .. 🙂
Aw, that's awesome to hear, Steven 🙏
Plz share any tool to excel which replaces the use of eviews software
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
💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯
🙏🙏🙏🙏🙏🙏🙏
The link to download the file is not working.
Oops, this video posted at the wrong time... link is fixed now!
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.
Great to hear 🙏😊