二项分布,泊松分布,超几何分布

二项分布

发生次数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，累计)