二项分布
发生次数p={X=k}概率p={X<=k}概率p(k)概率实验次数
k P={X=k}P={X<=k}P q=1-p n
0.000000#NUM!#NUM!0.0015000.9985005000.000000
1.000000#NUM!#NUM!0.0015000.9985005000.000000
2.000000#NUM!#NUM!0.0015000.9985005000.000000
3.000000#NUM!#NUM!0.0015000.9985005000.000000
4.000000#NUM!#NUM!0.0015000.9985005000.000000
5.000000#NUM!#NUM!0.0015000.9985005000.000000
6.000000#NUM!#NUM!0.0015000.9985005000.000000
7.000000#NUM!#NUM!0.0015000.9985005000.000000
8.000000#NUM!#NUM!0.0015000.9985005000.000000
9.000000#NUM!#NUM!0.0015000.9985005000.000000
10.000000#NUM!#NUM!0.0015000.9985005000.000000泊松分布
k P={X=k}P={X<=k}P q=1-p n
0.0000000.0005530.0005530.0015000.9985005000.000000
1.0000000.0041480.0047010.0015000.9985005000.000000
2.0000000.0155550.0202570.0015000.9985005000.000000
3.0000000.0388890.0591450.0015000.9985005000.000000
4.0000000.0729160.1320620.0015000.9985005000.000000
5.0000000.1093750.2414360.0015000.9985005000.000000
6.0000000.1367180.3781550.0015000.9985005000.000000
7.0000000.1464840.5246390.0015000.9985005000.000000
8.0000000.1373290.6619670.0015000.9985005000.000000
9.0000000.1144400.7764080.0015000.9985005000.000000
10.0000000.0858300.8622380.0015000.9985005000.000000
11.0000000.0585210.9207590.0015000.9985005000.000000
12.0000000.0365750.9573340.0015000.9985005000.000000
13.0000000.0211010.9784350.0015000.9985005000.000000
14.0000000.0113040.9897400.0015000.9985005000.000000超几何分布:共N件产品,M件次品,取n件,取到k件次品的概率
公式求单个
K n N M HYPGEOMDIST(K,n,M,N)
0.00000030.000000100.00000010.0000000.022917
1.00000030.000000100.00000010.0000000.112708
2.00000030.000000100.00000010.0000000.237232
3.00000030.000000100.00000010.0000000.281163
4.00000030.000000100.00000010.0000000.207578
5.00000030.000000100.00000010.0000000.099637
6.00000030.000000100.00000010.0000000.031451
7.00000030.000000100.00000010.0000000.006438
8.00000030.000000100.00000010.0000000.000817
9.00000030.000000100.00000010.0000000.000058
10.00000030.000000100.00000010.0000000.000002
11.00000030.000000100.00000010.000000#NUM!
12.00000030.000000100.00000010.000000#NUM!
13.00000030.000000100.00000010.000000#NUM!
14.00000030.000000100.00000010.000000#NUM!
15.00000030.000000100.00000010.000000#NUM!
c(n,k)阶乘公式计算单个公式计算累计
c(n,k)BINOMDIST(K次数,N总数,P概率,0单个)BINOMDIST(K次数,N总数,P概率#NUM!0.0005500.000550
#NUM!0.0041310.004681
#NUM!0.0155120.020193
#NUM!0.0388220.059014
#NUM!0.0728560.131870
#NUM!0.1093610.241231
#NUM!0.1367700.378001
#NUM!0.1465830.524584
#NUM!0.1374350.662019
#NUM!0.1145180.776537
#NUM!0.0858630.862399
c(n,k)入POSSION(K次数,入值,0单个)POSSION(K次数,#NUM!7.5000000.0005530.000553
#NUM!7.5000000.0041480.004701
#NUM!7.5000000.0155550.020257
#NUM!7.5000000.0388890.059145
#NUM!7.5000000.0729160.132062
#NUM!7.5000000.1093750.241436
#NUM!7.5000000.1367180.378155
#NUM!7.5000000.1464840.524639
#NUM!7.5000000.1373290.661967
#NUM!7.5000000.1144400.776408
#NUM!7.5000000.0858300.862238
#NUM!7.5000000.0585210.920759
#NUM!7.5000000.0365750.957334
#NUM!7.5000000.0211010.978435
#NUM!7.5000000.0113040.989740
求累计
0.022917
0.135625
0.372857
0.654020
0.861598
0.961235
0.992686
0.999124
0.999998
1.000000 #NUM!
#NUM!
#NUM!
#NUM!
#NUM!
K次数,N总数,P概率,1累计)
次数,入值,0单
1,累计)