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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment