|
楼主 |
发表于 2014-9-28 11:35
|
显示全部楼层
感觉测试结果(5千万爻测试)说明理论概率计算存在某种偏差,也可能是测试的数量仍不太够的原因,但值得再次重新检测思考!测试代码如下:- Option Explicit
- Public Sub gailv() '概率测试
- Dim t%, d%, r%, i&, j%, scs%, ys1%, ys2%, js(6 To 9), ti! '天、地、人、蓍草数、余数、计数
- ti = Timer
- For i = 1 To 50000000 '五千万爻测试
- scs = 49: r = 0
- Randomize
- For j = 1 To 3
- r = r + 1
- t = Int((scs - 1 - 1) * Rnd()) + 1
- d = scs - 1 - t
- ys1 = t Mod 4: If ys1 = 0 Then ys1 = 4
- ys2 = d Mod 4: If ys2 = 0 Then ys2 = 4
- t = t - ys1
- d = d - ys2
- r = r + ys1 + ys2
- scs = t + d
- Next j
- js(scs / 4) = js(scs / 4) + 1
- Next i
- Sheets("概率测试").Range("d2").Resize(4) = Application.Transpose(js)
- MsgBox Format(Timer - ti, "0.0000")
- End Sub
复制代码 |
|