正态分布累积函数1.xls

一个求正太分布的程序

-6	9.90E-10	9.86588E-10
-5.99	1.05E-09	1.04921E-09
-5.98	1.12E-09	1.11569E-09
-5.97	1.19E-09	1.18627E-09
-5.96	1.27E-09	1.26119E-09
-5.95	1.35E-09	1.34071E-09
-5.94	1.43E-09	1.42511E-09
-5.93	1.52E-09	1.51467E-09
-5.92	1.62E-09	1.60971E-09
-5.91	1.72E-09	1.71054E-09
-5.9	1.82E-09	1.81751E-09
-5.89	1.94E-09	1.93098E-09
-5.88	2.06E-09	2.05133E-09
-5.87	2.19E-09	2.17898E-09
-5.86	2.32E-09	2.31434E-09
-5.85	2.47E-09	2.45787E-09
-5.84	2.62E-09	2.61004E-09
-5.83	2.78E-09	2.77137E-09
-5.82	2.95E-09	2.94238E-09
-5.81	3.13E-09	3.12364E-09
-5.8	3.33E-09	3.31575E-09
-5.79	3.53E-09	3.51932E-09
-5.78	3.75E-09	3.73503E-09
-5.77	3.98E-09	3.96358E-09
-5.76	4.22E-09	4.2057E-09
-5.75	4.48E-09	4.46217E-09
-5.74	4.75E-09	4.73383E-09
-5.73	5.04E-09	5.02153E-09
-5.72	5.34E-09	5.3262E-09
-5.71	5.67E-09	5.64881E-09
-5.7	6.01E-09	5.99037E-09
-5.69	6.37E-09	6.35197E-09
-5.68	6.75E-09	6.73474E-09
-5.67	7.16E-09	7.13988E-09
-5.66	7.59E-09	7.56865E-09
-5.65	8.04E-09	8.02239E-09
-5.64	8.53E-09	8.50251E-09
-5.63	9.04E-09	9.01048E-09
-5.62	9.57E-09	9.54787E-09
-5.61	1.01E-08	1.01163E-08
-5.6	1.07E-08	1.07176E-08
-5.59	1.14E-08	1.13535E-08
-5.58	1.21E-08	1.20259E-08
-5.57	1.28E-08	1.2737E-08
-5.56	1.35E-08	1.34887E-08
-5.55	1.43E-08	1.42835E-08
-5.54	1.52E-08	1.51236E-08
-5.53	1.61E-08	1.60115E-08
-5.52	1.70E-08	1.695E-08
-5.51	1.80E-08	1.79417E-08
-5.5	1.90E-08	1.89896E-08
-5.49	2.01E-08	2.00967E-08
-5.48	2.13E-08	2.12663E-08
-5.47	2.26E-08	2.25018E-08
-5.46	2.39E-08	2.38067E-08
-5.45	2.52E-08	2.51849E-08
-5.44	2.67E-08	2.66403E-08
-5.43	2.82E-08	2.8177E-08
-5.42	2.99E-08	2.97995E-08
-5.41	3.16E-08	3.15124E-08
-5.4	3.34E-08	3.33205E-08
-5.39	3.53E-08	3.52288E-08
-5.38	3.73E-08	3.72429E-08
-5.37	3.95E-08	3.93683E-08
-5.36	4.17E-08	4.1611E-08
-5.35	4.41E-08	4.39771E-08
-5.34	4.66E-08	4.64733E-08
-5.33	4.92E-08	4.91064E-08
-5.32	5.20E-08	5.18836E-08
-5.31	5.49E-08	5.48126E-08
-5.3	5.80E-08	5.79013E-08
-5.29	6.13E-08	6.11582E-08
-5.28	6.47E-08	6.4592E-08
-5.27	6.84E-08	6.82119E-08
-5.26	7.22E-08	7.20277E-08
-5.25	7.62E-08	7.60496E-08
-5.24	8.04E-08	8.02883E-08
-5.23	8.49E-08	8.4755E-08
-5.22	8.96E-08	8.94616E-08
-5.21	9.46E-08	9.44203E-08
-5.2	9.98E-08	9.96443E-08
-5.19	1.05E-07	1.05147E-07
-5.18	1.11E-07	1.10943E-07
-5.17	1.17E-07	1.17047E-07
-5.16	1.24E-07	1.23475E-07
-5.15	1.30E-07	1.30243E-07
-5.14	1.38E-07	1.37369E-07
-5.13	1.45E-07	1.44871E-07
-5.12	1.53E-07	1.52768E-07
-5.11	1.61E-07	1.61079E-07
-5.1	1.70E-07	1.69827E-07
-5.09	1.79E-07	1.79032E-07
-5.08	1.89E-07	1.88717E-07
-5.07	1.99E-07	1.98908E-07
-5.06	2.10E-07	2.09628E-07
-5.05	2.21E-07	2.20905E-07
-5.04	2.33E-07	2.32766E-07
-5.03	2.46E-07	2.4524E-07
-5.02	2.59E-07	2.58357E-07
-5.01	2.73E-07	2.7215E-07
-5	2.87E-07	2.86652E-07
-4.99	3.02E-07	3.01897E-07
-4.98	3.18E-07	3.17922E-07
-4.97	3.35E-07	3.34764E-07
-4.96	3.53E-07	3.52466E-07
-4.95	3.72E-07	3.71067E-07
-4.94	3.91E-07	3.90613E-07
-4.93	4.12E-07	4.11148E-07
-4.92	4.33E-07	4.32721E-07
-4.91	4.56E-07	4.55382E-07
-4.9	4.80E-07	4.79183E-07
-4.89	5.05E-07	5.0418E-07
-4.88	5.31E-07	5.30429E-07
-4.87	5.59E-07	5.57991E-07
-4.86	5.88E-07	5.86929E-07
-4.85	6.18E-07	6.17307E-07
-4.84	6.50E-07	6.49196E-07
-4.83	6.84E-07	6.82665E-07
-4.82	7.19E-07	7.17791E-07
-4.81	7.56E-07	7.54652E-07
-4.8	7.94E-07	7.93328E-07
-4.79	8.35E-07	8.33907E-07
-4.78	8.78E-07	8.76476E-07
-4.77	9.22E-07	9.2113E-07
-4.76	9.69E-07	9.67965E-07
-4.75	1.02E-06	1.01708E-06
-4.74	1.07E-06	1.06859E-06
-4.73	1.12E-06	1.1226E-06
-4.72	1.18E-06	1.17922E-06
-4.71	1.24E-06	1.23858E-06
-4.7	1.30E-06	1.30081E-06
-4.69	1.37E-06	1.36603E-06
-4.68	1.44E-06	1.43437E-06
-4.67	1.51E-06	1.506E-06
-4.66	1.58E-06	1.58105E-06
-4.65	1.66E-06	1.65968E-06
-4.64	1.74E-06	1.74205E-06
-4.63	1.83E-06	1.82833E-06
-4.62	1.92E-06	1.9187E-06
-4.61	2.02E-06	2.01334E-06
-4.6	2.11E-06	2.11245E-06
-4.59	2.22E-06	2.21623E-06
-4.58	2.33E-06	2.32488E-06
-4.57	2.44E-06	2.43862E-06
-4.56	2.56E-06	2.55768E-06
-4.55	2.68E-06	2.6823E-06
-4.54	2.82E-06	2.81271E-06
-4.53	2.95E-06	2.94918E-06
-4.52	3.09E-06	3.09198E-06
-4.51	3.24E-06	3.24138E-06
-4.5	3.40E-06	3.39767E-06
-4.49	3.56E-06	3.56116E-06
-4.48	3.74E-06	3.73215E-06
-4.47	3.91E-06	3.91098E-06
-4.46	4.10E-06	4.09798E-06
-4.45	4.30E-06	4.29351E-06
-4.44	4.50E-06	4.49794E-06
-4.43	4.72E-06	4.71165E-06
-4.42	4.94E-06	4.93505E-06
-4.41	5.17E-06	5.16853E-06
-4.4	5.42E-06	5.41254E-06
-4.39	5.67E-06	5.66753E-06
-4.38	5.94E-06	5.93397E-06
-4.37	6.22E-06	6.21233E-06
-4.36	6.51E-06	6.50312E-06
-4.35	6.81E-06	6.80688E-06
-4.34	7.13E-06	7.12414E-06
-4.33	7.46E-06	7.45547E-06
-4.32	7.81E-06	7.80146E-06
-4.31	8.17E-06	8.16273E-06
-4.3	8.55E-06	8.53991E-06
-4.29	8.94E-06	8.93366E-06
-4.28	9.35E-06	9.34467E-06
-4.27	9.78E-06	9.77365E-06
-4.26	1.02E-05	1.02213E-05
-4.25	1.07E-05	1.06885E-05
-4.24	1.12E-05	1.1176E-05
-4.23	1.17E-05	1.16846E-05
-4.22	1.22E-05	1.22151E-05
-4.21	1.28E-05	1.27685E-05
-4.2	1.34E-05	1.33457E-05
-4.19	1.40E-05	1.39477E-05
-4.18	1.46E-05	1.45755E-05
-4.17	1.52E-05	1.523E-05
-4.16	1.59E-05	1.59124E-05
-4.15	1.66E-05	1.66238E-05
-4.14	1.74E-05	1.73653E-05
-4.13	1.81E-05	1.81382E-05
-4.12	1.90E-05	1.89436E-05
-4.11	1.98E-05	1.9783E-05
-4.1	2.07E-05	2.06575E-05
-4.09	2.16E-05	2.15687E-05
-4.08	2.25E-05	2.25179E-05
-4.07	2.35E-05	2.35066E-05
-4.06	2.45E-05	2.45364E-05
-4.05	2.56E-05	2.56088E-05
-4.04	2.67E-05	2.67256E-05
-4.03	2.79E-05	2.78884E-05
-4.02	2.91E-05	2.90991E-05
-4.01	3.04E-05	3.03594E-05
-4	3.17E-05	3.16712E-05
-3.99	3.31E-05	3.30366E-05
-3.98	3.45E-05	3.44576E-05
-3.97	3.60E-05	3.59363E-05
-3.96	3.75E-05	3.74749E-05
-3.95	3.91E-05	3.90756E-05
-3.94	4.08E-05	4.07408E-05
-3.93	4.25E-05	4.24729E-05
-3.92	4.43E-05	4.42745E-05
-3.91	4.62E-05	4.61481E-05
-3.9	4.81E-05	4.80963E-05
-3.89	5.01E-05	5.01221E-05
-3.88	5.22E-05	5.22282E-05
-3.87	5.44E-05	5.44177E-05
-3.86	5.67E-05	5.66935E-05
-3.85	5.91E-05	5.90589E-05
-3.84	6.15E-05	6.15172E-05
-3.83	6.41E-05	6.40716E-05
-3.82	6.67E-05	6.67258E-05
-3.81	6.95E-05	6.94834E-05
-3.8	7.24E-05	7.2348E-05
-3.79	7.53E-05	7.53236E-05
-3.78	7.84E-05	7.84142E-05
-3.77	8.16E-05	8.16238E-05
-3.76	8.50E-05	8.49567E-05
-3.75	8.84E-05	8.84173E-05
-3.74	9.20E-05	9.20101E-05
-3.73	9.58E-05	9.57399E-05
-3.72	9.96E-05	9.96114E-05
-3.71	0.000103659	0.00010363
-3.7	0.00010783	0.0001078
-3.69	0.000112158	0.000112127
-3.68	0.000116649	0.000116617
-3.67	0.000121308	0.000121275
-3.66	0.000126141	0.000126108
-3.65	0.000131154	0.00013112
-3.64	0.000136353	0.000136319
-3.63	0.000141746	0.000141711
-3.62	0.000147337	0.000147302
-3.61	0.000153135	0.000153099
-3.6	0.000159146	0.000159109
-3.59	0.000165377	0.000165339
-3.58	0.000171836	0.000171797
-3.57	0.00017853	0.000178491
-3.56	0.000185467	0.000185427
-3.55	0.000192656	0.000192616
-3.54	0.000200105	0.000200064
-3.53	0.000207822	0.00020778
-3.52	0.000215816	0.000215773
-3.51	0.000224097	0.000224053
-3.5	0.000232673	0.000232629
-3.49	0.000241555	0.00024151
-3.48	0.000250753	0.000250707
-3.47	0.000260276	0.000260229
-3.46	0.000270135	0.000270088
-3.45	0.000280341	0.000280293
-3.44	0.000290906	0.000290857
-3.43	0.00030184	0.000301791
-3.42	0.000313156	0.000313106
-3.41	0.000324865	0.000324814
-3.4	0.000336981	0.000336929
-3.39	0.000349515	0.000349463
-3.38	0.000362482	0.000362429
-3.37	0.000375895	0.000375841
-3.36	0.000389767	0.000389712
-3.35	0.000404113	0.000404058
-3.34	0.000418948	0.000418892
-3.33	0.000434286	0.00043423
-3.32	0.000450144	0.000450087
-3.31	0.000466538	0.00046648
-3.3	0.000483483	0.000483424
-3.29	0.000500996	0.000500937
-3.28	0.000519095	0.000519035
-3.27	0.000537798	0.000537737
-3.26	0.000557122	0.000557061
-3.25	0.000577087	0.000577025
-3.24	0.000597711	0.000597648
-3.23	0.000619014	0.000618951
-3.22	0.000641016	0.000640953
-3.21	0.000663739	0.000663675
-3.2	0.000687202	0.000687138
-3.19	0.000711429	0.000711364
-3.18	0.00073644	0.000736375
-3.17	0.00076226	0.000762195
-3.16	0.000788912	0.000788846
-3.15	0.000816419	0.000816352
-3.14	0.000844806	0.000844739
-3.13	0.000874099	0.000874032
-3.12	0.000904323	0.000904255
-3.11	0.000935504	0.000935437
-3.1	0.000967671	0.000967603
-3.09	0.00100085	0.001000782
-3.08	0.00103507	0.001035003
-3.07	0.00107036	0.001070294
-3.06	0.00110675	0.001106685
-3.05	0.00114428	0.001144207
-3.04	0.00118296	0.001182891
-3.03	0.00122284	0.001222769
-3.02	0.00126394	0.001263873
-3.01	0.00130631	0.001306238
-3	0.00134997	0.001349898
-2.99	0.00139496	0.001394887
-2.98	0.00144131	0.001441242
-2.97	0.00148907	0.001488999
-2.96	0.00153826	0.001538195
-2.95	0.00158894	0.00158887
-2.94	0.00164113	0.001641061
-2.93	0.00169488	0.00169481
-2.92	0.00175022	0.001750157
-2.91	0.00180721	0.001807144
-2.9	0.00186588	0.001865813
-2.89	0.00192628	0.001926209
-2.88	0.00198844	0.001988376
-2.87	0.00205242	0.002052359
-2.86	0.00211827	0.002118205
-2.85	0.00218603	0.002185961
-2.84	0.00225574	0.002255677
-2.83	0.00232746	0.0023274
-2.82	0.00240124	0.002401182
-2.81	0.00247714	0.002477075
-2.8	0.00255519	0.00255513
-2.79	0.00263546	0.002635402
-2.78	0.002718	0.002717945
-2.77	0.00280287	0.002802815
-2.76	0.00289012	0.002890068
-2.75	0.00297982	0.002979763
-2.74	0.00307201	0.003071959
-2.73	0.00316677	0.003166716
-2.72	0.00326415	0.003264096
-2.71	0.00336421	0.00336416
-2.7	0.00346702	0.003466974
-2.69	0.00357265	0.003572601
-2.68	0.00368115	0.003681108
-2.67	0.00379261	0.003792562
-2.66	0.00390708	0.003907033
-2.65	0.00402463	0.004024589
-2.64	0.00414534	0.004145301
-2.63	0.00426928	0.004269243
-2.62	0.00439653	0.004396488
-2.61	0.00452715	0.004527111
-2.6	0.00466122	0.004661188
-2.59	0.00479883	0.004798797
-2.58	0.00494005	0.004940016
-2.57	0.00508495	0.005084926
-2.56	0.00523363	0.005233608
-2.55	0.00538617	0.005386146
-2.54	0.00554265	0.005542623
-2.53	0.00570315	0.005703126
-2.52	0.00586776	0.005867742
-2.51	0.00603657	0.006036558
-2.5	0.00620968	0.006209665
-2.49	0.00638717	0.006387155
-2.48	0.00656913	0.006569119
-2.47	0.00675566	0.006755653
-2.46	0.00694686	0.006946851
-2.45	0.00714281	0.007142811
-2.44	0.00734363	0.007343631
-2.43	0.00754941	0.007549411
-2.42	0.00776025	0.007760254
-2.41	0.00797626	0.00797626
-2.4	0.00819753	0.008197536
-2.39	0.00842418	0.008424186
-2.38	0.00865631	0.008656319
-2.37	0.00889403	0.008894043
-2.36	0.00913745	0.009137468
-2.35	0.00938669	0.009386706
-2.34	0.00964185	0.00964187
-2.33	0.00990305	0.009903076
-2.32	0.0101704	0.010170439
-2.31	0.0104441	0.010444077
-2.3	0.0107241	0.01072411
-2.29	0.0110106	0.011010658
-2.28	0.0113038	0.011303844
-2.27	0.0116038	0.011603792
-2.26	0.0119106	0.011910625
-2.25	0.0122244	0.012224473
-2.24	0.0125454	0.012545461
-2.23	0.0128737	0.012873721
-2.22	0.0132093	0.013209384
-2.21	0.0135525	0.013552581
-2.2	0.0139034	0.013903448
-2.19	0.0142621	0.014262118
-2.18	0.0146287	0.014628731
-2.17	0.0150034	0.015003423
-2.16	0.0153863	0.015386335
-2.15	0.0157776	0.015777607
-2.14	0.0161773	0.016177383
-2.13	0.0165857	0.016585807
-2.12	0.017003	0.017003023
-2.11	0.0174291	0.017429178
-2.1	0.0178644	0.017864421
-2.09	0.0183088	0.0183089
-2.08	0.0187627	0.018762766
-2.07	0.0192261	0.019226172
-2.06	0.0196992	0.01969927
-2.05	0.0201821	0.020182215
-2.04	0.0206751	0.020675163
-2.03	0.0211782	0.02117827
-2.02	0.0216916	0.021691694
-2.01	0.0222155	0.022215594
-2	0.0227501	0.022750132