验证二项分布逼近正态分布.pdf

5-1EXCEL

(1)SUMXMY2SUMXMY2(array_x,array_y)

Array_x

Array_y

(2)BINOMDISTBINOMDIST(number_s,trials,probability_s,cumulative)

number_strials

probability_scumulative

cumulativeTRUEnumber_sFALSE

number_s

(3)NORMDISTNORMDIST(x,mean,standard_dev,cumulative)

x

meanstandard_devcumulative

cumulativeTRUENORMDISTFALSE

1)5-1EXCEL

5-1

2)C3=C1*C2

3)C4=C3*(1-C2)

4)B6=BINOMDIST(A6,$C$1,$C$2,FALSE)

B7:B15

1

5)C6

=NORMDIST(A6,C$3,SQRT(C$4),FALSE)

C7:C15

6)D6=SUMXMY2(B6:B15,C6:C15)

5-1

0.000204023

7)B5:C155-2

5-2n=710100

8)C110B6:C6B7:C15

9)D6=SUMXMY2(B6:B15,C6:C15)

0.0000077575-2

10)C11008)9)

2.57984×10-075-2

n

2