Making Scatter Plots/Trendlines in Excel

[@liamzprobro8810]

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]

these video tutorials really saved my bacon at work! Thanks for the tutorials

[@nimrahsaeed1211]

You sound like tom hanks

[@TheJoshtheboss]

Excellent video. Would love a longer one going s bit deeper into reading the patterns. Thanks.

[@capuchin581]

Very helpful and easy to follow

[@pratik.y.mehta16]

Thankyou so much sir, this video was very much helpful for finishing my University homework

[@LAUGHTILLYOUWEE]

This saved me for my school assessment

[@MikeSong123]

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]

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) kzbin.info/www/bejne/oJPZZ2uZeqqYm5o 2) kzbin.info/www/bejne/ZnObf5d_n9WUjpY

[@seshgalaga5482]

Beautiful 😂🕺🏽I missed the due looking for this very video

[@Remy.-]

I have a statistics exam in a few hours. Thanks dear sir

[@BurkeyAcademy]

Good luck!

[@letobg3166]

You instructions are so clear! Thank you very much.

[@tiffaniet9601]

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]

Thanks! A great refresher for me b/c it has been a while...

[@yasirshakeer8004]

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]

I made a short video for you: kzbin.info/www/bejne/oJPZZ2uZeqqYm5o

[@ranjanjoseph8646]

thank you, very informative.

[@tonywheeler3993]

This video was very helpful! Thank you.

[@ilketopaktas4066]

I can not choose two columns that are not side by side with cmd+shift+ down arrow

[@jmark0623-e]

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?

[@sandeshratnayake9954]

Thankyou very much .... this video is very useful

[@woundedsoldier1766]

Thank you

[@thomascho8975]

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]

Kazi safi bro

[@paulomarcelino7221]

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]

It is on my website called 93cars2.xls

[@paulomarcelino7221]

@@BurkeyAcademy can you have the link Sir? so I can go there by just clicking on it? ty

[@emmanuelgaril3975]

how do we edit the scale? I want to adjust the space between points in my scatter diagram

[@BurkeyAcademy]

Right click on the x or y axis, click "Format Axis", and you will see the option there.

[@avirupdas1065]

can I please have the data set?

[@GL4SSHEART]

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]

You can use any sized numbers... there is no reason to change them. Perhaps I don't understand the question?

[@julidanae6327]

thank you!

[@fredwooten14]

Can a shape be added? Example the USA country.

[@BurkeyAcademy]

Sure! Let me see if I can make a quick video about that.

[@BurkeyAcademy]

Here you go! kzbin.info/www/bejne/lZDInKGHhsdoo8U

[@anushagoonasekera7856]

OMG u sound exactly like John Quiñones has anyone told u that 😱

[@BurkeyAcademy]

Heh. I could "do" his voice easily, but I usually get Tom Hanks. ☺

[@refl3xpie560]

I did what you did but i always got a plot with nothing on it

[@MrRosssy]

You seem like you know what youre doing, how would i make a brinley plot in excel for age variation?

[@BurkeyAcademy]

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]

Yes exactly im not sure how to do that

[@BurkeyAcademy]

OK, I'll try to make a quickie tomorrow for ya.

[@MrRosssy]

Holy shit! Thank you so much!

[@berto_osorio_fl]

thank you :-)

[@deadastronaut2440]

Does not work in my excel 2016, works perfectly in google sheets though

[@savagehippy3834]

I don't have a design tab :(

[@savagehippy3834]

and im on windows and the ctrl to select multiple doesnt work

[@savagehippy3834]

i have a midterm due tomorrow #rip

[@BurkeyAcademy]

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.

[@DannyHaofan]

thanks a lot

[@jayibero382]

Goated

[@fatgoaly6787]

No No No, you're all wrong, this is definitely Sal from Khan Academy

[@BurkeyAcademy]

You caught me!

[@越今朝-s6e]

r u Andrew FLOST? OH MY GOD!

[@BurkeyAcademy]

Never heard of him, but I'll check him out. I usually get Tom Hanks... ☺

[@bilgehanylmaz517]

bro why didnt you show putting multiple data on graph? You showed the same thing three times in different ways. Waste of time.

[@BurkeyAcademy]

I didn't show something this video didn't show because I have OTHER videos showing that.

[@crushed_oreos]

the entitlement is crazy, go fuck off to a different video