Ask Experts Questions for FREE Help !
Ask
    drfarah's Avatar
    drfarah Posts: 12, Reputation: 1
    New Member
    		  
    #1

    Nov 7, 2009, 03:20 PM
    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
    galactus's Avatar
    galactus Posts: 2,271, Reputation: 282
    Ultra Member
    		  
    #2

    Nov 7, 2009, 03:23 PM
    Run it through a calculator, Excel, or something else that will calculate it fast.
    drfarah's Avatar
    drfarah Posts: 12, Reputation: 1
    New Member
    		  
    #3

    Nov 7, 2009, 03:25 PM

    But how!
    drfarah's Avatar
    drfarah Posts: 12, Reputation: 1
    New Member
    		  
    #4

    Nov 7, 2009, 03:30 PM
    There are many variance calculations in Exel. I don't know which one should I choose
    drfarah's Avatar
    drfarah Posts: 12, Reputation: 1
    New Member
    		  
    #5

    Nov 7, 2009, 03:36 PM
    what is the equation that we have to use in this situation?
    galactus's Avatar
    galactus Posts: 2,271, Reputation: 282
    Ultra Member
    		  
    #6

    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's Avatar
    Unknown008 Posts: 8,076, Reputation: 723
    Uber Member
    		  
    #7

    Nov 7, 2009, 08:24 PM

    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
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
    		  
    #8

    Nov 12, 2009, 08:48 PM
    Actually, it's:
    Unknown008's Avatar
    Unknown008 Posts: 8,076, Reputation: 723
    Uber Member
    		  
    #9

    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's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
    		  
    #10

    Nov 14, 2009, 02:40 AM

    That's OK. We'll forgive you... this time. :-)
    Unknown008's Avatar
    Unknown008 Posts: 8,076, Reputation: 723
    Uber Member
    		  
    #11

    Nov 14, 2009, 07:37 AM

    :eek:
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Finding the F Statistic. [ 2 Answers ]

A study compares three population means. Three independent samples with 15 observations are each taken. The SSE = 1246 and the SST = 1600. What is the value of the F statistic? I have no idea how to do this problem. I do know the answer is 5.97 I just have no idea how to get that as an answer......

Statistic probability , etc. [ 1 Answers ]

1. If a set of measurement has a mean of 45 and a standard deviation 5, convert the value of X into standard units where X = 55. 2. A random sample of 250 working adults found that 37% access the Internet at work, 44% access Internet at home, and 21% access it at both work and home. What is...

In statistic, [ 1 Answers ]

How do you determine class width?

View more questions Search