



New Member


May 11, 2007, 06:46 PM


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



Junior Member


May 11, 2007, 07:26 PM


Originally Posted by garrett7115
How do you figure standard deviation and variance when you have a group or list of numbers.
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.



Uber Member


May 11, 2007, 07:29 PM





Junior Member


May 11, 2007, 07:32 PM


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



New Member


Jul 12, 2007, 09:11 PM


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



New Member


Jul 17, 2007, 07:16 PM


:eek:
Originally Posted by garrett7115
How do you figure standard deviation and variance when you have a group or list of numbers.



New Member


Aug 24, 2009, 03:19 AM


Use excel formula
=STDEV( numbers)



New Member


Feb 10, 2010, 03:20 PM


Originally Posted by 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.
I would like both an excel solution and a process map, if you please!



New Member


Feb 21, 2010, 11:29 AM


Excel (if your numbers are in cell A1 to A20): =stdev(A1:A20)
"By hand":
1) Find the mean (I will call this X)
2) For every number (Xi), calculate (Xi  X)^2 (that is, the difference between the number and the mean, squared. I will call this Z^2)
3) Sum up all Z^2 (I will call this Sum(Z^2))
4) Divide Sum(Z^2) with the number of numbers minus one (that is, if you have 50 numbers, divide by 49).
5) Take the squareroot of the value you get in step 4.
This is for what is called experimental standard deviation.



New Member


Feb 22, 2010, 05:28 AM


Originally Posted by sveegaard
Excel (if your numbers are in cell A1 to A20): =stdev(A1:A20)
"By hand":
1) Find the mean (I will call this X)
2) For every number (Xi), calculate (Xi  X)^2 (that is, the difference between the number and the mean, squared. I will call this Z^2)
3) Sum up all Z^2 (I will call this Sum(Z^2))
4) Divide Sum(Z^2) with the number of numbers minus one (that is, if you have 50 numbers, divide by 49).
5) Take the squareroot of the value you get in step 4.
This is for what is called experimental standard deviation.
Thank you very much, this should answer my problem :)



New Member


Aug 17, 2012, 11:04 PM


You can get clear idea from standard deviation tutorials.


Question Tools 
Search this Question 


Add your answer here.
Check out some similar questions!
Statistics standard deviation and mean
[ 1 Answers ]
A test consists of 80 multiple choice questions, each with five possible answers only one of which is correct. What is the mean and standard deviation of the number of correct answers
Standard Deviation
[ 3 Answers ]
The question reads, What is the standard deviation for the sample data below: 154,216,171,188,229,203,184,173,181,147
Round the answer to the nearest tenth.
I have done this several times but my answer keeps coming up wrong. Can anyone explain this to me>?
View more questions
Search
