Тёмный

Making Scatter Plots/Trendlines in Excel 

Подписаться
Просмотров 382 тыс.
% 1 193

The title says it all! Check out my Channel at www.burkeyacademy.com for more videos on Statistics and Economics.
If you like what I am doing, please consider supporting this effort on Patreon or buy me a cookie through PayPal!
www.patreon.com/burkeyacademy
paypal.me/BurkeyAcademy
www.burkeyacademy.com

Опубликовано:

 

2 сен 2016

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 59   
@liamzprobro8810
@liamzprobro8810 2 года назад
Right now im sitting in my room flat on my ass thinking about how long i had to do this maths assignment. Just when my hope had been drained i found you the key to impress my maths teachers, the key to boost my average. So for that thank you so much you beatiful specimen
@mollythompson936
@mollythompson936 4 года назад
these video tutorials really saved my bacon at work! Thanks for the tutorials
@letobg3166
@letobg3166 4 года назад
You instructions are so clear! Thank you very much.
@tonywheeler3993
@tonywheeler3993 6 лет назад
This video was very helpful! Thank you.
@TheJoshtheboss
@TheJoshtheboss 7 месяцев назад
Excellent video. Would love a longer one going s bit deeper into reading the patterns. Thanks.
@nimrahsaeed1211
@nimrahsaeed1211 6 лет назад
You sound like tom hanks
@pratik.y.mehta16
@pratik.y.mehta16 6 лет назад
Thankyou so much sir, this video was very much helpful for finishing my University homework
@sandeshratnayake9954
@sandeshratnayake9954 7 лет назад
Thankyou very much .... this video is very useful
@seshgalaga5482
@seshgalaga5482 2 года назад
Beautiful 😂🕺🏽I missed the due looking for this very video
@tiffaniet9601
@tiffaniet9601 7 лет назад
Whenever I choose a graph and click on it, it always show me a blank page/chart it annoys me so much and I try to put stuff in but I can only change the colour of the page....
@hugyourdata1549
@hugyourdata1549 2 года назад
Thanks! A great refresher for me b/c it has been a while...
@LAUGHTILLYOUWEE
@LAUGHTILLYOUWEE 3 года назад
This saved me for my school assessment
@ranjanjoseph8646
@ranjanjoseph8646 2 года назад
thank you, very informative.
@thomascho8975
@thomascho8975 4 года назад
When you plug it in, the left side becomes highlighted with purple, then the right side is blue (title is red). When I plug it into a scatterplot the points become highlighted horizontal purple and blue not vertically. For example, when I graph it, instead of getting all blue points, I get like 40 different colored points. Can someone tell me what I'm doing wrong.
@odariangule1367
@odariangule1367 3 года назад
Kazi safi bro
@julidanae6327
@julidanae6327 3 года назад
thank you!
@LynmanAlpha1
@LynmanAlpha1 2 года назад
I am making scatter graph but excel automatically sorts the data from highest to smallest, even though it is not what I want to show on the data. can you help me for that?
@MikeSong123
@MikeSong123 5 лет назад
Question: What if you want to know which car a particular dot is attributed to? So for example, can we add a label that somehow references the source of that data?
@BurkeyAcademy
@BurkeyAcademy 2 года назад
Sorry for the late reply- perhaps this will help someone. I have a couple of videos with ideas for that, though they might not be exactly what you need. 1) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jbv68cEEee8.html 2) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0B8NdIjpaX4.html
@woundedsoldier1766
@woundedsoldier1766 3 года назад
Thank you
@Remy.-
@Remy.- 3 года назад
I have a statistics exam in a few hours. Thanks dear sir
@BurkeyAcademy
@BurkeyAcademy 3 года назад
Good luck!
@yasirshakeer8004
@yasirshakeer8004 7 лет назад
hello sir ...please I have a question ...if I need to know the x and y for specific point in scatter and know the exact location of this point (x,y) like the row number and collum....how can I do this??
@BurkeyAcademy
@BurkeyAcademy 7 лет назад
I made a short video for you: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jbv68cEEee8.html
@DannyHaofan
@DannyHaofan 5 лет назад
thanks a lot
@ilketopaktas4066
@ilketopaktas4066 Год назад
I can not choose two columns that are not side by side with cmd+shift+ down arrow
@GL4SSHEART
@GL4SSHEART 3 года назад
This helps a ton!!! But I have a question(2 actually lol). How do you set this up if you’re doing the numbers by thousands. Do you turn it into a decimal? What equation would you use for this?
@BurkeyAcademy
@BurkeyAcademy 3 года назад
You can use any sized numbers... there is no reason to change them. Perhaps I don't understand the question?
@anushagoonasekera7856
@anushagoonasekera7856 7 лет назад
OMG u sound exactly like John Quiñones has anyone told u that 😱
@BurkeyAcademy
@BurkeyAcademy 7 лет назад
Heh. I could "do" his voice easily, but I usually get Tom Hanks. ☺
@emmanuelgaril3975
@emmanuelgaril3975 4 года назад
how do we edit the scale? I want to adjust the space between points in my scatter diagram
@BurkeyAcademy
@BurkeyAcademy 4 года назад
Right click on the x or y axis, click "Format Axis", and you will see the option there.
@refl3xpie560
@refl3xpie560 5 лет назад
I did what you did but i always got a plot with nothing on it
@berto_osorio_fl
@berto_osorio_fl 2 года назад
thank you :-)
@avirupdas1065
@avirupdas1065 3 года назад
can I please have the data set?
@jayibero382
@jayibero382 3 года назад
Goated
@deadastronaut2440
@deadastronaut2440 3 года назад
Does not work in my excel 2016, works perfectly in google sheets though
@MrRosssy
@MrRosssy 7 лет назад
You seem like you know what youre doing, how would i make a brinley plot in excel for age variation?
@BurkeyAcademy
@BurkeyAcademy 7 лет назад
I do know what I'm doing, but do not know what a Brinley Plot is. I looked at a few studies using them, but they weren't clear on it, either. If you are basically asking how to display two regression lines for two sets of data, that is not too difficult.
@MrRosssy
@MrRosssy 7 лет назад
Yes exactly im not sure how to do that
@BurkeyAcademy
@BurkeyAcademy 7 лет назад
OK, I'll try to make a quickie tomorrow for ya.
@MrRosssy
@MrRosssy 7 лет назад
Holy shit! Thank you so much!
@fredwooten14
@fredwooten14 5 лет назад
Can a shape be added? Example the USA country.
@BurkeyAcademy
@BurkeyAcademy 5 лет назад
Sure! Let me see if I can make a quick video about that.
@BurkeyAcademy
@BurkeyAcademy 5 лет назад
Here you go! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-__eknQQb5mc.html
@paulomarcelino7221
@paulomarcelino7221 3 года назад
do you have sir the data? so I can use it as a practice lesson? hoping for your favorable response Sir. Thanks, stay safe
@BurkeyAcademy
@BurkeyAcademy 3 года назад
It is on my website called 93cars2.xls
@paulomarcelino7221
@paulomarcelino7221 3 года назад
@@BurkeyAcademy can you have the link Sir? so I can go there by just clicking on it? ty
@savagehippy3834
@savagehippy3834 4 года назад
I don't have a design tab :(
@savagehippy3834
@savagehippy3834 4 года назад
and im on windows and the ctrl to select multiple doesnt work
@savagehippy3834
@savagehippy3834 4 года назад
i have a midterm due tomorrow #rip
@BurkeyAcademy
@BurkeyAcademy 4 года назад
Sorry dude! I wonder what version of Excel you are using? Looking at mine, it does look like they needlessly changed the menu names yet AGAIN. I guess I need to remake all these videos... Thanks for letting me know about it.
@user-zl8ou9re7j
@user-zl8ou9re7j 7 лет назад
r u Andrew FLOST? OH MY GOD!
@BurkeyAcademy
@BurkeyAcademy 7 лет назад
Never heard of him, but I'll check him out. I usually get Tom Hanks... ☺
@fatgoaly6787
@fatgoaly6787 4 года назад
No No No, you're all wrong, this is definitely Sal from Khan Academy
@BurkeyAcademy
@BurkeyAcademy 4 года назад
You caught me!
@bilgehanylmaz517
@bilgehanylmaz517 11 месяцев назад
bro why didnt you show putting multiple data on graph? You showed the same thing three times in different ways. Waste of time.
@BurkeyAcademy
@BurkeyAcademy 11 месяцев назад
I didn't show something this video didn't show because I have OTHER videos showing that.
@crushed_oreos
@crushed_oreos Месяц назад
the entitlement is crazy, go fuck off to a different video