PDA

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: