Random Numbers

[krisinvincible]

Hi Guys,

How to generate 2 random numbers at the same time whose difference lies in a
given range.

For example,
generate a set of 2 random numbers a,b such that .45 <= (b-a) < = .60

 

[Barb Reinhardt]

I can help you come up with a random # that is between the two, but you'll
have to figure out how to get a difference between .45 and .60

You'll have to enable the Analysis Tool Pack

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions in the setup program

You can use =RANDBETWEEN(45,60)/100

 

[Stan Brown]

Mon, 16 Apr 2007 17:36:00 -0700 from krisinvincible

Hi Guys,

How to generate 2 random numbers at the same time whose difference lies in a
given range.

For example,
generate a set of 2 random numbers a,b such that .45 <= (b-a) < = .60

Hint: generate a, then generate b as a + .45 + (random 0 to .15).