The best clarification I can think of would be that before cells A1 through
A40 are populated with random integers between -6 to +14, I would want to
enter a single value (i.e., 4.2, 3.8, 4.9, etc.) as the goal for that range
to average after it is populated. I don't know the answer to the sampling
distribution question you posed.

"Tom Ogilvy" wrote:

does it have to be exactly 4.2 or do you want the numbers drawn from a
population that has an average of 4.2. What is the distribution you are
sampling from: Uniform, Normal, Triangular, Something else.

--
Regards,
Tom Ogilvy

"Steve C" wrote in message
...
I would like to have Excel generate a range of random integers in cells A1
to
A40 and have the final average of that entire range = 4.2 (or any numeric
value I stipulate). I also want to place a constraint on each cell; that
it
can only contain an integer and a minimum/maximum range of say, -6 to +14.
Is this possible? Thanks!

Steve C