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.
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.
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
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.
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)
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 .. 🙂
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
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?
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?
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.
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!
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!
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!
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.
Thanks Mynda!
Welcome, Chris 😊
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 🙏
Mynda thanks a lot for this important video 😍
My pleasure 😊
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
Great explanation using the analysis pack.
Thank you!
Awesome Video!! Hope to see more videos with good use cases of excel potential
Glad you liked it!
Thank you for this video!
My pleasure!
Very Cool and understandable. Thank you for sharing. 🙂
Great to hear!
Congratulations!
Thank you!
I didnt know that from scatter plot you get the equation-) Thank you !
Glad my video was helpful 😊
Great content 👍👍👍👍
Thank you!
Excellent content
Thanks so much!
Wow thanks 😃
glad you liked it!
Awesome channel
Thanks so much!
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 🙏
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?
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
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.
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 🙏😊