Question
 | | | | | 
Nov 7, 2009, 02:20 PM
| | New Member  | | Join Date: Oct 2009 Location: UK
Posts: 12
| | | Statistic- Sample Variance
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
| | | | | | |
Answers
| | | | | |
Nov 7, 2009, 02:23 PM
|
#2
| | | Mathematics Expert
Join Date: Sep 2006 Location: Chaneysville, Pa.
Posts: 1,666
| Run it through a calculator, Excel, or something else that will calculate it fast. |
 | | | | | | | | | | | | |
Nov 7, 2009, 02:25 PM
|
#3
| | New Member
Join Date: Oct 2009 Location: UK
Posts: 12
| but how! | |
| | | | | | | | | | | | |
Nov 7, 2009, 02:30 PM
|
#4
| | New Member
Join Date: Oct 2009 Location: UK
Posts: 12
| there are many variance calculations in Exel. I dont know which one should I choose | |
| | | | | | | | | | | | |
Nov 7, 2009, 02:36 PM
|
#5
| | New Member
Join Date: Oct 2009 Location: UK
Posts: 12
| what is the equation that we have to use in this situation? | |
| | | | | | | | | | | | |
Nov 7, 2009, 03:40 PM
|
#6
| | | Mathematics Expert
Join Date: Sep 2006 Location: Chaneysville, Pa.
Posts: 1,666
| 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. | |
| | | | | | | | | | | | |
Nov 7, 2009, 07:24 PM
|
#7
| | Ultra Member
Join Date: Nov 2007 Location: Mauritius
Posts: 2,947
| There is a formula for variance that I know. }{n})
where v is variance;
x bar the mean
n the number of terms
x is the sum of terms | |
| | | | | | | | | | | | |
Nov 12, 2009, 07:48 PM
|
#8
| | Ultra Member
Join Date: Feb 2008 Location: USA
Posts: 3,683
| Actually, it's: ^2}{n-1}) | |
| | | | | | | | | | | | |
Nov 13, 2009, 02:10 AM
|
#9
| | Ultra Member
Join Date: Nov 2007 Location: Mauritius
Posts: 2,947
| Oops, correct, I forgot the squared part, I'm not used to stats yet... 
Now, just getting into grouped data, the formulae involved | |
| | | | | | | | | | | | |
Nov 14, 2009, 01:40 AM
|
#10
| | Ultra Member
Join Date: Feb 2008 Location: USA
Posts: 3,683
| That's OK. We'll forgive you... this time. :-) | |
| | | | | | | | Thread Tools | Search this Thread | | | | | Display Modes |  Linear Mode | Ask your question or search...
|
Search this Thread |
|
Bookmarks
| |
|
