"Rebekka-Marie" wrote:
Am Montag, 20. August 2012 19:08:54 UTC+2 schrieb joeu2004:
you might take a look at the RNGs provided with the
Data Analysis tools.
Alternatively, you can craft your own RNG using RND
and RANDBETWEEN functions.
[....]
This is exactly what I need. Could you explain to me
in further detail what to do for my case:
Total demand for 1 month: 150 units
Covariance: 0,5
- Distribute 80 units randomly over 30 cells.

I can probably help. But your terminology is unclear to me.

First, it is unclear which of the two alternative are "exactly what you
need". Did you look at the RNGs in the Data Analysis tools?

-----

Second, do you really mean "variance", not "covariance"? And do you really
mean "standard deviation", not "variance"?

"Covariance" is a measure of the relationship between two random variables.
That does not seem to be the case here. See the Excel Help page for COVAR.

It is not uncommon for people to misuse the term "variance" (var) when they
really mean "standard deviation" (sd). Technically, var is the square root
of sd. See the Excel Help pages for VARP and STDEVP.

Alternatively, perhaps you do not mean any of those statistical terms. It
is not uncommon for accountants, for example, to talk about "variance" when
they simply mean "variation" (difference).

-----

Third, I am confused by your two facts: 1 month demand of 150 units, versus
distributing 80 units over 30 cells.

I do not understand what a cell represents in terms of time: day; month;
something else?

-----

Finally, it is not sufficient to specify total units (80 or 150?),
variance(var = 0.5?), and number of samples (30 cells).

You also need to specify the expected distribution, for example: normal
(bell-shaped), uniform (probably not), poisson, etc?

For a normal distribution, we need to know an average per cell (month?) as
well as the variance or standard deviation.