On Thursday, May 28, 2015 at 9:57:27 AM UTC-4, Haas wrote:
I am trying to create a model in Excel to spit out a number based on a computing probabilities associated with outcomes. An example would be best:

Numbers Probability of occurring
1-10 5%
11-20 10%
21-60 65%
61-85 15%
86-100 5%

So, based on above, numbers from 21 to 60 have the highest probability of occurring in a large trial run. What I'd want to do is have a column with 10,000 cells going down, each spitting out any of the numbers above based on probability of occurring and then take an average of the 10,000 cells. Is there a Random function which would generate a number based on the likelihood of it occurring as per above table?

Thanks!

Thank you all - the solutions were all helpful and I've learned something from each of you so thanks!