Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Generating random numbers avec normal distribution in Excel

ayi

I want to produce 100 random numbers with normal distribution (with µ=10, σ=7) and then draw a quantity diagram for these numbers.
How can I produce random numbers with a specific distribution in Excel 2010?
One more question:
When I produce, for example, 20 random numbers with <code>RANDBETWEEN(Bottom,Top)</code>, the numbers change every time the sheet recalculates. How can I keep this from happening?

ayi_2

Use the <a href="https://support.office.com/en-us/article/norminv-function-87981ab8-2de0-4cb0-b1aa-e21d4cb879b8"><code>NORMINV</code></a> function together with <a href="https://support.office.com/en-ie/article/rand-function-4cbfa695-8869-4788-8d90-021ea9f5be73"><code>RAND()</code></a>:
<pre><code class="lang-auto">=NORMINV(RAND(),10,7)

</code></pre>
To keep your set of random values from changing, select all the values, copy them, and then paste (special) the values back into the same range.
Sample output (column A), 500 numbers generated with this formula: