0:57 Right-clicking the mouse shows up a pop-up window. But mine does not contain menu options such as "Add Data Labels", "Add Trendline", etc. Do I need to install an optional plug-ins?
THANK YOU! This is very clear and well-explained.But this is hugely awkward. Getting the Scatterplot IS a great idea BUT thie LINEST is so cryptic. Why dont you click "Data" (in the top lone) then the Data Analysis icon at the right? Then you can choose Regression which gives you a nice printout with the ANOVA table and without having to select "Ctrl+Shift+Enter" and type in SE etc? Maybe students find using "Data/Data Analysis" complicated.
To be fair, as a student, the data analysis icon was not originally added on my excel as I just right now had to look it up and add as a add-on, using your comment lol.
After entering LINEST for the given y, x columns... I then hightlight a group of cells (2 column wide by 5 rows deep) and finally highlight the entire formula in the command bar, before pressing CTRL-SHIFT-ENTER so that it treats returns an array of data in those cells. The problem is that the data that it shows is not exactly the same as the trendline equation shown on the scatter-chart! Why? And how would you programatically do the CTRL-SHIFT_ENTER?
hello, thanks for this video. I'm not sure if this is the best video but I need to know is how to best fit a set of measurements, for example if i measure the thickness of a table, if i take 10 points, probably two are out of the "optimal" measurement but the rest is "within" this optimal measurement then how can i change this measurement outputs for best fit and make everything within? For this example I'm trying to change the "Y" data. What i was thinking is to subtract the "slope" to every point and then redo the scatter? Thanks.
It's 4:57am. I've been doing this for hours and nobody has said the correct new keys for excel mac 2017... thank you. you just got me closer to getting some sleep
Thank you!
Thank you I really needed this clear explanation
Still useful after 10 years ^^
what do you mean when you say "Command" as the key stroke?
Thank you! Excellent!
매우 유용한 정보 감사합니다!
Great video!
0:57 Right-clicking the mouse shows up a pop-up window. But mine does not contain menu options such as "Add Data Labels", "Add Trendline", etc. Do I need to install an optional plug-ins?
it keeps giving me error, anybody know how to help me pls
Thank you!
Thank you so much!!!!
Good explanation. Thanx
grande bro
THANK YOU! This is very clear and well-explained.But this is hugely awkward. Getting the Scatterplot IS a great idea BUT thie LINEST is so cryptic. Why dont you click "Data" (in the top lone) then the Data Analysis icon at the right? Then you can choose Regression which gives you a nice printout with the ANOVA table and without having to select "Ctrl+Shift+Enter" and type in SE etc? Maybe students find using "Data/Data Analysis" complicated.
To be fair, as a student, the data analysis icon was not originally added on my excel as I just right now had to look it up and add as a add-on, using your comment lol.
Thank you
Jared, Me again. You have failed me. I am sobbing crying. where is the standard deviation. please.
After entering LINEST for the given y, x columns... I then hightlight a group of cells (2 column wide by 5 rows deep) and finally highlight the entire formula in the command bar, before pressing CTRL-SHIFT-ENTER so that it treats returns an array of data in those cells. The problem is that the data that it shows is not exactly the same as the trendline equation shown on the scatter-chart! Why? And how would you programatically do the CTRL-SHIFT_ENTER?
Check whether you've select the same number of data values. It's easy to miss a row.
I very Confused because my physics task, but this video very help me
thank You
Still useful after 8 years ❤️🌹
YOUR AMAZINGGGGG
Thank you! Still helping Physics students 11 years to the date!!!
Thanks for the video, it's really helped me to get an uni assessment in on time.
I’m Jared ;-;
you super men. I lavyou
7 years later... LIFE SAVER!
just saved my assigment dude
hello, thanks for this video. I'm not sure if this is the best video but I need to know is how to best fit a set of measurements, for example if i measure the thickness of a table, if i take 10 points, probably two are out of the "optimal" measurement but the rest is "within" this optimal measurement then how can i change this measurement outputs for best fit and make everything within? For this example I'm trying to change the "Y" data. What i was thinking is to subtract the "slope" to every point and then redo the scatter? Thanks.
Very very nice
WOW DUDE THANK YOU
He sound exactly like Zach Galifiniakis
Thanks!
Thank you!
Bless you child. This was a much needed information.
you deserve a place in heaven, my child
thanks
thanks! this is so helpful!
so helpful, thanks!
Wow, you just saved me so much time haha! Thankyou!
Still a great tutorial!
Godlike Voice
You saved me
You're the best! Thank you!
for excel 2017, you have to hold down shift+control then press enter
It's 4:57am. I've been doing this for hours and nobody has said the correct new keys for excel mac 2017... thank you. you just got me closer to getting some sleep
No problem :) struggling student myself and I thought someone would run into the same problem as me
Careful, he's a hero
i love u
God bless you!
thanks!
Thank you! This helped a lot with my assignment
Bro you are Pro. That's what I thank you for.
Lowkey youtube mvp
I am a more complete person after watching this
Thank you for your help :)