Pseudo Random Numbers Between Limits With Predetermined Average

[brondius]

Ok, so what I want to do is have a list of pseudo random numbers between limits.

I want the list length to be determined by a number in a cell. Let's say C1 = 30, and that's the amount of numbers in our list.
The limits for the list would be found in 2 other cells, upper and lower limits being C2 = 22 and C3 = 18 for this example.
I also want the average to be determined by a number in a cell, let's say C4 = 20.

I was thinking this could be done with a For loop and an Array somehow, but I can't figure out the logistics. Anyone got any ideas about this?

[Loganeb]

Hello brondius, and welcome to the forum.

Everything you described above would be simple to do except setting the average, in my limited knowledge. It almost sounds like some kind of genetic algorithm. If you can describe logically how you would go about setting the average on a list of 30 random numbers, between 18 and 22, to 20, then maybe the logic can be described.

[brondius]

Heck, I tried to do Solver to give me a set of numbers >= 18 and <= 22 and setting the average to 20, but it just gave me 20 the whole way. I'm also trying to get it to be in Integers, I forgot to mention that. But it being in integers isn't as important as getting the numbers in there.

[Loganeb]

Here you go:

Please Login or Register  to view this content.

[brondius]

Wow. That was phenomenal. I didn't think doing GoTo Rerun would work without taking a million years to recalculate.

You are the bomb.com.

[Loganeb]

Thanks!

It works well, but most likely that's because we're using integers. If we were to use random numbers to several decimel places, this would take a million years, lol!

If you could, mark this thread as SOLVED, we would appreciate it.

[brondius]

How do I do that, exactly?

[Loganeb]

Above your original post, you'll see something called "thread tools" under that dropdown, you should see an option to mark the thread as solved.