Adding The Trendline, Equation And R2 In Excel

[@mariahthompson5789]

Literally saving me a few hours before my lab report is due. Thank you so much😭❤

[@mycatcoco9912]

Me too!!!!

[@jackcowan8318]

Same!!

[@robynmonson9804]

literally me rn. He's a life saver! Simple and concise

[@pHn121]

Haha, BIG LIKE! Keep up the good work!

[@kellysmelly283]

Really easy and straightforward. Perfection! Thanks so much

[@anayikathompson1548]

THANK YOU SO MUCH!! You saved my homework assignment

[@bidishamukherjee9221]

Thank you for being crisp and clear!

[@ki8q]

Thank you for the explanation so easy and straightforward 💜

[@andyhwell8419]

This video helps me more than my college professor. Thank you!

[@pHn121]

thanks a lot, you are a life saver!

[@dannyboi5360]

Nice straight to the point, easy to understand, great helping vid mate

[@salenaroberts837]

thank u so much sir, u saved me from doing so much work.

[@desish4181]

Thanks man for your video, people like you make life easy 😃

[@joaquinzannchez3184]

Thank you for a clear and to the point tutorial.

[@monserattacevedo7240]

This is awesome!!! Straight to the point.

[@انتصارالشرعبي-م4ط]

thanks allot the video was so helpful

[@SereneTai]

Thank you so much! Very helpful.

[@jackfrostjr.7976]

Thank you, you are my hero

[@drrgnx]

this saved my maths psmt tysm 😂😁

[@Sokeritoppavuori]

Thank you. This video is something Microsoft clearly can't do themshelves 😄

[@meenapatel1621]

Extremely concise and easy to follow, thank you!

[@sinalompange708]

Thank you so much for the help.

[@heronkulukul4156]

This helps a lot! Thank you

[@thembabhudulwayo7915]

Nice and easy...thanks for ur help

[@amieoerding7043]

this help me so much thank you

[@saduzi6498]

amazing. thank you !!

[@aneelalfatayri1599]

God bless your soul 🙏

[@chimaemeka4282]

God bless you

[@ghanisubhan8693]

Great sir

[@mehdihadibi4689]

Thanks a lot

[@chayanikagogoi640]

Bless you

[@jayceel251]

Thank you! I always forget

[@sarada6519]

Thanks alot it was so helpfull

[@TheHarryb]

Thanks a lot for the great explanation.

[@aidarbarca]

thank you very much

[@SantoshKumar-gg2sq]

thanks much Steve

[@tourismhotspots]

Nice video

[@mohammedalenezi1130]

Thank youuuu

[@jameskegrere2965]

Thank you.

[@ruiwang824]

Thank u so much sir, very good

[@medkwesiga6663]

Excellent!

[@cobracommander6420]

Thanks! Very helpful!

[@shalyMelb]

thank you so much very useful

[@widyaarista6823]

THANKYOUU!!

[@Eric-yu1ur]

Can you please show us how to create a logistic regression

[@jvngue]

Thanks fam

[@jaimedpcaus1]

Excellent! More pls.

[@rachaellacey254]

Thank you so much!!

[@clairej]

Thanks so much !!

[@Khania457]

Thanks

[@matthewroache1382]

Amazing

[@JasonActualization]

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.

[@luannatemples6586]

very helpful, thanks!!

[@stanfordtai2910]

good video there.... sorry I am curious about how to change r squared value to r value... thanks.

[@StevenBradburn]

Take the square root of R2 to get r

[@edwardslade8049]

Absolute genius !!!

[@TheJoshtheboss]

How to I extract or lookup or reference the equation, so I can work with it with other cell formulas.

[@stevenadelson8281]

i like your voice

[@okezie11]

i dont have half the settings pop that you do, how do i fix that?

[@sophiasanders8321]

I love u

[@boladenon]

Thanks man. Excel truly is great, but not very intuitive at first...

[@manalipatel8144]

How we can directly call the equation in the cell and put any value instead of X?

[@ironbeard4627]

Any way to copy that equation out of the box?

[@ljrocks1812]

The equation is just not selectable as a text box, is there any other way to move it.

[@gdmrhotshot3731]

thx, i forgot

[@anthonyfaiell3263]

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.

[@trevzeee]

same

[@mereyardak8574]

maybe new version...it sucks

[@anthonyfaiell3263]

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.

[@ayakhater6533]

2:19 the equation is not correct though, according to what excel calculated the y intercept is -79.599, which is clearly wrong, if you have a look at the graph (it should be around 48-something).

[@luisdimensity]

What is R^2? What does it mean in terms of the information provided?

[@SK-vy5qo]

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

[@cenyat2274]

None of these options show up… 😢

[@rickmoulikxia0448]

Same

[@ashathapa3844]

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

[@PiduguVijay]

Hi Can you make a video on ROC curve and AUC curve ? thanks

[@p.j.882]

Try using linest you get the same.

[@khollow24]

i was only given the regression equation

[@pascalblazer4557]

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

[@markwilliams3174]

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.

[@MrWilljthrill]

u da man

[@modibofomba7847]

Thanks a lot

[@demichau2775]

Thank you so much!

[@joanneoriordan595]

Thanks so much

[@word4482]

Thankyou

[@phoenixblack1220]

Thank you so much!!!