Ask your own question, for FREE!
Statistics 17 Online
OpenStudy (andijo76):

three randomly selected households are surveyed. the numbers of people in the households are 1,3,8 assume that samples of size n =2 are randomly selelcted with replacement from the population of 1,3,8. Listed below are the nine different sampls 1,1 1,3 1,8 3,1 3,3 3,8 8,1 8,3 8,8 find the variance of each of the nine samples then summerize the sampling distribution of the variances in the format of a table representing the probability distribution of the distinct variance values s^2 Probability are 3,3 0 or 1 6.3 1 or 2 12.5 6.3 or 40.5 49 12.3 or 24.5

OpenStudy (anonymous):

Do you have Microsoft Excel on your computer?

OpenStudy (andijo76):

i dont know maybe i will check

OpenStudy (andijo76):

i do but i am not real good at using it

OpenStudy (anonymous):

okay well no worries, I'm here to help

OpenStudy (anonymous):

you can plug in all of the numbers each in separate boxes

OpenStudy (anonymous):

and then type =VAR and click on S for sample or P for population and highlight the numbers

OpenStudy (andijo76):

the probablilities or the 1-1 1-3 and so forth

OpenStudy (anonymous):

the 1,11,3 1, 83... so on

OpenStudy (anonymous):

The variance is the average of the squared differences from the mean. To get the variance, first calculate the difference from the mean for each sample number. Square each number then average the results.

OpenStudy (anonymous):

so do that for each section.

OpenStudy (andijo76):

down or straight across

OpenStudy (anonymous):

it doesn't matter

OpenStudy (anonymous):

as long as you separate the 9 different samples

OpenStudy (andijo76):

and you said to type VAR after the numbers correct

OpenStudy (anonymous):

in an empty box type =VAR and click on S or P depending on the question, in this question S

OpenStudy (andijo76):

i am going to post what i got to make sure i understand you

OpenStudy (andijo76):

OpenStudy (andijo76):

hope you can open it

OpenStudy (anonymous):

you didn't plug them in the right way, but here is a very helpful video that will help you throughout statistics using Excel http://www.youtube.com/watch?v=efdRmGqCYBk

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!