Saturday, February 11, 2012

If Ashton, Bob, Carol, Diane, Edna, Fran, Gary, Hannah, Iris, Jack, Ken, Larry, Mary, Nancy, Orville, Peter,?

Quincy, Ralph, Sandra, Tori, Ursula, Victor, Wanda, Xavier, Yolanda, And Zelma make up all members of a population, create a random sample of 8 from the population. Describe how you created the example. (Now Im supposed to use a spreadsheet to figure this out, but Im having troubles on how to start so I was wondering is someone can show me how to answer this with a spreadsheet?)

If Ashton, Bob, Carol, Diane, Edna, Fran, Gary, Hannah, Iris, Jack, Ken, Larry, Mary, Nancy, Orville, Peter,?
assign a unique integer from 0 to 25 to each of them



use =int(rand()*26).



this takes the integral portion of the random number from 0 to 26.



it is almost impossible to get a rand() of 1 so it wont reach 26 exactly.



refresh this 8 times and take note of the result



or copy this to 7 other cells



each time you refresh [F9] you'll have a new (set of) sample(s)



hope this helps


No comments:

Post a Comment