Hello everyone,
Is there a way to use the RANDBETWEEN function and add bias towards the upper or lower bounds? I have used formulas such as ROUND(100*(RAND()*RAND()),0) to give me a left biased distribution and ROUND(100*(1-RAND()*RAND()),0) to give me a left biased distribution. However, I haven't seen a marriage of these two concepts.
For my example, I am trying to fill up a spreadsheet with random customer data. One of the columns is CREDIT SCORE. For this application I would use RANDBETWEEN(500-800). But this will give me a very flat, unbiased distribution of numbers between 500-800. Ideally, I would like very few scores near 500 and many more scores towards 800.
Any help is greatly appreciated!
Is there a way to use the RANDBETWEEN function and add bias towards the upper or lower bounds? I have used formulas such as ROUND(100*(RAND()*RAND()),0) to give me a left biased distribution and ROUND(100*(1-RAND()*RAND()),0) to give me a left biased distribution. However, I haven't seen a marriage of these two concepts.
For my example, I am trying to fill up a spreadsheet with random customer data. One of the columns is CREDIT SCORE. For this application I would use RANDBETWEEN(500-800). But this will give me a very flat, unbiased distribution of numbers between 500-800. Ideally, I would like very few scores near 500 and many more scores towards 800.
Any help is greatly appreciated!