正态分布累积函数.xls

一个求正太分布的程序

-6	9.90122e-010
-5.99	1.05294e-009
-5.98	1.11963e-009
-5.97	1.19043e-009
-5.96	1.26558e-009
-5.95	1.34535e-009
-5.94	1.43001e-009
-5.93	1.51984e-009
-5.92	1.61516e-009
-5.91	1.71629e-009
-5.9	1.82358e-009
-5.89	1.93738e-009
-5.88	2.05809e-009
-5.87	2.1861e-009
-5.86	2.32185e-009
-5.85	2.46579e-009
-5.84	2.61839e-009
-5.83	2.78017e-009
-5.82	2.95166e-009
-5.81	3.13342e-009
-5.8	3.32605e-009
-5.79	3.53018e-009
-5.78	3.74647e-009
-5.77	3.97563e-009
-5.76	4.21839e-009
-5.75	4.47554e-009
-5.74	4.7479e-009
-5.73	5.03635e-009
-5.72	5.3418e-009
-5.71	5.66523e-009
-5.7	6.00765e-009
-5.69	6.37016e-009
-5.68	6.75387e-009
-5.67	7.16001e-009
-5.66	7.58983e-009
-5.65	8.04467e-009
-5.64	8.52594e-009
-5.63	9.03512e-009
-5.62	9.57378e-009
-5.61	1.01436e-008
-5.6	1.07462e-008
-5.59	1.13836e-008
-5.58	1.20576e-008
-5.57	1.27702e-008
-5.56	1.35236e-008
-5.55	1.43202e-008
-5.54	1.51621e-008
-5.53	1.6052e-008
-5.52	1.69925e-008
-5.51	1.79863e-008
-5.5	1.90364e-008
-5.49	2.01459e-008
-5.48	2.13179e-008
-5.47	2.25559e-008
-5.46	2.38636e-008
-5.45	2.52445e-008
-5.44	2.67028e-008
-5.43	2.82426e-008
-5.42	2.98683e-008
-5.41	3.15845e-008
-5.4	3.33961e-008
-5.39	3.53082e-008
-5.38	3.73261e-008
-5.37	3.94555e-008
-5.36	4.17023e-008
-5.35	4.40729e-008
-5.34	4.65736e-008
-5.33	4.92115e-008
-5.32	5.19937e-008
-5.31	5.49279e-008
-5.3	5.80221e-008
-5.29	6.12846e-008
-5.28	6.47243e-008
-5.27	6.83504e-008
-5.26	7.21727e-008
-5.25	7.62014e-008
-5.24	8.04471e-008
-5.23	8.49212e-008
-5.22	8.96354e-008
-5.21	9.46021e-008
-5.2	9.98344e-008
-5.19	1.05346e-007
-5.18	1.11151e-007
-5.17	1.17264e-007
-5.16	1.23702e-007
-5.15	1.30481e-007
-5.14	1.37617e-007
-5.13	1.4513e-007
-5.12	1.53039e-007
-5.11	1.61362e-007
-5.1	1.70122e-007
-5.09	1.7934e-007
-5.08	1.8904e-007
-5.07	1.99244e-007
-5.06	2.0998e-007
-5.05	2.21272e-007
-5.04	2.33149e-007
-5.03	2.45639e-007
-5.02	2.58774e-007
-5.01	2.72585e-007
-5	2.87105e-007
-4.99	3.02369e-007
-4.98	3.18415e-007
-4.97	3.35279e-007
-4.96	3.53002e-007
-4.95	3.71626e-007
-4.94	3.91195e-007
-4.93	4.11755e-007
-4.92	4.33353e-007
-4.91	4.56041e-007
-4.9	4.7987e-007
-4.89	5.04895e-007
-4.88	5.31174e-007
-4.87	5.58766e-007
-4.86	5.87736e-007
-4.85	6.18147e-007
-4.84	6.5007e-007
-4.83	6.83575e-007
-4.82	7.18738e-007
-4.81	7.55636e-007
-4.8	7.94353e-007
-4.79	8.34972e-007
-4.78	8.77584e-007
-4.77	9.22282e-007
-4.76	9.69163e-007
-4.75	1.01833e-006
-4.74	1.06989e-006
-4.73	1.12394e-006
-4.72	1.18062e-006
-4.71	1.24004e-006
-4.7	1.30232e-006
-4.69	1.36759e-006
-4.68	1.436e-006
-4.67	1.50769e-006
-4.66	1.5828e-006
-4.65	1.6615e-006
-4.64	1.74394e-006
-4.63	1.83029e-006
-4.62	1.92073e-006
-4.61	2.01545e-006
-4.6	2.11464e-006
-4.59	2.2185e-006
-4.58	2.32723e-006
-4.57	2.44106e-006
-4.56	2.56021e-006
-4.55	2.68492e-006
-4.54	2.81543e-006
-4.53	2.952e-006
-4.52	3.0949e-006
-4.51	3.2444e-006
-4.5	3.4008e-006
-4.49	3.5644e-006
-4.48	3.73551e-006
-4.47	3.91445e-006
-4.46	4.10158e-006
-4.45	4.29724e-006
-4.44	4.5018e-006
-4.43	4.71564e-006
-4.42	4.93917e-006
-4.41	5.17279e-006
-4.4	5.41695e-006
-4.39	5.67209e-006
-4.38	5.93868e-006
-4.37	6.2172e-006
-4.36	6.50816e-006
-4.35	6.81208e-006
-4.34	7.12951e-006
-4.33	7.46102e-006
-4.32	7.8072e-006
-4.31	8.16865e-006
-4.3	8.54602e-006
-4.29	8.93997e-006
-4.28	9.35118e-006
-4.27	9.78037e-006
-4.26	1.02283e-005
-4.25	1.06957e-005
-4.24	1.11834e-005
-4.23	1.16922e-005
-4.22	1.2223e-005
-4.21	1.27766e-005
-4.2	1.33541e-005
-4.19	1.39563e-005
-4.18	1.45843e-005
-4.17	1.52391e-005
-4.16	1.59218e-005
-4.15	1.66335e-005
-4.14	1.73753e-005
-4.13	1.81484e-005
-4.12	1.89542e-005
-4.11	1.97938e-005
-4.1	2.06687e-005
-4.09	2.15802e-005
-4.08	2.25297e-005
-4.07	2.35188e-005
-4.06	2.45489e-005
-4.05	2.56217e-005
-4.04	2.67389e-005
-4.03	2.79021e-005
-4.02	2.91131e-005
-4.01	3.03738e-005
-4	3.1686e-005
-3.99	3.30518e-005
-3.98	3.44732e-005
-3.97	3.59523e-005
-3.96	3.74913e-005
-3.95	3.90925e-005
-3.94	4.07581e-005
-3.93	4.24907e-005
-3.92	4.42927e-005
-3.91	4.61668e-005
-3.9	4.81155e-005
-3.89	5.01418e-005
-3.88	5.22484e-005
-3.87	5.44383e-005
-3.86	5.67147e-005
-3.85	5.90806e-005
-3.84	6.15394e-005
-3.83	6.40944e-005
-3.82	6.67491e-005
-3.81	6.95072e-005
-3.8	7.23724e-005
-3.79	7.53486e-005
-3.78	7.84397e-005
-3.77	8.16499e-005
-3.76	8.49834e-005
-3.75	8.84446e-005
-3.74	9.2038e-005
-3.73	9.57684e-005
-3.72	9.96405e-005
-3.71	0.000103659
-3.7	0.00010783
-3.69	0.000112158
-3.68	0.000116649
-3.67	0.000121308
-3.66	0.000126141
-3.65	0.000131154
-3.64	0.000136353
-3.63	0.000141746
-3.62	0.000147337
-3.61	0.000153135
-3.6	0.000159146
-3.59	0.000165377
-3.58	0.000171836
-3.57	0.00017853
-3.56	0.000185467
-3.55	0.000192656
-3.54	0.000200105
-3.53	0.000207822
-3.52	0.000215816
-3.51	0.000224097
-3.5	0.000232673
-3.49	0.000241555
-3.48	0.000250753
-3.47	0.000260276
-3.46	0.000270135
-3.45	0.000280341
-3.44	0.000290906
-3.43	0.00030184
-3.42	0.000313156
-3.41	0.000324865
-3.4	0.000336981
-3.39	0.000349515
-3.38	0.000362482
-3.37	0.000375895
-3.36	0.000389767
-3.35	0.000404113
-3.34	0.000418948
-3.33	0.000434286
-3.32	0.000450144
-3.31	0.000466538
-3.3	0.000483483
-3.29	0.000500996
-3.28	0.000519095
-3.27	0.000537798
-3.26	0.000557122
-3.25	0.000577087
-3.24	0.000597711
-3.23	0.000619014
-3.22	0.000641016
-3.21	0.000663739
-3.2	0.000687202
-3.19	0.000711429
-3.18	0.00073644
-3.17	0.00076226
-3.16	0.000788912
-3.15	0.000816419
-3.14	0.000844806
-3.13	0.000874099
-3.12	0.000904323
-3.11	0.000935504
-3.1	0.000967671
-3.09	0.00100085
-3.08	0.00103507
-3.07	0.00107036
-3.06	0.00110675
-3.05	0.00114428
-3.04	0.00118296
-3.03	0.00122284
-3.02	0.00126394
-3.01	0.00130631
-3	0.00134997
-2.99	0.00139496
-2.98	0.00144131
-2.97	0.00148907
-2.96	0.00153826
-2.95	0.00158894
-2.94	0.00164113
-2.93	0.00169488
-2.92	0.00175022
-2.91	0.00180721
-2.9	0.00186588
-2.89	0.00192628
-2.88	0.00198844
-2.87	0.00205242
-2.86	0.00211827
-2.85	0.00218603
-2.84	0.00225574
-2.83	0.00232746
-2.82	0.00240124
-2.81	0.00247714
-2.8	0.00255519
-2.79	0.00263546
-2.78	0.002718
-2.77	0.00280287
-2.76	0.00289012
-2.75	0.00297982
-2.74	0.00307201
-2.73	0.00316677
-2.72	0.00326415
-2.71	0.00336421
-2.7	0.00346702
-2.69	0.00357265
-2.68	0.00368115
-2.67	0.00379261
-2.66	0.00390708
-2.65	0.00402463
-2.64	0.00414534
-2.63	0.00426928
-2.62	0.00439653
-2.61	0.00452715
-2.6	0.00466122
-2.59	0.00479883
-2.58	0.00494005
-2.57	0.00508495
-2.56	0.00523363
-2.55	0.00538617
-2.54	0.00554265
-2.53	0.00570315
-2.52	0.00586776
-2.51	0.00603657
-2.5	0.00620968
-2.49	0.00638717
-2.48	0.00656913
-2.47	0.00675566
-2.46	0.00694686
-2.45	0.00714281
-2.44	0.00734363
-2.43	0.00754941
-2.42	0.00776025
-2.41	0.00797626
-2.4	0.00819753
-2.39	0.00842418
-2.38	0.00865631
-2.37	0.00889403
-2.36	0.00913745
-2.35	0.00938669
-2.34	0.00964185
-2.33	0.00990305
-2.32	0.0101704
-2.31	0.0104441
-2.3	0.0107241
-2.29	0.0110106
-2.28	0.0113038
-2.27	0.0116038
-2.26	0.0119106
-2.25	0.0122244
-2.24	0.0125454
-2.23	0.0128737
-2.22	0.0132093
-2.21	0.0135525
-2.2	0.0139034
-2.19	0.0142621
-2.18	0.0146287
-2.17	0.0150034
-2.16	0.0153863
-2.15	0.0157776
-2.14	0.0161773
-2.13	0.0165857
-2.12	0.017003
-2.11	0.0174291
-2.1	0.0178644
-2.09	0.0183088
-2.08	0.0187627
-2.07	0.0192261
-2.06	0.0196992
-2.05	0.0201821
-2.04	0.0206751
-2.03	0.0211782
-2.02	0.0216916
-2.01	0.0222155
-2	0.0227501
-1.99	0.0232954
-1.98	0.0238517
-1.97	0.0244191
-1.96	0.0249978
-1.95	0.025588
-1.94	0.0261898
-1.93	0.0268034
-1.92	0.0274289
-1.91	0.0280665
-1.9	0.0287165
-1.89	0.0293789
-1.88	0.030054
-1.87	0.0307418
-1.86	0.0314427
-1.85	0.0321567
-1.84	0.0328841
-1.83	0.0336249
-1.82	0.0343794
-1.81	0.0351478
-1.8	0.0359303
-1.79	0.0367269
-1.78	0.0375379
-1.77	0.0383635
-1.76	0.0392039
-1.75	0.0400591
-1.74	0.0409295
-1.73	0.0418151
-1.72	0.0427162
-1.71	0.0436329
-1.7	0.0445654
-1.69	0.045514
-1.68	0.0464786
-1.67	0.0474597
-1.66	0.0484572
-1.65	0.0494715
-1.64	0.0505026
-1.63	0.0515507
-1.62	0.0526161
-1.61	0.0536989
-1.6	0.0547993
-1.59	0.0559174
-1.58	0.0570534
-1.57	0.0582076
-1.56	0.05938
-1.55	0.0605708
-1.54	0.0617802
-1.53	0.0630084
-1.52	0.0642555
-1.51	0.0655217
-1.5	0.0668072
-1.49	0.0681122
-1.48	0.0694367
-1.47	0.0707809
-1.46	0.0721451
-1.45	0.0735293
-1.44	0.0749337
-1.43	0.0763586
-1.42	0.0778039
-1.41	0.0792699
-1.4	0.0807567
-1.39	0.0822645
-1.38	0.0837934
-1.37	0.0853435
-1.36	0.086915
-1.35	0.0885081
-1.34	0.0901227
-1.33	0.0917592
-1.32	0.0934176
-1.31	0.095098
-1.3	0.0968006
-1.29	0.0985254
-1.28	0.100273
-1.27	0.102042
-1.26	0.103835
-1.25	0.10565
-1.24	0.107488
-1.23	0.109349
-1.22	0.111233
-1.21	0.11314
-1.2	0.11507
-1.19	0.117023
-1.18	0.119
-1.17	0.121001
-1.16	0.123024
-1.15	0.125072
-1.14	0.127143
-1.13	0.129238
-1.12	0.131357
-1.11	0.1335
-1.1	0.135666
-1.09	0.137857
-1.08	0.140071
-1.07	0.14231
-1.06	0.144572
-1.05	0.146859
-1.04	0.14917
-1.03	0.151505
-1.02	0.153864
-1.01	0.156248
-1	0.158655
-0.99	0.161087
-0.98	0.163543
-0.97	0.166023
-0.96	0.168528
-0.95	0.171056
-0.94	0.173609
-0.93	0.176186
-0.92	0.178786
-0.91	0.181411
-0.9	0.18406
-0.89	0.186733
-0.88	0.18943
-0.87	0.19215
-0.86	0.194894
-0.85	0.197662
-0.84	0.200454
-0.83	0.203269
-0.82	0.206108
-0.81	0.20897
-0.8	0.211855
-0.79	0.214764
-0.78	0.217695
-0.77	0.22065
-0.76	0.223627
-0.75	0.226627
-0.74	0.22965
-0.73	0.232695
-0.72	0.235762
-0.71	0.238852
-0.7	0.241964
-0.69	0.245097
-0.68	0.248252
-0.67	0.251429
-0.66	0.254627
-0.65	0.257846
-0.64	0.261086
-0.63	0.264347
-0.62	0.267629
-0.61	0.270931
-0.6	0.274253
-0.59	0.277595
-0.58	0.280957
-0.57	0.284339
-0.56	0.28774
-0.55	0.29116
-0.54	0.294599
-0.53	0.298056
-0.52	0.301532
-0.51	0.305026
-0.5	0.308538
-0.49	0.312067
-0.48	0.315614
-0.47	0.319178
-0.46	0.322758
-0.45	0.326355
-0.44	0.329969
-0.43	0.333598
-0.42	0.337243
-0.41	0.340903
-0.4	0.344578
-0.39	0.348268
-0.38	0.351973
-0.37	0.355691
-0.36	0.359424
-0.35	0.363169
-0.34	0.366928
-0.33	0.3707
-0.32	0.374484
-0.31	0.378281
-0.3	0.382089
-0.29	0.385908
-0.28	0.389739
-0.27	0.39358
-0.26	0.397432
-0.25	0.401294
-0.24	0.405165
-0.23	0.409046
-0.22	0.412936
-0.21	0.416834
-0.2	0.42074
-0.19	0.424655
-0.18	0.428576
-0.17	0.432505
-0.16	0.436441
-0.15	0.440382
-0.14	0.44433
-0.13	0.448283
-0.12	0.452242
-0.11	0.456205
-0.1	0.460172
-0.09	0.464144
-0.08	0.468119
-0.07	0.472097
-0.06	0.476078
-0.05	0.480061
-0.04	0.484047
-0.03	0.488033
-0.02	0.492022
-0.01	0.496011
0	0.5