RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY

[FARAZ QURESHI]

How can one derive a random number from a specifc array, for example a random
selection from {2, 4, 16, 256, 65536}

 

[Lars-Åke Aspelin]

How can one derive a random number from a specifc array, for example a random
selection from {2, 4, 16, 256, 65536}

Try this formula

=CHOOSE(RANDBETWEEN(1,5),2,4,16,256,65536)

Hope this helps / Lars-Åke

 

[Teethless mama]

=INDEX({2,4,16,256,65536},RANDBETWEEN(1,5))

 

[Bernd P]

=2^(2^INT(RND()*5))

Regards,
Bernd

 

[Sandy Mann]

=2^(2^INT(RND()*5))

Clever, I like it!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk

 

[Mike Middleton]

FARAZ QURESHI -

What is the probability for each of the five distinct values?

Or, are the five values equally-likely?

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel