
- UID
- 223352
- 帖子
- 216
- 主题
- 39
- 注册时间
- 2011-7-11
- 最后登录
- 2013-8-23
|
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. |
|