Excel: Graphing with separate Error Bars of Standard Deviation

Поділитися
Вставка
  • Опубліковано 3 жов 2024

КОМЕНТАРІ • 287

  • @alajononon
    @alajononon 5 років тому +60

    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  4 роки тому +37

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

    • @lindam8791
      @lindam8791 3 роки тому +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 3 роки тому +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. ua-cam.com/video/UTILC0vHux8/v-deo.html&feature=emb_title

    • @PeterStanley
      @PeterStanley  3 роки тому +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 роки тому +62

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

  • @TheLeeshylou
    @TheLeeshylou 7 років тому +71

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

    • @PeterStanley
      @PeterStanley  6 років тому +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  4 роки тому +4

      @@VikasSinghMinimalist Appreciate you saying that, cheers.

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

  • @ItzRanok_
    @ItzRanok_ 4 місяці тому +2

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

  • @jaegeriglesias
    @jaegeriglesias 8 років тому +14

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

    • @PeterStanley
      @PeterStanley  8 років тому +1

      +Antonio Jaeger thanks Antonio, much appreciated

  • @caterine4604
    @caterine4604 5 років тому +12

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

  • @laynie113
    @laynie113 5 місяців тому +1

    wow none of my profs ever taught me this THANK YOUUU

    • @PeterStanley
      @PeterStanley  5 місяців тому +1

      Glad this was helpful for you √

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

  • @MexicanDre
    @MexicanDre 3 місяці тому

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

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

  • @Charlie-vf8hw
    @Charlie-vf8hw 5 років тому +20

    Thank you so much John Stamos

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

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

  • @armanjalalipour9044
    @armanjalalipour9044 4 роки тому +3

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

  • @usmanakhtar4768
    @usmanakhtar4768 6 років тому +1

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

  • @nidiaburucamajano4367
    @nidiaburucamajano4367 6 років тому +2

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

    • @PeterStanley
      @PeterStanley  4 роки тому

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

  • @janemoraaprilia5809
    @janemoraaprilia5809 2 місяці тому

    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

  • @diyashajid3752
    @diyashajid3752 5 років тому +4

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

  • @shakyabhattacharjee9100
    @shakyabhattacharjee9100 3 роки тому +1

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

  • @rudranimukerji1685
    @rudranimukerji1685 11 місяців тому

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

  • @itaycohen9055
    @itaycohen9055 7 років тому +1

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

  • @nooshinshahbazi5616
    @nooshinshahbazi5616 5 років тому +2

    Thanks for your awesome explanation.

  • @umarabdulmutalib7637
    @umarabdulmutalib7637 4 роки тому +2

    Straight away and useful

  • @aishwaryapanchakshikar9937
    @aishwaryapanchakshikar9937 4 роки тому +2

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

  • @mochipepper
    @mochipepper 4 роки тому +1

    THanks so much for making this so simple to follow.

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

  • @maryc5905
    @maryc5905 4 роки тому +3

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

  • @rawan4297
    @rawan4297 3 роки тому +1

    This is more than helpful, thank you very much

  • @xvgx
    @xvgx Рік тому

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

  • @InoNOheart
    @InoNOheart 4 роки тому +1

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

  • @noellea1435
    @noellea1435 2 роки тому

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

  • @thek5593
    @thek5593 6 років тому +1

    I feel like you are a GENIUS right now

  • @mrpapadopoulos9033
    @mrpapadopoulos9033 4 роки тому +2

    YOU ARE MY SAVIOUR. Thank you, kind man.

  • @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  6 років тому

      Glad to know that this helped Muhammed. Cheers.

  • @semaniafefadja458
    @semaniafefadja458 8 місяців тому +1

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

    • @PeterStanley
      @PeterStanley  6 місяців тому

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

  • @hampshireoak
    @hampshireoak 5 років тому

    Very well done, Thank you Peter

  • @chloerainbow7810
    @chloerainbow7810 6 років тому +2

    Finally a clear explanation! thankyou so much!!

  • @coppercrusader6791
    @coppercrusader6791 5 років тому +1

    excellent stuff

  • @yaozhongsong4041
    @yaozhongsong4041 6 років тому +2

    Great video! Thanks a lot!

  • @salimkhoso7995
    @salimkhoso7995 3 роки тому +1

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

  • @kkrwazie
    @kkrwazie 5 років тому +2

    Thankyou for this, this will help me so much.

  • @SuperPintu2010
    @SuperPintu2010 5 років тому +1

    Very useful and easily illustrated. Thanks

  • @NicDufour7
    @NicDufour7 8 років тому +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

  • @oxidemuzik
    @oxidemuzik 8 місяців тому +1

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

    • @PeterStanley
      @PeterStanley  6 місяців тому

      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!

  • @abeerameen4832
    @abeerameen4832 5 років тому +2

    thank you very much thats real helpful

  • @callofduty_Moh
    @callofduty_Moh 3 роки тому

    Thank you Peter for this brief and clear explanation!

  • @jamieosorio3596
    @jamieosorio3596 5 років тому +1

    You seriously save lives, THANK U

  • @Supamancam
    @Supamancam 5 років тому +1

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

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

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

  • @CaptainCrunch7100
    @CaptainCrunch7100 6 років тому +3

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

  • @MrCityGaming
    @MrCityGaming 7 років тому +1

    Great help with an assignment good job!!

  • @jytan98
    @jytan98 3 роки тому +1

    straight forward and easy to understand. Thank you

  • @nairasahakyan2170
    @nairasahakyan2170 4 роки тому +3

    Thank you. It was very useful for me.

  • @milicatubic1092
    @milicatubic1092 3 роки тому +2

    this video was very helpful to me, thank you!

  • @dianaccalvo
    @dianaccalvo 5 років тому +2

    Extremely useful and to the point... thanks!

  • @Rainbowfire100
    @Rainbowfire100 7 років тому +3

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

  • @qingyu1080
    @qingyu1080 7 років тому

    Thanks a lot for posting. Very useful

  • @hassanm8675
    @hassanm8675 5 років тому +1

    excellent. Thank you

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

  • @mari-liiskotsar4448
    @mari-liiskotsar4448 4 роки тому +2

    Thanks a lot, very helpful!

  • @AnimeFan-zs2ed
    @AnimeFan-zs2ed 6 років тому +2

    Helped me with Management Skills Assignment!

  • @vhfamily
    @vhfamily 5 років тому +1

    you are an incredible teacher!!

  • @filipcerny5325
    @filipcerny5325 5 років тому

    Thank you! super helpful :)

  • @lesliesherman7834
    @lesliesherman7834 5 років тому +1

    So very helpful. Thank you.

  • @brunoramirez2602
    @brunoramirez2602 6 років тому +1

    Thanks, very clear

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

  • @ebrukuyumcusavan8900
    @ebrukuyumcusavan8900 4 роки тому +1

    Many thanks for this useful information

  • @leratosharonmphahlele8006
    @leratosharonmphahlele8006 4 роки тому +2

    this was super helpful. thank you

  • @toadstoolring
    @toadstoolring 6 років тому +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  4 роки тому

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

  • @nourelshahawy3662
    @nourelshahawy3662 4 роки тому +2

    Very helpful :) Thank you!!

  • @josuavantonder7447
    @josuavantonder7447 6 років тому +1

    Thank you, you were an amazing help!!!

  • @chrstina
    @chrstina 5 років тому +1

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

  • @tahinaakthar4826
    @tahinaakthar4826 8 років тому +2

    Made it look so easy! thank you so much.

  • @bobxu9367
    @bobxu9367 7 років тому

    Thank you so much! Very clear and precise !

  • @OuroMorpheus
    @OuroMorpheus 2 роки тому

    Very helpful, saved my butt today.

  • @DebalikasLife
    @DebalikasLife 3 роки тому

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

  • @carlosalan7
    @carlosalan7 8 років тому +1

    Thank you! super helpful!!

  • @edemeyo4796
    @edemeyo4796 6 років тому +2

    Thank you for this video. It helped me big time

  • @VikasSinghMinimalist
    @VikasSinghMinimalist 5 років тому +1

    EXTREMELY HELPFUL BRO. THANKS A TON

  • @kaysaysso
    @kaysaysso 2 роки тому

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

  • @tandty321
    @tandty321 2 роки тому

    Thank you so much you saved my life😭😭

  • @vestia8444
    @vestia8444 5 років тому +56

    didnt know iron man was making lessons

  • @rebecab.737
    @rebecab.737 5 років тому +1

    Clearly explained... Thanks a lot!

  • @Oiseau1
    @Oiseau1 2 роки тому +1

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

    • @PeterStanley
      @PeterStanley  2 роки тому

      Very happy to hear it helped - cheers.

  • @minalbhalerao
    @minalbhalerao 2 роки тому

    Thank you so much for this video. It was very helpful.

  • @naomi-ee-ee1197
    @naomi-ee-ee1197 4 роки тому +1

    LIFE SAVER Exactly what i need thanks! :D

  • @sefatergbashi
    @sefatergbashi 5 років тому +2

    Thank you Sir!

  • @sadraadineh2044
    @sadraadineh2044 6 років тому +2

    You're awesome man!! Thanks a lot

  • @massimobaldini5912
    @massimobaldini5912 8 років тому +1

    Great and clear video!

  • @nakubulwapreciouseditor3675
    @nakubulwapreciouseditor3675 7 років тому

    Thank you so much, it was helpfull

  • @muhammadsaad7480
    @muhammadsaad7480 5 років тому +3

    Excellent! you saved my ass. Cheers!!

  • @K.Frizzy
    @K.Frizzy 7 років тому +1

    Thanks!

  • @anythinggoes4588
    @anythinggoes4588 7 років тому +1

    Thanks for that!

  • @AussieManny
    @AussieManny 5 років тому +4

    Thank you, sir!

  • @sophiamartins3009
    @sophiamartins3009 7 років тому +2

    This video was so helpful! Thank you!

  • @AM07638
    @AM07638 6 років тому +1

    nicely explained 👌👌👌

  • @matthewbarrett5067
    @matthewbarrett5067 6 років тому +2

    This is so helpful thank you