在Excel中生成具有正态分布的随机数 [英] Generating random numbers with normal distribution in Excel
问题描述
我想产生100个具有正态分布(μ= 10,σ= 7)的随机数,然后为这些数字绘制数量图.
I want to produce 100 random numbers with normal distribution (with µ=10, σ=7) and then draw a quantity diagram for these numbers.
如何在Excel 2010中生成具有特定分布的随机数?
How can I produce random numbers with a specific distribution in Excel 2010?
另一个问题:
例如,当我用RANDBETWEEN(Bottom,Top)
生成20个随机数时,每次工作表重新计算时,数字都会改变.我怎样才能避免这种情况发生?
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?
推荐答案
使用 RAND()
:
=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.
样本输出(A列),使用以下公式生成了500个数字:
Sample output (column A), 500 numbers generated with this formula:
这篇关于在Excel中生成具有正态分布的随机数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!