Tag Archives for " random numbers "

2 Random numbers generator in Excel

Although Excel’s Data Analysis Toolpak can generate good random numbers, I had to create these various functions to meet my specific needs. First: Generating Unique Random Numbers This function was modified from ozgrid’s RandLotto function, which returns a string of numbers without duplicates. This function will return an array of unique random integers that are […]

Continue reading

2 Excel Exponential Distribution

Generating random numbers from the exponential distribution in Excel should not be such a difficult task, but the lack of a direct function does it make it difficult. In this post, you will see the steps to generate random numbers from the exponential distribution in Excel. Understanding Exponential Distribution The probably density function (PDF) of […]

Continue reading
>