Amazing! Any idea how to reference the slope of the trendline equation in a separate cell? For example, I'd like to incorporate the slope of the trendline into a separate formula, but don't know how to refer to it so that it updates with any changes to the trendline.
1:59 is my excel just broken or something? Why can't I select and move the equation and R value in my graphs. It will not let me select it. . Edit: Apparently when I select new blank workbook from office launcher it opens a "browser version" which is different from the real version. The browser version is missing many key features, such as the one I mentioned here. I solved by typing excel in search bar to open the app rather than going through office launcher. Really odd that it works that way, but at least it is an easy fix.
I kinda forgot about this, but I was able to fix it. Full fix in OP. Basically just open excel app directly rather than going through office was my fix.
so its based of the line of best fit and its like how strong that line is so 1 is like all the points are perfectly lined up which is only hypothetical and 0 is like they are everywhere no good line of best fit, again hypothetical. So you have decide what you want to accept
hi i am often using trendline to have one equation of the growth curve of a fish . so i have few values of the weight at different moment of the cycle and then i can get this trendline and i want to use the equation to forecast the weight of the fish a different moments . but it results that the equation cannot even give the the value of the plotted spots . why is that ? thanks
We are plotting COVID 19 Delta variant for our State in our country, creating a trendline and possibly determining an exponential equation to extrapolate future values, with no additional lockdown restrictions.
Literally saving me a few hours before my lab report is due. Thank you so much😭❤
Me too!!!!
Same!!
literally me rn. He's a life saver! Simple and concise
Really easy and straightforward. Perfection! Thanks so much
Thank you for the explanation so easy and straightforward 💜
Haha, BIG LIKE! Keep up the good work!
thanks a lot, you are a life saver!
THANK YOU SO MUCH!! You saved my homework assignment
This video helps me more than my college professor. Thank you!
Nice straight to the point, easy to understand, great helping vid mate
Thanks man for your video, people like you make life easy 😃
thank u so much sir, u saved me from doing so much work.
Thank you for a clear and to the point tutorial.
Thank you so much! Very helpful.
Thank you, you are my hero
Thank you so much for the help.
This is awesome!!! Straight to the point.
this help me so much thank you
Thank you. This video is something Microsoft clearly can't do themshelves 😄
amazing. thank you !!
Thanks a lot for the great explanation.
Thank you! I always forget
Thank you so much!
This helps a lot! Thank you
Extremely concise and easy to follow, thank you!
thanks much Steve
Nice and easy...thanks for ur help
thank you very much
God bless your soul 🙏
Thanks alot it was so helpfull
this saved my maths psmt tysm 😂😁
Thank u so much sir, very good
Thank youuuu
Thank you.
good video there.... sorry I am curious about how to change r squared value to r value... thanks.
Take the square root of R2 to get r
thank you so much very useful
Amazing! Any idea how to reference the slope of the trendline equation in a separate cell? For example, I'd like to incorporate the slope of the trendline into a separate formula, but don't know how to refer to it so that it updates with any changes to the trendline.
Thanks! Very helpful!
Thanks fam
Nice video
Excellent! More pls.
Thanks
THANKYOUU!!
Excellent!
Thanks so much !!
Can you please show us how to create a logistic regression
very helpful, thanks!!
How to I extract or lookup or reference the equation, so I can work with it with other cell formulas.
i dont have half the settings pop that you do, how do i fix that?
Amazing
The equation is just not selectable as a text box, is there any other way to move it.
How we can directly call the equation in the cell and put any value instead of X?
Absolute genius !!!
Any way to copy that equation out of the box?
Thanks man. Excel truly is great, but not very intuitive at first...
i like your voice
None of these options show up… 😢
Same
I had also encountered same problem, but later I figured out. You can tap your trade line and click right then you will get options
thx, i forgot
I love u
1:59 is my excel just broken or something? Why can't I select and move the equation and R value in my graphs. It will not let me select it.
.
Edit: Apparently when I select new blank workbook from office launcher it opens a "browser version" which is different from the real version. The browser version is missing many key features, such as the one I mentioned here. I solved by typing excel in search bar to open the app rather than going through office launcher. Really odd that it works that way, but at least it is an easy fix.
same
maybe new version...it sucks
I kinda forgot about this, but I was able to fix it. Full fix in OP. Basically just open excel app directly rather than going through office was my fix.
What is R^2? What does it mean in terms of the information provided?
so its based of the line of best fit and its like how strong that line is so 1 is like all the points are perfectly lined up which is only hypothetical and 0 is like they are everywhere no good line of best fit, again hypothetical. So you have decide what you want to accept
Hi Can you make a video on ROC curve and AUC curve ? thanks
hi i am often using trendline to have one equation of the growth curve of a fish . so i have few values of the weight at different moment of the cycle and then i can get this trendline and i want to use the equation to forecast the weight of the fish a different moments . but it results that the equation cannot even give the the value of the plotted spots . why is that ? thanks
i was only given the regression equation
Try using linest you get the same.
We are plotting COVID 19 Delta variant for our State in our country, creating a trendline and possibly determining an exponential equation to extrapolate future values, with no additional lockdown restrictions.
u da man
Thanks so much
Thank you so much!!
Thankyou
Thank you so much!!!