How do you figure standard deviation and variance when you have a group or list of numbers.

gogosean

Do you need to show how you have done it by hand, or do you want an Excel solution?

The good news is, if you have to do it by hand, the Standard Deviation is simply the square root of the variance.


Let me know what kind of help you need.

NeedKarma

Here is a good explanation: Learn Standard Deviation tutorial, definition, example, formula

gogosean

If you need the notation explained, just let me know. Some people need a process map instead of a formula.

pawar_bb

in excel you can use function standard deviation and get answer in few seconds
variance is square of std deviation

csl8back

statsman

This page might help with calculating standard deviation:

Standard Deviation Example

sixsigmais

Use excel formula
=STDEV( numbers)