正态分布累积函数1.xls

一个求正太分布的程序

-1.99	0.0232954	0.023295468
-1.98	0.0238517	0.023851764
-1.97	0.0244191	0.024419185
-1.96	0.0249978	0.024997895
-1.95	0.025588	0.02558806
-1.94	0.0261898	0.026189845
-1.93	0.0268034	0.026803419
-1.92	0.0274289	0.02742895
-1.91	0.0280665	0.028066607
-1.9	0.0287165	0.02871656
-1.89	0.0293789	0.02937898
-1.88	0.030054	0.030054039
-1.87	0.0307418	0.030741909
-1.86	0.0314427	0.031442763
-1.85	0.0321567	0.032156775
-1.84	0.0328841	0.032884119
-1.83	0.0336249	0.033624969
-1.82	0.0343794	0.034379502
-1.81	0.0351478	0.035147894
-1.8	0.0359303	0.035930319
-1.79	0.0367269	0.036726956
-1.78	0.0375379	0.03753798
-1.77	0.0383635	0.03836357
-1.76	0.0392039	0.039203903
-1.75	0.0400591	0.040059157
-1.74	0.0409295	0.040929509
-1.73	0.0418151	0.041815138
-1.72	0.0427162	0.042716221
-1.71	0.0436329	0.043632937
-1.7	0.0445654	0.044565463
-1.69	0.045514	0.045513977
-1.68	0.0464786	0.046478658
-1.67	0.0474597	0.047459682
-1.66	0.0484572	0.048457226
-1.65	0.0494715	0.049471468
-1.64	0.0505026	0.050502583
-1.63	0.0515507	0.051550748
-1.62	0.0526161	0.052616138
-1.61	0.0536989	0.053698928
-1.6	0.0547993	0.054799292
-1.59	0.0559174	0.055917403
-1.58	0.0570534	0.057053433
-1.57	0.0582076	0.058207556
-1.56	0.05938	0.059379941
-1.55	0.0605708	0.060570758
-1.54	0.0617802	0.061780177
-1.53	0.0630084	0.063008364
-1.52	0.0642555	0.064255488
-1.51	0.0655217	0.065521712
-1.5	0.0668072	0.066807201
-1.49	0.0681122	0.068112118
-1.48	0.0694367	0.069436623
-1.47	0.0707809	0.070780877
-1.46	0.0721451	0.072145037
-1.45	0.0735293	0.07352926
-1.44	0.0749337	0.0749337
-1.43	0.0763586	0.07635851
-1.42	0.0778039	0.077803841
-1.41	0.0792699	0.079269841
-1.4	0.0807567	0.080756659
-1.39	0.0822645	0.082264439
-1.38	0.0837934	0.083793322
-1.37	0.0853435	0.085343451
-1.36	0.086915	0.086914962
-1.35	0.0885081	0.088507991
-1.34	0.0901227	0.090122672
-1.33	0.0917592	0.091759136
-1.32	0.0934176	0.093417509
-1.31	0.095098	0.095097918
-1.3	0.0968006	0.096800485
-1.29	0.0985254	0.098525329
-1.28	0.100273	0.100272568
-1.27	0.102042	0.102042315
-1.26	0.103835	0.103834681
-1.25	0.10565	0.105649774
-1.24	0.107488	0.107487697
-1.23	0.109349	0.109348552
-1.22	0.111233	0.111232437
-1.21	0.11314	0.113139446
-1.2	0.11507	0.11506967
-1.19	0.117023	0.117023196
-1.18	0.119	0.119000107
-1.17	0.121001	0.121000484
-1.16	0.123024	0.123024403
-1.15	0.125072	0.125071936
-1.14	0.127143	0.127143151
-1.13	0.129238	0.129238112
-1.12	0.131357	0.131356881
-1.11	0.1335	0.133499513
-1.1	0.135666	0.135666061
-1.09	0.137857	0.137856572
-1.08	0.140071	0.14007109
-1.07	0.14231	0.142309654
-1.06	0.144572	0.1445723
-1.05	0.146859	0.146859056
-1.04	0.14917	0.14916995
-1.03	0.151505	0.151505003
-1.02	0.153864	0.15386423
-1.01	0.156248	0.156247645
-1	0.158655	0.158655254
-0.99	0.161087	0.16108706
-0.98	0.163543	0.163543059
-0.97	0.166023	0.166023246
-0.96	0.168528	0.168527607
-0.95	0.171056	0.171056126
-0.94	0.173609	0.17360878
-0.93	0.176186	0.176185542
-0.92	0.178786	0.17878638
-0.91	0.181411	0.181411255
-0.9	0.18406	0.184060125
-0.89	0.186733	0.186732943
-0.88	0.18943	0.189429655
-0.87	0.19215	0.192150202
-0.86	0.194894	0.194894521
-0.85	0.197662	0.197662543
-0.84	0.200454	0.200454193
-0.83	0.203269	0.203269392
-0.82	0.206108	0.206108054
-0.81	0.20897	0.208970088
-0.8	0.211855	0.211855399
-0.79	0.214764	0.214763884
-0.78	0.217695	0.217695438
-0.77	0.22065	0.220649946
-0.76	0.223627	0.223627292
-0.75	0.226627	0.226627352
-0.74	0.22965	0.229649997
-0.73	0.232695	0.232695092
-0.72	0.235762	0.235762498
-0.71	0.238852	0.238852068
-0.7	0.241964	0.241963652
-0.69	0.245097	0.245097094
-0.68	0.248252	0.24825223
-0.67	0.251429	0.251428895
-0.66	0.254627	0.254626915
-0.65	0.257846	0.257846111
-0.64	0.261086	0.2610863
-0.63	0.264347	0.264347292
-0.62	0.267629	0.267628893
-0.61	0.270931	0.270930904
-0.6	0.274253	0.274253118
-0.59	0.277595	0.277595325
-0.58	0.280957	0.280957309
-0.57	0.284339	0.284338849
-0.56	0.28774	0.287739719
-0.55	0.29116	0.291159687
-0.54	0.294599	0.294598516
-0.53	0.298056	0.298055965
-0.52	0.301532	0.301531788
-0.51	0.305026	0.305025731
-0.5	0.308538	0.308537539
-0.49	0.312067	0.312066949
-0.48	0.315614	0.315613697
-0.47	0.319178	0.319177509
-0.46	0.322758	0.32275811
-0.45	0.326355	0.32635522
-0.44	0.329969	0.329968554
-0.43	0.333598	0.333597821
-0.42	0.337243	0.337242727
-0.41	0.340903	0.340902974
-0.4	0.344578	0.344578258
-0.39	0.348268	0.348268273
-0.38	0.351973	0.351972708
-0.37	0.355691	0.355691245
-0.36	0.359424	0.359423567
-0.35	0.363169	0.363169349
-0.34	0.366928	0.366928264
-0.33	0.3707	0.370699981
-0.32	0.374484	0.374484165
-0.31	0.378281	0.378280478
-0.3	0.382089	0.382088578
-0.29	0.385908	0.385908119
-0.28	0.389739	0.389738752
-0.27	0.39358	0.393580127
-0.26	0.397432	0.397431887
-0.25	0.401294	0.401293674
-0.24	0.405165	0.405165128
-0.23	0.409046	0.409045885
-0.22	0.412936	0.412935577
-0.21	0.416834	0.416833837
-0.2	0.42074	0.420740291
-0.19	0.424655	0.424654565
-0.18	0.428576	0.428576284
-0.17	0.432505	0.432505068
-0.16	0.436441	0.436440537
-0.15	0.440382	0.440382308
-0.14	0.44433	0.444329995
-0.13	0.448283	0.448283213
-0.12	0.452242	0.452241574
-0.11	0.456205	0.456204687
-0.1	0.460172	0.460172163
-0.09	0.464144	0.464143607
-0.08	0.468119	0.468118628
-0.07	0.472097	0.47209683
-0.06	0.476078	0.476077817
-0.05	0.480061	0.480061194
-0.04	0.484047	0.484046563
-0.03	0.488033	0.488033527
-0.02	0.492022	0.492021686
-0.01	0.496011	0.496010644
0	0.5	0.5
0.01	0.503989	0.503989356
0.02	0.507978	0.507978314
0.03	0.511967	0.511966473
0.04	0.515953	0.515953437
0.05	0.519939	0.519938806
0.06	0.523922	0.523922183
0.07	0.527903	0.52790317
0.08	0.531881	0.531881372
0.09	0.535856	0.535856393
0.1	0.539828	0.539827837
0.11	0.543795	0.543795313
0.12	0.547758	0.547758426
0.13	0.551717	0.551716787
0.14	0.55567	0.555670005
0.15	0.559618	0.559617692
0.16	0.563559	0.563559463
0.17	0.567495	0.567494932
0.18	0.571424	0.571423716
0.19	0.575345	0.575345435
0.2	0.57926	0.579259709
0.21	0.583166	0.583166163
0.22	0.587064	0.587064423
0.23	0.590954	0.590954115
0.24	0.594835	0.594834872
0.25	0.598706	0.598706326
0.26	0.602568	0.602568113
0.27	0.60642	0.606419873
0.28	0.610261	0.610261248
0.29	0.614092	0.614091881
0.3	0.617911	0.617911422
0.31	0.621719	0.621719522
0.32	0.625516	0.625515835
0.33	0.6293	0.629300019
0.34	0.633072	0.633071736
0.35	0.636831	0.636830651
0.36	0.640576	0.640576433
0.37	0.644309	0.644308755
0.38	0.648027	0.648027292
0.39	0.651732	0.651731727
0.4	0.655422	0.655421742
0.41	0.659097	0.659097026
0.42	0.662757	0.662757273
0.43	0.666402	0.666402179
0.44	0.670031	0.670031446
0.45	0.673645	0.67364478
0.46	0.677242	0.67724189
0.47	0.680822	0.680822491
0.48	0.684386	0.684386303
0.49	0.687933	0.687933051
0.5	0.691462	0.691462461
0.51	0.694974	0.694974269
0.52	0.698468	0.698468212
0.53	0.701944	0.701944035
0.54	0.705401	0.705401484
0.55	0.70884	0.708840313
0.56	0.71226	0.712260281
0.57	0.715661	0.715661151
0.58	0.719043	0.719042691
0.59	0.722405	0.722404675
0.6	0.725747	0.725746882
0.61	0.729069	0.729069096
0.62	0.732371	0.732371107
0.63	0.735653	0.735652708
0.64	0.738914	0.7389137
0.65	0.742154	0.742153889
0.66	0.745373	0.745373085
0.67	0.748571	0.748571105
0.68	0.751748	0.75174777
0.69	0.754903	0.754902906
0.7	0.758036	0.758036348
0.71	0.761148	0.761147932
0.72	0.764238	0.764237502
0.73	0.767305	0.767304908
0.74	0.77035	0.770350003
0.75	0.773373	0.773372648
0.76	0.776373	0.776372708
0.77	0.77935	0.779350054
0.78	0.782305	0.782304562
0.79	0.785236	0.785236116
0.8	0.788145	0.788144601
0.81	0.79103	0.791029912
0.82	0.793892	0.793891946
0.83	0.796731	0.796730608
0.84	0.799546	0.799545807
0.85	0.802338	0.802337457
0.86	0.805106	0.805105479
0.87	0.80785	0.807849798
0.88	0.81057	0.810570345
0.89	0.813267	0.813267057
0.9	0.81594	0.815939875
0.91	0.818589	0.818588745
0.92	0.821214	0.82121362
0.93	0.823814	0.823814458
0.94	0.826391	0.82639122
0.95	0.828944	0.828943874
0.96	0.831472	0.831472393
0.97	0.833977	0.833976754
0.98	0.836457	0.836456941
0.99	0.838913	0.83891294
1	0.841345	0.841344746
1.01	0.843752	0.843752355
1.02	0.846136	0.84613577
1.03	0.848495	0.848494997
1.04	0.85083	0.85083005
1.05	0.853141	0.853140944
1.06	0.855428	0.8554277
1.07	0.85769	0.857690346
1.08	0.859929	0.85992891
1.09	0.862143	0.862143428
1.1	0.864334	0.864333939
1.11	0.8665	0.866500487
1.12	0.868643	0.868643119
1.13	0.870762	0.870761888
1.14	0.872857	0.872856849
1.15	0.874928	0.874928064
1.16	0.876976	0.876975597
1.17	0.878999	0.878999516
1.18	0.881	0.880999893
1.19	0.882977	0.882976804
1.2	0.88493	0.88493033
1.21	0.88686	0.886860554
1.22	0.888767	0.888767563
1.23	0.890651	0.890651448
1.24	0.892512	0.892512303
1.25	0.89435	0.894350226
1.26	0.896165	0.896165319
1.27	0.897958	0.897957685
1.28	0.899727	0.899727432
1.29	0.901475	0.901474671
1.3	0.903199	0.903199515
1.31	0.904902	0.904902082
1.32	0.906582	0.906582491
1.33	0.908241	0.908240864
1.34	0.909877	0.909877328
1.35	0.911492	0.911492009
1.36	0.913085	0.913085038
1.37	0.914656	0.914656549
1.38	0.916207	0.916206678
1.39	0.917736	0.917735561
1.4	0.919243	0.919243341
1.41	0.92073	0.920730159
1.42	0.922196	0.922196159
1.43	0.923641	0.92364149
1.44	0.925066	0.9250663
1.45	0.926471	0.92647074
1.46	0.927855	0.927854963
1.47	0.929219	0.929219123
1.48	0.930563	0.930563377
1.49	0.931888	0.931887882
1.5	0.933193	0.933192799
1.51	0.934478	0.934478288
1.52	0.935744	0.935744512
1.53	0.936992	0.936991636
1.54	0.93822	0.938219823
1.55	0.939429	0.939429242
1.56	0.94062	0.940620059
1.57	0.941792	0.941792444
1.58	0.942947	0.942946567
1.59	0.944083	0.944082597
1.6	0.945201	0.945200708
1.61	0.946301	0.946301072
1.62	0.947384	0.947383862
1.63	0.948449	0.948449252
1.64	0.949497	0.949497417
1.65	0.950529	0.950528532
1.66	0.951543	0.951542774
1.67	0.95254	0.952540318
1.68	0.953521	0.953521342
1.69	0.954486	0.954486023
1.7	0.955435	0.955434537
1.71	0.956367	0.956367063
1.72	0.957284	0.957283779
1.73	0.958185	0.958184862
1.74	0.959071	0.959070491
1.75	0.959941	0.959940843
1.76	0.960796	0.960796097
1.77	0.961636	0.96163643
1.78	0.962462	0.96246202
1.79	0.963273	0.963273044
1.8	0.96407	0.964069681
1.81	0.964852	0.964852106
1.82	0.965621	0.965620498
1.83	0.966375	0.966375031
1.84	0.967116	0.967115881
1.85	0.967843	0.967843225
1.86	0.968557	0.968557237
1.87	0.969258	0.969258091
1.88	0.969946	0.969945961
1.89	0.970621	0.97062102
1.9	0.971284	0.97128344
1.91	0.971933	0.971933393
1.92	0.972571	0.97257105
1.93	0.973197	0.973196581
1.94	0.97381	0.973810155
1.95	0.974412	0.97441194
1.96	0.975002	0.975002105
1.97	0.975581	0.975580815
1.98	0.976148	0.976148236
1.99	0.976705	0.976704532
2	0.97725	0.977249868
2.01	0.977784	0.977784406