Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Probability

How to generate random number weighted probability in Excel

To generated a random number, weighted with a given probability, you can use a helper table together with a formula based on the RAND and MATCH functions. Formula =MATCH(RAND(),cumulative_probability) Explanation In the example shown, the formula in F5 is: =MATCH(RAND(),D$5:D$10) How this formula works This formula relies on the helper table visible in the range B4:D10. Column B contains the…