Questions...Please Help!

[arc]

Hi,
When I use the random number generator, how can I get it to only generate whole numbers? Also, I have 200 columns and 1000 rows filled with numbers, how do I find the mean and standard deviation of all those numbers in a simple way? Thanks!

[Aladin Akyurek]

On 2002-05-10 01:58, arc wrote:
Hi,
When I use the random number generator, how can I get it to only generate whole numbers? Also, I have 200 columns and 1000 rows filled with numbers, how do I find the mean and standard deviation of all those numbers in a simple way? Thanks!

Try:

=RANDBETWEEN(1,100)

=INT(RAND()*100)

=AVERAGE(A1:E200)

will average the numbers in the range A1:E200.

Similarly,

=STDEV(A1:E200)

[arc]

Thanks! How can set a range for the RANDBETWEEN? I need it to fill A1:GR1000.

[eliW]

On 2002-05-10 02:24, arc wrote:
Thanks! How can set a range for the RANDBETWEEN? I need it to fill A1:GR1000.

Hi arc,
Try this from Toolbar:
Edit | GoTo | A1:GR1000
In the active cell (A1), enter =RANDBETWEEN(1,100)
Now press simultaniously: CTRL+ENTER
This action will fill all the cells with the formula.
Eli