random number generator
In each cell: =INT(RAND()*4)+1
"johnny vino" wrote:
I'm trying to obtain the following:
A 30 column x 1000 row table of normal distribution of random item responses
ranging from 1-4.
I'm not sure how to control the "Normal" output of the # generator, and I
can't figure out how to generate only natural numbers (no decimals). I can
format the numbers to 0 decimal places, but the "truth" of the numberis still
listed as 3.1223.. which isn't a response option on my tests. (that's a joke)
|