丸子
|
性 別: 女
命中機率: 0%
註冊時間: 2009/07/01
總發文數: 8
總回應數: 136
手機號碼: 未驗證 |
|
| 發表於 2009/07/31 18:46 |
|
|
『下面就是公式了』
"中球數(a)"＊公式＊"組合數(b=C9取b)"＊連線數＊＊＊＊＊＊＊＊合計＊"中球數(a)"＊"未中數(c=9-a)"＊"單一組合機率(d=(1/4)的a次方*(3/4)的c次方)"
＊＊＊0 ＊1 ＊2 ＊3 ＊4 ＊5 ＊6 ＊8 ＊＊＊
0＊Ｃ9取0＊=COMBIN(9,A4) ＊1 ＊＊＊＊＊＊＊＊=SUM(D4:K4) ＊0＊=9-A4＊=POWER((1/4),A4)*POWER((3/4),N4)
1＊Ｃ9取1＊=COMBIN(9,A5) ＊9 ＊＊＊＊＊＊＊＊=SUM(D5:K5)＊1＊=9-A5＊=POWER((1/4),A5)*POWER((3/4),N5)
2＊Ｃ9取2＊=COMBIN(9,A6) ＊36 ＊＊＊＊＊＊＊＊=SUM(D6:K6)＊2＊=9-A6＊=POWER((1/4),A6)*POWER((3/4),N6)
3＊Ｃ9取3＊=COMBIN(9,A7) ＊76 ＊8 ＊＊＊＊＊＊＊=SUM(D7:K7)＊3＊=9-A7＊=POWER((1/4),A7)*POWER((3/4),N7)
4＊Ｃ9取4＊=COMBIN(9,A8) ＊78 ＊48 ＊＊＊＊＊＊＊=SUM(D8:K8)＊4＊=9-A8＊=POWER((1/4),A8)*POWER((3/4),N8)
5＊Ｃ9取5＊=COMBIN(9,A9) ＊28 ＊76 ＊22 ＊＊＊＊＊＊=SUM(D9:K9)＊5＊=9-A9＊=POWER((1/4),A9)*POWER((3/4),N9)
6＊Ｃ9取6＊=COMBIN(9,A10) ＊2 ＊20 ＊46 ＊16 ＊＊＊＊＊=SUM(D10:K10)＊6＊=9-A10＊=POWER((1/4),A10)*POWER((3/4),N10)
7＊Ｃ9取7＊=COMBIN(9,A11) ＊＊＊4 ＊18 ＊12 ＊2 ＊＊＊=SUM(D11:K11)＊7＊=9-A11＊=POWER((1/4),A11)*POWER((3/4),N11)
8＊Ｃ9取8＊=COMBIN(9,A12) ＊＊＊＊＊1 ＊4 ＊4 ＊＊=SUM(D12:K12)＊8＊=9-A12＊=POWER((1/4),A12)*POWER((3/4),N12)
9＊Ｃ9取9＊=COMBIN(9,A13) ＊＊＊＊＊＊＊＊1 ＊=SUM(D13:K13)＊9＊=9-A13＊=POWER((1/4),A13)*POWER((3/4),N13)
總計＊2的9次方＊=SUM(C4:C13) ＊230 ＊152 ＊72 ＊34 ＊13 ＊6 ＊4 ＊1 ＊512 ＊總計＊
"中球數(a)"＊公式＊"組合數(b=C9取b)"＊連線數機率＊＊＊＊＊＊＊＊合計
＊＊＊0 ＊1 ＊2 ＊3 ＊4 ＊5 ＊6 ＊8 ＊
0＊Ｃ9取0＊=COMBIN(9,A18) ＊=D4*$O4＊＊＊＊＊＊＊＊=SUM(D18:K18)
1＊Ｃ9取1＊=COMBIN(9,A19) ＊=D5*$O5＊＊＊＊＊＊＊＊=SUM(D19:K19)
2＊Ｃ9取2＊=COMBIN(9,A20) ＊=D6*$O6＊＊＊＊＊＊＊＊=SUM(D20:K20)
3＊Ｃ9取3＊=COMBIN(9,A21) ＊=D7*$O7＊=E7*$O7＊＊＊＊＊＊＊=SUM(D21:K21)
4＊Ｃ9取4＊=COMBIN(9,A22) ＊=D8*$O8＊=E8*$O8＊＊＊＊＊＊＊=SUM(D22:K22)
5＊Ｃ9取5＊=COMBIN(9,A23) ＊=D9*$O9＊=E9*$O9＊=F9*$O9＊＊＊＊＊＊=SUM(D23:K23)
6＊Ｃ9取6＊=COMBIN(9,A24) ＊=D10*$O10＊=E10*$O10＊=F10*$O10＊=G10*$O10＊＊＊＊＊=SUM(D24:K24)
7＊Ｃ9取7＊=COMBIN(9,A25) ＊＊＊=F11*$O11＊=G11*$O11＊=H11*$O11＊=I11*$O11＊＊＊=SUM(D25:K25)
8＊Ｃ9取8＊=COMBIN(9,A26) ＊＊＊＊＊=H12*$O12＊=I12*$O12＊=J12*$O12＊＊=SUM(D26:K26)
9＊Ｃ9取9＊=COMBIN(9,A27) ＊＊＊＊＊＊＊＊=K13*$O13＊=SUM(D27:K27)
總計＊2的9次方＊=SUM(C18:C27) ＊=SUM(D18:D27)＊=SUM(E18:E27)＊=SUM(F18:F27)＊=SUM(G18:G27)＊=SUM(H18:H27)＊=SUM(I18:I27)＊=SUM(J18:J27)＊=SUM(K18:K27)＊=SUM(L18:L27)
|
|
大樂透、威力彩、賓果賓果、今彩539、三星彩、四星彩 最新開獎號碼！
有給人眼花撩亂ㄉ感覺
LineID:@auzo
