正态分布累积函数的逆函数1.xls

一个求正太分布的程序

0.501	0.00250663	0.002506631
0.502	0.00501328	0.005013278
0.503	0.00751996	0.007519956
0.504	0.0100267	0.010026681
0.505	0.0125335	0.01253347
0.506	0.0150403	0.015040337
0.507	0.0175473	0.017547298
0.508	0.0200544	0.02005437
0.509	0.0225616	0.022561568
0.51	0.0250689	0.025068908
0.511	0.0275764	0.027576406
0.512	0.0300841	0.030084077
0.513	0.0325919	0.032591937
0.514	0.0351	0.035100002
0.515	0.0376083	0.037608288
0.516	0.0401168	0.04011681
0.517	0.0426256	0.042625585
0.518	0.0451346	0.045134628
0.519	0.047644	0.047643956
0.52	0.0501536	0.050153583
0.521	0.0526635	0.052663527
0.522	0.0551738	0.055173802
0.523	0.0576844	0.057684425
0.524	0.0601954	0.060195412
0.525	0.0627068	0.062706778
0.526	0.0652185	0.06521854
0.527	0.0677307	0.067730713
0.528	0.0702433	0.070243314
0.529	0.0727564	0.072756358
0.53	0.0752699	0.075269862
0.531	0.0777838	0.077783842
0.532	0.0802983	0.080298313
0.533	0.0828133	0.082813292
0.534	0.0853288	0.085328795
0.535	0.0878448	0.087844838
0.536	0.0903614	0.090361437
0.537	0.0928786	0.092878609
0.538	0.0953964	0.095396369
0.539	0.0979147	0.097914734
0.54	0.100434	0.100433721
0.541	0.102953	0.102953344
0.542	0.105474	0.105473622
0.543	0.107995	0.107994569
0.544	0.110516	0.110516204
0.545	0.113039	0.113038541
0.546	0.115562	0.115561597
0.547	0.118085	0.118085389
0.548	0.12061	0.120609934
0.549	0.123135	0.123135248
0.55	0.125661	0.125661347
0.551	0.128188	0.128188248
0.552	0.130716	0.130715968
0.553	0.133245	0.133244524
0.554	0.135774	0.135773931
0.555	0.138304	0.138304208
0.556	0.140835	0.14083537
0.557	0.143367	0.143367435
0.558	0.1459	0.14590042
0.559	0.148434	0.148434341
0.56	0.150969	0.150969215
0.561	0.153505	0.15350506
0.562	0.156042	0.156041893
0.563	0.15858	0.15857973
0.564	0.161119	0.161118589
0.565	0.163658	0.163658486
0.566	0.166199	0.16619944
0.567	0.168741	0.168741468
0.568	0.171285	0.171284586
0.569	0.173829	0.173828813
0.57	0.176374	0.176374165
0.571	0.178921	0.17892066
0.572	0.181468	0.181468317
0.573	0.184017	0.184017151
0.574	0.186567	0.186567182
0.575	0.189118	0.189118426
0.576	0.191671	0.191670902
0.577	0.194225	0.194224628
0.578	0.19678	0.19677962
0.579	0.199336	0.199335898
0.58	0.201893	0.201893479
0.581	0.204452	0.204452382
0.582	0.207013	0.207012623
0.583	0.209574	0.209574223
0.584	0.212137	0.212137198
0.585	0.214702	0.214701568
0.586	0.217267	0.21726735
0.587	0.219835	0.219834564
0.588	0.222403	0.222403227
0.589	0.224973	0.224973358
0.59	0.227545	0.227544977
0.591	0.230118	0.230118101
0.592	0.232693	0.232692749
0.593	0.235269	0.235268941
0.594	0.237847	0.237846695
0.595	0.240426	0.240426031
0.596	0.243007	0.243006967
0.597	0.24559	0.245589523
0.598	0.248174	0.248173718
0.599	0.25076	0.250759572
0.6	0.253347	0.253347103
0.601	0.255936	0.255936332
0.602	0.258527	0.258527277
0.603	0.26112	0.26111996
0.604	0.263714	0.263714398
0.605	0.266311	0.266310613
0.606	0.268909	0.268908624
0.607	0.271508	0.271508452
0.608	0.27411	0.274110116
0.609	0.276714	0.276713637
0.61	0.279319	0.279319034
0.611	0.281926	0.28192633
0.612	0.284536	0.284535543
0.613	0.287147	0.287146694
0.614	0.28976	0.289759805
0.615	0.292375	0.292374896
0.616	0.294992	0.294991988
0.617	0.297611	0.297611102
0.618	0.300232	0.300232259
0.619	0.302855	0.302855481
0.62	0.305481	0.305480788
0.621	0.308108	0.308108202
0.622	0.310738	0.310737745
0.623	0.313369	0.313369439
0.624	0.316003	0.316003304
0.625	0.318639	0.318639364
0.626	0.321278	0.32127764
0.627	0.323918	0.323918153
0.628	0.326561	0.326560927
0.629	0.329206	0.329205984
0.63	0.331853	0.331853346
0.631	0.334503	0.334503036
0.632	0.337155	0.337155077
0.633	0.339809	0.339809491
0.634	0.342466	0.342466301
0.635	0.345126	0.345125531
0.636	0.347787	0.347787204
0.637	0.350451	0.350451343
0.638	0.353118	0.353117972
0.639	0.355787	0.355787114
0.64	0.358459	0.358458793
0.641	0.361133	0.361133034
0.642	0.36381	0.363809859
0.643	0.366489	0.366489294
0.644	0.369171	0.369171363
0.645	0.371856	0.371856089
0.646	0.374543	0.374543499
0.647	0.377234	0.377233617
0.648	0.379926	0.379926467
0.649	0.382622	0.382622075
0.65	0.38532	0.385320466
0.651	0.388022	0.388021666
0.652	0.390726	0.3907257
0.653	0.393433	0.393432594
0.654	0.396142	0.396142374
0.655	0.398855	0.398855066
0.656	0.401571	0.401570696
0.657	0.404289	0.40428929
0.658	0.407011	0.407010876
0.659	0.409735	0.40973548
0.66	0.412463	0.412463129
0.661	0.415194	0.415193851
0.662	0.417928	0.417927672
0.663	0.420665	0.42066462
0.664	0.423405	0.423404722
0.665	0.426148	0.426148008
0.666	0.428895	0.428894504
0.667	0.431644	0.431644239
0.668	0.434397	0.434397242
0.669	0.437154	0.437153541
0.67	0.439913	0.439913166
0.671	0.442676	0.442676144
0.672	0.445443	0.445442506
0.673	0.448212	0.448212281
0.674	0.450985	0.450985499
0.675	0.453762	0.45376219
0.676	0.456542	0.456542384
0.677	0.459326	0.459326111
0.678	0.462113	0.462113402
0.679	0.464904	0.464904288
0.68	0.467699	0.467698799
0.681	0.470497	0.470496968
0.682	0.473299	0.473298825
0.683	0.476104	0.476104403
0.684	0.478914	0.478913734
0.685	0.481727	0.48172685
0.686	0.484544	0.484543782
0.687	0.487365	0.487364565
0.688	0.490189	0.490189232
0.689	0.493018	0.493017814
0.69	0.49585	0.495850347
0.691	0.498687	0.498686864
0.692	0.501527	0.501527399
0.693	0.504372	0.504371986
0.694	0.507221	0.507220661
0.695	0.510073	0.510073457
0.696	0.51293	0.512930411
0.697	0.515792	0.515791557
0.698	0.518657	0.518656932
0.699	0.521527	0.521526572
0.7	0.524401	0.524400513
0.701	0.527279	0.527278791
0.702	0.530161	0.530161445
0.703	0.533049	0.533048511
0.704	0.53594	0.535940027
0.705	0.538836	0.53883603
0.706	0.541737	0.54173656
0.707	0.544642	0.544641655
0.708	0.547551	0.547551353
0.709	0.550466	0.550465695
0.71	0.553385	0.55338472
0.711	0.556308	0.556308467
0.712	0.559237	0.559236978
0.713	0.56217	0.562170292
0.714	0.565108	0.565108452
0.715	0.568051	0.568051498
0.716	0.570999	0.570999473
0.717	0.573952	0.573952419
0.718	0.57691	0.576910377
0.719	0.579873	0.579873392
0.72	0.582842	0.582841507
0.721	0.585815	0.585814766
0.722	0.588793	0.588793212
0.723	0.591777	0.591776891
0.724	0.594766	0.594765847
0.725	0.59776	0.597760126
0.726	0.60076	0.600759774
0.727	0.603765	0.603764838
0.728	0.606775	0.606775364
0.729	0.609791	0.609791399
0.73	0.612813	0.612812991
0.731	0.61584	0.615840189
0.732	0.618873	0.618873041
0.733	0.621912	0.621911596
0.734	0.624956	0.624955903
0.735	0.628006	0.628006014
0.736	0.631062	0.631061979
0.737	0.634124	0.634123849
0.738	0.637192	0.637191675
0.739	0.640266	0.640265509
0.74	0.643345	0.643345405
0.741	0.646431	0.646431416
0.742	0.649524	0.649523596
0.743	0.652622	0.652621998
0.744	0.655727	0.655726679
0.745	0.658838	0.658837693
0.746	0.661955	0.661955096
0.747	0.665079	0.665078946
0.748	0.668209	0.6682093
0.749	0.671346	0.671346215
0.75	0.67449	0.67448975
0.751	0.67764	0.677639965
0.752	0.680797	0.680796919
0.753	0.683961	0.683960672
0.754	0.687131	0.687131287
0.755	0.690309	0.690308824
0.756	0.693493	0.693493346
0.757	0.696685	0.696684917
0.758	0.699884	0.6998836
0.759	0.703089	0.70308946
0.76	0.706303	0.706302563
0.761	0.709523	0.709522974
0.762	0.712751	0.71275076
0.763	0.715986	0.71598599
0.764	0.719229	0.71922873
0.765	0.722479	0.722479052
0.766	0.725737	0.725737024
0.767	0.729003	0.729002718
0.768	0.732276	0.732276205
0.769	0.735558	0.735557557
0.77	0.738847	0.738846849
0.771	0.742144	0.742144154
0.772	0.74545	0.745449548
0.773	0.748763	0.748763107
0.774	0.752085	0.752084907
0.775	0.755415	0.755415026
0.776	0.758754	0.758753545
0.777	0.762101	0.762100541
0.778	0.765456	0.765456097
0.779	0.76882	0.768820293
0.78	0.772193	0.772193214
0.781	0.775575	0.775574943
0.782	0.778966	0.778965564
0.783	0.782365	0.782365165
0.784	0.785774	0.785773832
0.785	0.789192	0.789191653
0.786	0.792619	0.792618718
0.787	0.796055	0.796055117
0.788	0.799501	0.799500943
0.789	0.802956	0.802956288
0.79	0.806421	0.806421247
0.791	0.809896	0.809895915
0.792	0.81338	0.813380388
0.793	0.816875	0.816874766
0.794	0.820379	0.820379146
0.795	0.823894	0.82389363
0.796	0.827418	0.827418321
0.797	0.830953	0.830953321
0.798	0.834499	0.834498735
0.799	0.838055	0.83805467
0.8	0.841621	0.841621234
0.801	0.845199	0.845198535
0.802	0.848787	0.848786686
0.803	0.852386	0.852385798
0.804	0.855996	0.855995985
0.805	0.859617	0.859617364
0.806	0.86325	0.863250052
0.807	0.866894	0.866894167
0.808	0.87055	0.87054983
0.809	0.874217	0.874217165
0.81	0.877896	0.877896295
0.811	0.881587	0.881587347
0.812	0.88529	0.885290449
0.813	0.889006	0.889005731
0.814	0.892733	0.892733324
0.815	0.896473	0.896473364
0.816	0.900226	0.900225986
0.817	0.903991	0.903991328
0.818	0.90777	0.90776953
0.819	0.911561	0.911560735
0.82	0.915365	0.915365088
0.821	0.919183	0.919182735
0.822	0.923014	0.923013826
0.823	0.926859	0.926858513
0.824	0.930717	0.930716949
0.825	0.934589	0.934589291
0.826	0.938476	0.938475698
0.827	0.942376	0.942376333
0.828	0.946291	0.946291358
0.829	0.950221	0.950220942
0.83	0.954165	0.954165253
0.831	0.958124	0.958124465
0.832	0.962099	0.962098754
0.833	0.966088	0.966088297
0.834	0.970093	0.970093277
0.835	0.974114	0.974113877
0.836	0.97815	0.978150286
0.837	0.982203	0.982202695
0.838	0.986271	0.986271299
0.839	0.990356	0.990356294
0.84	0.994458	0.994457883
0.841	0.998576	0.998576271
0.842	1.00271	1.002711665
0.843	1.00686	1.006864279
0.844	1.01103	1.011034328
0.845	1.01522	1.015222033
0.846	1.01943	1.019427618
0.847	1.02365	1.023651312
0.848	1.02789	1.027893346
0.849	1.03215	1.032153958
0.85	1.03643	1.036433389
0.851	1.04073	1.040731886
0.852	1.04505	1.0450497
0.853	1.04939	1.049387085
0.854	1.05374	1.053744302
0.855	1.05812	1.058121618
0.856	1.06252	1.062519302
0.857	1.06694	1.066937632
0.858	1.07138	1.071376889
0.859	1.07584	1.075837361
0.86	1.08032	1.080319341
0.861	1.08482	1.084823128
0.862	1.08935	1.089349028
0.863	1.0939	1.093897353
0.864	1.09847	1.09846842
0.865	1.10306	1.103062556
0.866	1.10768	1.107680092
0.867	1.11232	1.112321367
0.868	1.11699	1.116986728
0.869	1.12168	1.121676528
0.87	1.12639	1.126391129
0.871	1.13113	1.131130901
0.872	1.1359	1.135896221
0.873	1.14069	1.140687476
0.874	1.14551	1.145505061
0.875	1.15035	1.15034938
0.876	1.15522	1.155220847
0.877	1.16012	1.160119883
0.878	1.16505	1.165046922
0.879	1.17	1.170002408
0.88	1.17499	1.174986792
0.881	1.18	1.18000054
0.882	1.18504	1.185044128
0.883	1.19012	1.190118042
0.884	1.19522	1.195222781
0.885	1.20036	1.200358858
0.886	1.20553	1.205526796
0.887	1.21073	1.210727133
0.888	1.21596	1.21596042
0.889	1.22123	1.221227222
0.89	1.22653	1.22652812
0.891	1.23186	1.231863709
0.892	1.23723	1.237234599
0.893	1.24264	1.242641419
0.894	1.24808	1.248084811
0.895	1.25357	1.253565438
0.896	1.25908	1.25908398
0.897	1.26464	1.264641136
0.898	1.27024	1.270237622
0.899	1.27587	1.275874179
0.9	1.28155	1.281551566
0.901	1.28727	1.287270563
0.902	1.29303	1.293031976
0.903	1.29884	1.298836633
0.904	1.30469	1.304685385
0.905	1.31058	1.310579112
0.906	1.31652	1.316518718
0.907	1.32251	1.322505137
0.908	1.32854	1.328539329
0.909	1.33462	1.334622287
0.91	1.34076	1.340755034
0.911	1.34694	1.346938626
0.912	1.35317	1.353174155
0.913	1.35946	1.359462745
0.914	1.36581	1.365805563
0.915	1.3722	1.372203809
0.916	1.37866	1.378658729
0.917	1.38517	1.385171608
0.918	1.39174	1.391743779
0.919	1.39838	1.398376621
0.92	1.40507	1.40507156
0.921	1.41183	1.411830078
0.922	1.41865	1.418653706
0.923	1.42554	1.425544037
0.924	1.4325	1.432502721
0.925	1.43953	1.439531471
0.926	1.44663	1.446632067
0.927	1.45381	1.453806359
0.928	1.46106	1.461056269
0.929	1.46838	1.468383798
0.93	1.47579	1.475791028
0.931	1.48328	1.483280127
0.932	1.49085	1.490853355
0.933	1.49851	1.498513068
0.934	1.50626	1.506261723
0.935	1.5141	1.514101888
0.936	1.52204	1.522036242
0.937	1.53007	1.530067588
0.938	1.5382	1.538198859
0.939	1.54643	1.546433122
0.94	1.55477	1.554773595
0.941	1.56322	1.563223647
0.942	1.57179	1.571786817
0.943	1.58047	1.580466818
0.944	1.58927	1.589267557
0.945	1.59819	1.59819314
0.946	1.60725	1.607247892
0.947	1.61644	1.616436371
0.948	1.62576	1.625763386
0.949	1.63523	1.635234015
0.95	1.64485	1.644853627
0.951	1.65463	1.654627902
0.952	1.66456	1.664562861
0.953	1.67466	1.674664889
0.954	1.68494	1.684940768
0.955	1.6954	1.69539771
0.956	1.70604	1.706043397
0.957	1.71689	1.716886018
0.958	1.72793	1.727934322
0.959	1.7392	1.739197665
0.96	1.75069	1.750686071
0.961	1.76241	1.762410298
0.962	1.77438	1.77438191
0.963	1.78661	1.786613365
0.964	1.79912	1.799118107
0.965	1.81191	1.811910673
0.966	1.82501	1.825006821
0.967	1.83842	1.838423669
0.968	1.85218	1.852179859
0.969	1.8663	1.866295743
0.97	1.88079	1.880793608
0.971	1.8957	1.895697924
0.972	1.91104	1.911035648
0.973	1.92684	1.926836573
0.974	1.94313	1.943133751
0.975	1.95996	1.959963985
0.976	1.97737	1.977368428
0.977	1.99539	1.99539331
0.978	2.01409	2.014090812
0.979	2.03352	2.033520149
0.98	2.05375	2.053748911
0.981	2.07485	2.074854734
0.982	2.09693	2.096927429
0.983	2.12007	2.12007169
0.984	2.14441	2.144410621
0.985	2.17009	2.170090378
0.986	2.19729	2.197286377
0.987	2.22621	2.226211769
0.988	2.25713	2.257129244
0.989	2.29037	2.290367878
0.99	2.32635	2.326347874
0.991	2.36562	2.365618127
0.992	2.40892	2.408915546
0.993	2.45726	2.45726339
0.994	2.51214	2.512144328
0.995	2.57583	2.575829304
0.996	2.65207	2.652069808
0.997	2.74778	2.747781385
0.998	2.87816	2.878161739
0.999	3.09023	3.090232306