|
- UID
- 223353
- 帖子
- 253
- 主题
- 33
- 注册时间
- 2011-7-11
- 最后登录
- 2016-4-15
|
Just to help you out a little more. I would pick a standard dev of around 2%, with a mean of 1.2%. Recall that 67% of results are within 1 std dev of mean, 96-ish% are within 2. From your limited results above, I think you want 3% and -1% within the first deviation band, and probably <5% outside of 4% from mean.
Your excel formula is then: =NORMINV(rand(),0.012,0.02) for your simulation. |
|
发表于 2011-9-22 22:08
|