Member of the Month

KilaTsunami
October, 2024

Online

Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!

HELP with Excel please!

profile picture
vinnyvan
Posts: 132 - Karma: 24
hey n.s. im writing my Lab Final for Biology right now and what i need to know is how to calculate the standard deviation( error bars for a graph) on excel. ive looked up how to do on like ask.com and yahooanswers and whatever but nobody can give the right way... im doing it for a bar graph like below. if you can help me out that would be awesome
[IMG]csupomona.edu/%7Ejcclark/classes/bio542l/graphics/g-error.gif[/IMG]
Apr 29 2009 2:26PM
0 0
profile picture
Tinga
Posts: 11349 - Karma: 2,333
this gave me some trouble last year too. so make your graph and make sure you have your standard deviation ready to go. after you have made your graph right click on the bars and go to format data and one of the tabs in that box should say something about error bars or something.
Apr 29 2009 2:39PM
0 0
profile picture
vinnyvan
Posts: 132 - Karma: 24
thanks that is definatly helpin. now i have a general idea, but to set up my standard deviation how do i do that.. i am pretty srue i have it set up wrong. in the above bar i have it set as stdev=(and my data as a whole) but that is not working.. haha we covered this stuff earlier in the lecture but we covered alot of stuff so i dont really remember haha. if u could help me with that that would be great too.
Apr 29 2009 2:58PM
0 0
profile picture
Tinga
Posts: 11349 - Karma: 2,333
=stdev(data) you were close
Apr 29 2009 3:01PM
0 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
winner
Apr 29 2009 3:27PM
0 0
profile picture
WoodwardCopper
Posts: 219 - Karma: 6,494
Yah exactly, just always remember that all of your Excel formulas have to start with =, that's how excel knows you are starting a formula
Apr 29 2009 3:47PM
0 0
profile picture
vinnyvan
Posts: 132 - Karma: 24
ahhhh thanks man. ya i just tried pluggin it all in as a whole.. got it now. thanks man
Apr 29 2009 4:03PM
0 0
All times are Eastern (-4)