Making Scatter Plots/Trendlines in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 พ.ย. 2024

ความคิดเห็น • 60

  • @liamzprobro8810
    @liamzprobro8810 2 ปีที่แล้ว +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

  • @nimrahsaeed1211
    @nimrahsaeed1211 6 ปีที่แล้ว +44

    You sound like tom hanks

  • @mollythompson936
    @mollythompson936 5 ปีที่แล้ว +2

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

  • @TheJoshtheboss
    @TheJoshtheboss 11 หลายเดือนก่อน

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

  • @capuchin581
    @capuchin581 หลายเดือนก่อน

    Very helpful and easy to follow

  • @Remy.-
    @Remy.- 3 ปีที่แล้ว

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

  • @seshgalaga5482
    @seshgalaga5482 2 ปีที่แล้ว

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

  • @LAUGHTILLYOUWEE
    @LAUGHTILLYOUWEE 3 ปีที่แล้ว

    This saved me for my school assessment

  • @MikeSong123
    @MikeSong123 5 ปีที่แล้ว +4

    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  3 ปีที่แล้ว

      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) th-cam.com/video/jbv68cEEee8/w-d-xo.html 2) th-cam.com/video/0B8NdIjpaX4/w-d-xo.html

  • @pratik.y.mehta16
    @pratik.y.mehta16 6 ปีที่แล้ว +4

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

  • @hugyourdata1549
    @hugyourdata1549 3 ปีที่แล้ว

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

  • @letobg3166
    @letobg3166 5 ปีที่แล้ว

    You instructions are so clear! Thank you very much.

  • @tiffaniet9601
    @tiffaniet9601 7 ปีที่แล้ว +2

    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....

  • @jmark0623-e
    @jmark0623-e 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?

  • @ilketopaktas4066
    @ilketopaktas4066 2 ปีที่แล้ว

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

  • @yasirshakeer8004
    @yasirshakeer8004 7 ปีที่แล้ว +3

    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 ปีที่แล้ว +2

      I made a short video for you: th-cam.com/video/jbv68cEEee8/w-d-xo.html

  • @anushagoonasekera7856
    @anushagoonasekera7856 7 ปีที่แล้ว +6

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

    • @BurkeyAcademy
      @BurkeyAcademy  7 ปีที่แล้ว +4

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

  • @odariangule1367
    @odariangule1367 4 ปีที่แล้ว

    Kazi safi bro

  • @tonywheeler3993
    @tonywheeler3993 6 ปีที่แล้ว +1

    This video was very helpful! Thank you.

  • @thomascho8975
    @thomascho8975 5 ปีที่แล้ว

    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.

  • @ranjanjoseph8646
    @ranjanjoseph8646 2 ปีที่แล้ว

    thank you, very informative.

  • @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.

  • @sandeshratnayake9954
    @sandeshratnayake9954 7 ปีที่แล้ว +1

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

  • @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

  • @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?

  • @woundedsoldier1766
    @woundedsoldier1766 4 ปีที่แล้ว

    Thank you

  • @avirupdas1065
    @avirupdas1065 4 ปีที่แล้ว

    can I please have the data set?

  • @refl3xpie560
    @refl3xpie560 5 ปีที่แล้ว

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

  • @julidanae6327
    @julidanae6327 3 ปีที่แล้ว

    thank you!

  • @fredwooten14
    @fredwooten14 6 ปีที่แล้ว

    Can a shape be added? Example the USA country.

    • @BurkeyAcademy
      @BurkeyAcademy  6 ปีที่แล้ว +1

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

    • @BurkeyAcademy
      @BurkeyAcademy  6 ปีที่แล้ว

      Here you go! th-cam.com/video/__eknQQb5mc/w-d-xo.html

  • @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!

  • @fatgoaly6787
    @fatgoaly6787 4 ปีที่แล้ว

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

  • @DannyHaofan
    @DannyHaofan 6 ปีที่แล้ว

    thanks a lot

  • @berto_osorio_fl
    @berto_osorio_fl 3 ปีที่แล้ว

    thank you :-)

  • @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.

  • @越今朝-s6e
    @越今朝-s6e 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... ☺

  • @jayibero382
    @jayibero382 3 ปีที่แล้ว

    Goated

  • @bilgehanylmaz517
    @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
      @BurkeyAcademy  ปีที่แล้ว +1

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

    • @crushed_oreos
      @crushed_oreos 5 หลายเดือนก่อน

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