20

I need to generate random numbers with following properties.

Min should be 200

Max should be 20000

Average(mean) is 500.

Optional: 75th percentile to be 5000

Definitely it is not uniform distribution, nor gaussian. I need to give some left skewness.

asked Mar 15, 2011 at 15:51
15
  • 2
    This is actually a delightful math problem. I think it has something to do with identifying a function whose integral over 0-300 matches its integral over 300-19800, but I don't know if I can get any further than that, myself! Commented Mar 15, 2011 at 16:05
  • 1
    @Richard: even better: there's enough info to define any number of distributions! ;-) Commented Mar 15, 2011 at 16:17
  • 1
    @Chuck: I can think of many uses of this that would not imply homework. It might be homework, but it can just as well not be. Commented Mar 15, 2011 at 16:22
  • 2
    @Chuck: a monte-carlo simulation for some behaviour that has been observed to show these properties when measured. Commented Mar 15, 2011 at 16:34
  • 1
    No this is not a homework. I am working on a prototype, that requires modeling such distribution. See for more info: wiki.mozilla.org/Socorro:ClientAPI Commented Mar 15, 2011 at 16:47

5 Answers 5

12

Java Random probably won't work because it only gives you normal(gaussian) distributions.

What you're probably looking for is an f distribution (see below). You can probably use the distlib library here and choose the f distribution. You can use the random method to get your random number.

enter image description here

answered Mar 15, 2011 at 16:00
Sign up to request clarification or add additional context in comments.

12 Comments

An F distribution is not bounded, so you'd have to truncate it to fit the requirements - and that would complictate the computation of the parameters.
@leonbloy true it is infinite and not bounded, but you could get the probability so small in the right tail that even if you did happen to get a number past the max value, you can just call it the max value. (if > max then max). If you have a better solution, I think you should put it in an answer rather than pointing out flaws in this solution which I believe is valid with a simple check. I'd like to hear what other people have/would do for the question asked.
` I think you should put it in an answer rather than pointing out flaws in this solution` Uh? Of course one MUST point out flaws or shortcomings in any answer here in SO, so that anyone (the OP or anyone) who is going to use it is aware! The goal here is not to compete, but to have a good repository of answers. It doesn't matter whether one has posted an answer of his own (which I have, BTW).
I see you posted an answer, which is good and an good answer. I just don't think a down vote for a simple truncation of an infinitely small upper value is warranted. There may be better solutions, which I think there probably are, but this one is not terrible with the caveat of upper bound truncation.
@Scott For the random function, though, don't you need to use an inverse function? As in, the inverse of the f distribution. From what little work I've done with random functions, that is what I had to find. In that case, you would need to look up the mathematics of the f distribution yourself and decide if it is easily invertible. If it is, easy. If it's not, you'll need to create large inverse tables from which you can determine the inverse function. Obviously, you can't write it for 0<x<1, so you'll need to pick an interval, say .001 and use extrapolation to fill in the holes
|
9

Say X is your target variable, lets normalize the range by doing Y=(X-200)/(20000-200). So now you want some Y random variable that takes values in [0,1] with mean (500-200)/(20000-200)=1/66.

You have many options, the most natural one seems to me a Beta distribution, Y ~ Beta(a,b) with a/(a+b) = 1/66 - you have an extra degree of freedom, which you can choose either to fit the last quartile requirement.

After that, you simply return X as Y*(20000-200)+200

To generate a Beta random variable, you can use Apache Commons or see here.

answered Jun 9, 2011 at 16:46

Comments

4

This may not be the answer you're looking for, but the specific case with 3 uniform distributions:

Uniform distributions (Ignore the numbers on the left, but it is to scale!)

public int generate() {
 if(random(0, 65) == 0) {
 // 50-100 percentile
 if(random(1, 13) > 3) {
 // 50-75 percentile
 return random(500, 5000);
 } else {
 // 75-100 percentile
 return random(5000, 20000);
 }
 } else {
 // 0-50 percentile
 return random(200, 500);
 }
}

How I got the numbers

First, the area under the curve is equal between 200-500 and 500-20000. This means that the height relationship is 300 * leftHeight == 19500 * rightHeight making leftHeight == 65 * rightHeight

This gives us a 1/66 chance to choose right, and a 65/66 chance to choose left.

I then made the same calculation for the 75th percentile, except the ratio was 500-5000 chance == 5000-20000 chance * 10 / 3. Again, this means we have a 10/13 chance to be in 50-75 percentile, and a 3/13 chance to be in 75-100.

Kudos to @Stas - I am using his 'inclusive random' function.

And yes, I realise my numbers are wrong as this method works with discrete numbers, and my calculations were continuous. It would be good if someone could correct my border cases.

answered Jun 10, 2011 at 8:55

Comments

3

You can have a function f working on [0;1] such as

Integral(f(x)dx) on [0;1] = 500
f(0) = 200
f(0.75) = 5000
f(1) = 20000

I guess a function of the form

f(x) = a*exp(x) + b*x + c

could be a solution, you just have to solve the related system.

Then, you do f(uniform_random(0,1)) and there you are !

answered Mar 16, 2011 at 8:48

Comments

0

Your question is vague as there are numerous random distributions with a given minimum, maximum, and mean.

Indeed, one solution among many is to choose max with probability (mean-min)/(max-min) and min otherwise. That is, this solution generates one of only two numbers — the minimum and the maximum.

The following is another solution.

The PERT distribution (or beta-PERT distribution) is designed to take a minimum and maximum and estimated mode. It's a "smoothed-out" version of the triangular distribution, and generating a random variate from that distribution can be implemented as follows:

startpt + (endpt - startpt) * 
 BetaDist(1.0 + (midpt - startpt) * shape / (endpt - startpt), 
 1.0 + (endpt - midpt) * shape / (endpt - startpt))

where—

  • startpt is the minimum,
  • midpt is the mode (not necessarily average or mean),
  • endpt is the maximum,
  • shape is a number 0 or greater, but usually 4, and
  • BetaDist(X, Y) returns a random variate from the beta distribution with parameters X and Y.

Given a known mean (mean), midpt can be calculated by:

3 * mean / 2 - (startpt + endpt) / 4
answered Jul 23, 2017 at 9:26

Comments

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.