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

Run it through a calculator, Excel, or something else that will calculate it fast.

But how!

There are many variance calculations in Exel. I don't know which one should I choose

what is the equation that we have to use in this situation?

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.

There is a formula for variance that I know.



where v is variance;
x bar the mean
n the number of terms
x is the sum of terms

Actually, it's:

Oops, correct, I forgot the squared part, I'm not used to stats yet... :o

Now, just getting into grouped data, the formulae involved

That's OK. We'll forgive you... this time. :-)

:eek: