Skewed Random Range in Google Sheets (RANDBETWEEN)

Google Sheets: RANDBETWEEN


We can achieve a random range of numbers in Google Sheets by using the RANDBETWEEN formula. The formula is quite simple to use. Just add your start range and your end range:

=RANDBETWEEN(start range, end range)

For example, if I want to get a random number between zero(o) and 60 I would do the following:


The result will provide a whole random number somewhere between these two and including these numbers.

If I were to repeat this formula over a reasonable sample, say 300 times, we should see a fairly even spread of numbers occurring a roughly the same frequency, just like in the graph below:

But what if we wanted to have fewer random numbers in our list at the lower or upper end or on both ends?

Continue reading “Skewed Random Range in Google Sheets (RANDBETWEEN)”