Random Number Generation Question...

K

Keith

I was wondering if anyone has an answer to this
question...

I am trying to build a probability model using the Random
Number function. I have built out a three column table
that displays random numbers in each. While I do want
random numbers assigned to each, they all need to add up
to 1 in terms of probability. Does anyone know how to use
the Random Number function while also overlaying another
rule that dicates probability for all three values across
the columns.

Any advice would help...

Thanks, Keith
 
P

Paul Corrado

If your random #'s are in A2 to C2 for example, in another 3 column table
off to the right you could use the formula

=A2/sum(a2:c2) =B2/sum(a2:c2) =c2/sum(a2:c2)

The sum of these three numbers would always = 1 or 100%

HTH

PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Numbers 1
Need formula to randomize employee numbers for history audits 1
random number generation help 3
Random Numbers 4
How to save random numbers? 3
Random Number Generation & VLOOKUP 4
Problem with SET & REF function 0
eliminate negative value from normal random number distribution 4

Top