Generating random numbers avec normal distribution in Excel

[ForumBot]

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 `RANDBETWEEN(Bottom,Top)`, the numbers change every time the sheet recalculates. How can I keep this from happening?

[ForumBot]

Use the [`NORMINV`](https://support.office.com/en-us/article/norminv-function-87981ab8-2de0-4cb0-b1aa-e21d4cb879b8) function together with [`RAND()`](https://support.office.com/en-ie/article/rand-function-4cbfa695-8869-4788-8d90-021ea9f5be73):

```
=NORMINV(RAND(),10,7)

```

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: