Excel: Graphing with separate Error Bars of Standard Deviation

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

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

  • @alajononon
    @alajononon 5 ปีที่แล้ว +62

    Doing astrobiology work at NASA for my internship and this was sooooooo helpful thanks! No one taught us how to plot these. Just how to calculate STDEV and percent error.

    • @PeterStanley
      @PeterStanley  5 ปีที่แล้ว +38

      Well now I can say I helped someone at NASA... that's a first.

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

      Hi, this is the first time I've ever seen someone who is doing astrobiology at NASA. I cannot express how that's exactly my goal. I really, really want to be an astrobiologist and I'm limited in resources where I am. Do you have any tips? And if you don't mind, where did you go to university and what did you study? Thank you x

    • @alajononon
      @alajononon 4 ปีที่แล้ว +14

      @@lindam8791 Hi! I'm just finishing up an MS thesis in geosciences right now. For my undergrad I started out in biology classes and then switched to Biogeoscience which is a study of where biology and geology interact. I'm currently at the University of Tulsa and we don't have any kind of space themed program or much of a connection to NASA so where you go to college isn't a huge factor. The thing that helps is networking. My advisor is friends with a prominent astrobiologist at JPL. So I sent her an email expressing interest in an internship. When she got funding she sent me an invite. If you haven't started college, I do recommend looking for schools with space and astrobiology programs. But again it is not essential. You're just more likely to find the connections there. Much of it involves geochemistry because so much research shows that interactions between rock and water do lots of chemistry that can create organic molecules. So I recommend some sort of biology and geology background. Microbiology is really good because it's thought if we find anything it will be similar to that. Look up scientists in the field that are doing stuff that interests you and reach out to them. Do some preliminary research on what they do so you're not just saying HI I WANNA WORK AT NASA. You don't have to be an expert, It just helps to know what it is they do. I worked in a lab that ranged from freshmen that hardly knew anything. Ans that's fine. We're all there to learn. These folks are much more likely to extend an internship offer to someone who reaches out to them than going through the main system blind. That said, you should still apply for internships in the system. JPL and all of the NASA centers should have a website to apply. Wherever you go to college, let your professors know you are interested in research and that you are interested in astrobiology. They may be doing that kind of research or something that you can spin to be astrobiology related. Try to keep term projects and papers focused on that field if you have the option. That's all stuff you can put on a resume as experience. Look at what talks are happening on campus (I guess virtually, now). Scientists that do all kinds of things get invited to speak at colleges and you might get to see an astrobiologist speak. Speaking of, here is a link to my mentor on Nasa's astrobiology youtube channel. Check that out and don't be afraid to reach out to her. th-cam.com/video/UTILC0vHux8/w-d-xo.html&feature=emb_title

    • @PeterStanley
      @PeterStanley  4 ปีที่แล้ว +11

      @@alajononon I really appreciate you taking the time to write about your experience. This will hopefully inspire many others thinking about their next chapter in life. Thank you.

  • @TidesLive
    @TidesLive 4 ปีที่แล้ว +63

    Thanks John Stamos. Good to learn this new excel skill from you.

  • @TheLeeshylou
    @TheLeeshylou 7 ปีที่แล้ว +72

    THANK YOU. you have no idea how long I spent trying to do this.

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว +5

      happy to hear it saved you some time.

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

      same here .. it really useful, thankyou Mr Peter :)

    • @VikasSinghMinimalist
      @VikasSinghMinimalist 5 ปีที่แล้ว +1

      @@PeterStanley It is extremely simple and helpful brother. Thanks a lot

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

      @@VikasSinghMinimalist Appreciate you saying that, cheers.

  • @uhuihiuhuihi
    @uhuihiuhuihi 7 ปีที่แล้ว +50

    I've been up 2 days straight grinding out lab reports and assignments and still found this easy to understand. Solid tutorial, cheers.

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว +10

      Hope you are all done now and get some much needed sleep.

  • @mackenziefaller4370
    @mackenziefaller4370 4 ปีที่แล้ว +18

    AMAZING TUTORIAL. I HAVE BEEN TRYING TO DO THIS FOR THE PAST HOUR AND THIS IS THE ONLY VIDEO THAT SHOWED ME HOW TO DO IT. YOU ARE AN AMAZING PERSON AND I WILL THANK YOU FOR THE REST OF MY LIFE. sincerely, a struggling college student & your future doctor :)

    • @PeterStanley
      @PeterStanley  3 ปีที่แล้ว +2

      I'm glad this helped and I hope you are beyond the struggling stage and on to saving lives. We need you out there.

  • @AnimeUni-versed
    @AnimeUni-versed 5 ปีที่แล้ว +12

    You literally just saved my life. I wish I could like this a thousand times. Thank youuuu!

  • @lindsayrowland4098
    @lindsayrowland4098 2 ปีที่แล้ว +1

    I have been trying to figure out how to make separate error bars for each bar on my graphs for my entire freshman year of college. Did not realize all you had to do was select the values already in excel! Thank you so much.

  • @ItzRanok_
    @ItzRanok_ 7 หลายเดือนก่อน +2

    OMG THANK YOU, YOU JUST SAVED MY FINAL GRADE IN SCIENCE!

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

    Thank you so much to this guy. I was about to light myself on fire with how infuriating it was and how other videos were not helping. Big props to him I hope he has a peaceful life where no bad happens to him. Lots of Love to him!!!!!!!!! Peter Stanley the man you are.

  • @jaegeriglesias
    @jaegeriglesias 9 ปีที่แล้ว +14

    Thanks for the tutorial...way better than the official office support!

    • @PeterStanley
      @PeterStanley  8 ปีที่แล้ว +1

      +Antonio Jaeger thanks Antonio, much appreciated

  • @asifmangat
    @asifmangat 5 ปีที่แล้ว +13

    You saved my life I was failed in my PhD defence just because some graph were mixed with some stats error you are savage God bless you . I would love to take you on a dinner if you live in Sydney

  • @rudranimukerji1685
    @rudranimukerji1685 ปีที่แล้ว

    THANK YOU SO MUCH FOR THIS. LITERALLY STRUGGLED OVER THIS FOR 40 MINS.

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

    This is short and best tutorial i search google a lot now i can make my own error bars :)

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

    8 years later and I used this video for my nano materials research. Thanks for posting.

  • @maryc5905
    @maryc5905 4 ปีที่แล้ว +3

    THANK YOU!!!!!!!!!!!!!!!!!!!!! I've been searching for hours with no luck!!

  • @aishwaryapanchakshikar9937
    @aishwaryapanchakshikar9937 4 ปีที่แล้ว +2

    This makes SL Physics so much easier! This was super helpful thank you!

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

    Hi Mr. Stanley! Thank you for helping me with SD - even after 3 years of being your student at AISB

  • @armanjalalipour9044
    @armanjalalipour9044 5 ปีที่แล้ว +3

    Came here to learn about graphs, left feeling relaxed, easy and like I made a new friend

  • @nidiaburucamajano4367
    @nidiaburucamajano4367 6 ปีที่แล้ว +2

    THANK YOU!
    Struggled for a really long time trying to the horizontal bars!

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

      I struggled a bit in the video... but later realized you can also just click the horizontal bars and hit 'delete' on your keyboard.

  • @shakyabhattacharjee9100
    @shakyabhattacharjee9100 3 ปีที่แล้ว +1

    Thanks a lot, you are the first person who helped me get rid of the horizontal value

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

    After watching 5 videos, this was the only one that helped. Thank you!

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

    I could'nt find videos regarding this specific topic. Thank u very much! Helped me a lot

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

    currently writing my thesis and I've been struggling to make separate error bars for my chart... it's past midnight now and I just wanna say thank you sir for saving my life

  • @blissieee
    @blissieee 6 ปีที่แล้ว +9

    Thank you!! This whole video was so helpful for my biology lab :)

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

    you help me out for my IA and you are explained it better than my teacher Thank you so much!!!

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

    You just saved me from failing,.. thank YOU soooo much

  • @NicDufour7
    @NicDufour7 9 ปีที่แล้ว +2

    Thanks you so much ! I am just searching all day long to find this tool for one of my work and I was beginning to be frustrated about the new Excel. So... Thanks again ! you make my day :)

    • @PeterStanley
      @PeterStanley  8 ปีที่แล้ว

      +Nic Duff cheers Nic, happy that this was useful for you

  • @laynie113
    @laynie113 8 หลายเดือนก่อน +1

    wow none of my profs ever taught me this THANK YOUUU

    • @PeterStanley
      @PeterStanley  7 หลายเดือนก่อน +1

      Glad this was helpful for you √

  • @salimkhoso7995
    @salimkhoso7995 3 ปีที่แล้ว +1

    This is the best video I have ever seen regarding the data range and plotting in excel.
    Very well done

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

      I really appreciate that, thanks.

  • @Raiden_Amani
    @Raiden_Amani 4 ปีที่แล้ว +1

    5 years later, and it's still helpful. 👍🏾

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

      I initially made this for a few students who kept struggling on lab reports. So glad to know that it has helped so many out there.

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

    Thank you Peter for this brief and clear explanation!

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

    Thank you very much. It helped me to draw the error bars on line graph easily. Some other tutorials on youtube were confusing.

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว

      Glad to know that this helped Muhammed. Cheers.

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

    I feel like you are a GENIUS right now

  • @kittyforster1279
    @kittyforster1279 3 ปีที่แล้ว +1

    Thank you so much - I've struggled (for years!) with the simple task of getting the SEM bars to be showing accurately - rather than the same size error bar across all the bars!

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

      I had to reteach it to myself each year so figured I'd make the video once and for all. Glad it helped.

  • @chloerainbow7810
    @chloerainbow7810 6 ปีที่แล้ว +2

    Finally a clear explanation! thankyou so much!!

  • @Charlie-vf8hw
    @Charlie-vf8hw 5 ปีที่แล้ว +20

    Thank you so much John Stamos

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

    YOU ARE MY SAVIOUR. Thank you, kind man.

  • @oxidemuzik
    @oxidemuzik 11 หลายเดือนก่อน +1

    THANK YOU SO MUCH IT WAS HELPFUL IN MY BIOLOGY IA IN IB DP2

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

      Great to hear this. It's exactly what I made the video for (my IB Bio and ESS students doing the IA). Good luck on your upcoming exams!

  • @jamieosorio3596
    @jamieosorio3596 5 ปีที่แล้ว +1

    You seriously save lives, THANK U

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

    thank you john
    i am a chemist
    it was sooo helpful
    i did the same in libre calc (linux) by learning from your toturial🙏🏻

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

      That's great to hear that you translated it. Well done and glad it helped.

  • @mochipepper
    @mochipepper 4 ปีที่แล้ว +1

    THanks so much for making this so simple to follow.

  • @CaptainCrunch7100
    @CaptainCrunch7100 6 ปีที่แล้ว +3

    Very well made, it really helps seeing an example, thanks!

  • @StrLo
    @StrLo 8 ปีที่แล้ว +1

    This video is a big help for my biology investigation, Thanks!

    • @PeterStanley
      @PeterStanley  8 ปีที่แล้ว

      +Struan That's good to hear it helped. Thanks for saying thanks.

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

    Thank you so much! Your tutorial was really simple and easy to understand, and it cleared up a lot of confusion I had about this! You saved me so much time, thank you again!

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

      Great to hear it helped you, thanks for your comment.

  • @Supamancam
    @Supamancam 5 ปีที่แล้ว +1

    Great video, thanks for that. Works great in 2016 with very minor differences.

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

    you are an incredible teacher!!

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

    Extremely useful and to the point... thanks!

  • @SuperPintu2010
    @SuperPintu2010 5 ปีที่แล้ว +1

    Very useful and easily illustrated. Thanks

  • @InoNOheart
    @InoNOheart 4 ปีที่แล้ว +1

    Words cannot express my gratitude to you. Thank you though.

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

      very much appreciated, thank you.

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

    Thank you this video saved my life you are a beautiful soul

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว

      very kind of you. cheers.

  • @nooshinshahbazi5616
    @nooshinshahbazi5616 6 ปีที่แล้ว +2

    Thanks for your awesome explanation.

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

    Straight away and useful

  • @vestia8444
    @vestia8444 5 ปีที่แล้ว +57

    didnt know iron man was making lessons

  • @semaniafefadja458
    @semaniafefadja458 10 หลายเดือนก่อน +1

    Thanks man you're a hero. Legit I was gonna get a zero if u didnt come in very clutch 🙏🙏🙏

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

      Well done not getting that zero and putting time in to find a solution. You've got this!

  • @rawan4297
    @rawan4297 4 ปีที่แล้ว +1

    This is more than helpful, thank you very much

  • @jytan98
    @jytan98 4 ปีที่แล้ว +1

    straight forward and easy to understand. Thank you

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

    thank you so much for this simple and comprehensive video! love it!

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว

      You're very welcome. I'm happy to hear that it helped.

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

    Exactly what I needed (and more in fact). Thank you for this!

  • @chrstina
    @chrstina 5 ปีที่แล้ว +1

    this video saved my life!!! thank you so much!!!

  • @milicatubic1092
    @milicatubic1092 4 ปีที่แล้ว +2

    this video was very helpful to me, thank you!

  • @VikasSinghMinimalist
    @VikasSinghMinimalist 5 ปีที่แล้ว +1

    EXTREMELY HELPFUL BRO. THANKS A TON

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

      Cheers, I'm glad it helped

  • @nairasahakyan2170
    @nairasahakyan2170 4 ปีที่แล้ว +3

    Thank you. It was very useful for me.

  • @MrCityGaming
    @MrCityGaming 8 ปีที่แล้ว +1

    Great help with an assignment good job!!

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

    Thankyou for this, this will help me so much.

  • @AnimeFan-zs2ed
    @AnimeFan-zs2ed 6 ปีที่แล้ว +2

    Helped me with Management Skills Assignment!

  • @ebrukuyumcusavan8900
    @ebrukuyumcusavan8900 5 ปีที่แล้ว +1

    Many thanks for this useful information

  • @tahinaakthar4826
    @tahinaakthar4826 8 ปีที่แล้ว +2

    Made it look so easy! thank you so much.

  • @leratosharonmphahlele8006
    @leratosharonmphahlele8006 4 ปีที่แล้ว +2

    this was super helpful. thank you

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

    Thank you, you were an amazing help!!!

  • @rebecab.737
    @rebecab.737 5 ปีที่แล้ว +1

    Clearly explained... Thanks a lot!

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

    Very helpful, saved my butt today.

  • @qingyu1080
    @qingyu1080 7 ปีที่แล้ว

    Thanks a lot for posting. Very useful

  • @yaozhongsong4041
    @yaozhongsong4041 6 ปีที่แล้ว +2

    Great video! Thanks a lot!

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

    Thank you so much you saved my life😭😭

  • @lesliesherman7834
    @lesliesherman7834 5 ปีที่แล้ว +1

    So very helpful. Thank you.

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

    Thanks you sir.... pretty much useful

  • @Oiseau1
    @Oiseau1 3 ปีที่แล้ว +1

    Okayyyy very very gratefull for this tutorials, definetely save my life T_T

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

      Very happy to hear it helped - cheers.

  • @edemeyo4796
    @edemeyo4796 6 ปีที่แล้ว +2

    Thank you for this video. It helped me big time

  • @naomi-ee-ee1197
    @naomi-ee-ee1197 5 ปีที่แล้ว +1

    LIFE SAVER Exactly what i need thanks! :D

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

    Thank u it's really very helpful.i am from India West Bengal

  • @sadraadineh2044
    @sadraadineh2044 6 ปีที่แล้ว +2

    You're awesome man!! Thanks a lot

  • @massimobaldini5912
    @massimobaldini5912 8 ปีที่แล้ว +1

    Great and clear video!

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

    Very well done, Thank you Peter

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

    Very helpful :) Thank you!!

  • @bobxu9367
    @bobxu9367 7 ปีที่แล้ว

    Thank you so much! Very clear and precise !

    • @PeterStanley
      @PeterStanley  7 ปีที่แล้ว

      Appreciate it Bob, Cheers.

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

    nicely explained 👌👌👌

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

    Awesome! Please do a video on calculating the EC/IC50 too!

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

    You’ve saved me today was about to crash out

  • @abeerameen4832
    @abeerameen4832 6 ปีที่แล้ว +2

    thank you very much thats real helpful

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

    Thank you sir. Excellent video that was simple and to the point.

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

    This video was so helpful! Thank you!

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

    nice description !!!! Thanks..

  • @lostinthesauce9319
    @lostinthesauce9319 4 ปีที่แล้ว +3

    Thank you for saving me while I'm trying to do a last minute assignment at 3 am (sadly not joking, send help and coffee)

    • @PeterStanley
      @PeterStanley  4 ปีที่แล้ว +1

      We've all been there before. Hope it worked out.

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

    Thank you so much for your help. Great video - really clear!

  • @muhammadsaad7480
    @muhammadsaad7480 5 ปีที่แล้ว +3

    Excellent! you saved my ass. Cheers!!

  • @malaikak19
    @malaikak19 8 ปีที่แล้ว +2

    This was amazing, thank you!

    • @PeterStanley
      @PeterStanley  8 ปีที่แล้ว

      Really happy to hear it helped.

  • @nicosp4475
    @nicosp4475 4 ปีที่แล้ว +1

    thank you from 2020

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

      You are welcome from 2021 (I'm slow with replying)

  • @coppercrusader6791
    @coppercrusader6791 5 ปีที่แล้ว +1

    excellent stuff

  • @monikamakuszynska9349
    @monikamakuszynska9349 3 ปีที่แล้ว +1

    Good staff, thank you so much for posting :-).

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

    This helped me a lot, thanks!