The All-Purpose Bryz/Goaltending Thread #7
View Single Post
01-11-2013, 12:13 PM
Join Date: Jul 2010
Originally Posted by
Just like when you use the SUM function, x:y means it sums every cell from x to y (it can even do matrices if, for example, you do a1 to b3 - it will sum a1-a3 and b1-b3). All of the math is built into the function already by Microsoft, so if, for example, you had 30 backup goalie numbers in cells A1-A30 you would type =STDEV(A1:A30) to calculate it. Likewise, if the numbers were in cells A1-A15 and B1-B15 then you would type =STDEV(A1:B15).
Btw, you can also define your own functions within excel (and MATLAB, C and pretty much every coding language other than hardware ones) into libraries if you truly don't believe the originators did it right (they did, though, just as a fyi) and re-use them later much the same way as the pre-defined ones in the software package.
If you do alot of Math, Science or Engineering I highly encourage you to learn Excel... it is a very underrated program. I used to do so much more in MATLAB until I learned Excel better and realized it was considerably easier and quicker for the simpler tasks.
thanks for the lesson
seriously i wish i know about this stuff sooner, i'm gonna be graduating with a BS in Biology and a minor in Cognitive Neuroscience after this up coming semester. i know the very basics of Excel (simple functions and making graphs ect.) but this would have saved me a lot of time over the past five years especially during my physics and genetics labs/lab reports.
i'm laughing but i want to cry on the inside.
View Public Profile
Find More Posts by FlyersFan61290