View Full Version : Statistic- Sample Variance
drfarah
Nov 7, 2009, 03:20 PM
Hello,,
Please I want to know the answer of this question:
Consider the following data set:
51,52,54,54,55,59,60,60,64,67,69,70,74,74,78,81,84 ,85,86,110
Calculate the Sample Variance
galactus
Nov 7, 2009, 03:23 PM
Run it through a calculator, Excel, or something else that will calculate it fast.
drfarah
Nov 7, 2009, 03:25 PM
But how!
drfarah
Nov 7, 2009, 03:30 PM
There are many variance calculations in Exel. I don't know which one should I choose
drfarah
Nov 7, 2009, 03:36 PM
what is the equation that we have to use in this situation?
galactus
Nov 7, 2009, 04:40 PM
Type your data into Excel in cells A1 to A20. Then, in some cell, type =VAR(A1:A20) and it should give it to you.
Unknown008
Nov 7, 2009, 08:24 PM
There is a formula for variance that I know.
v = \frac{\Sigma (x-\bar x)}{n}
where v is variance;
x bar the mean
n the number of terms
x is the sum of terms
morgaine300
Nov 12, 2009, 08:48 PM
Actually, it's:
var=\frac{\Sigma(x-\overline{x})^2}{n-1}
Unknown008
Nov 13, 2009, 03:10 AM
Oops, correct, I forgot the squared part, I'm not used to stats yet... :o
Now, just getting into grouped data, the formulae involved
morgaine300
Nov 14, 2009, 02:40 AM
That's OK. We'll forgive you... this time. :-)
Unknown008
Nov 14, 2009, 07:37 AM
:eek: