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

一个求正太分布的程序

0	-3.09023	-3.09023
0.001	-3.09023	-3.090232306
0.002	-2.87816	-2.878161739
0.003	-2.74778	-2.747781385
0.004	-2.65207	-2.652069808
0.005	-2.57583	-2.575829304
0.006	-2.51214	-2.512144328
0.007	-2.45726	-2.45726339
0.008	-2.40892	-2.408915546
0.009	-2.36562	-2.365618127
0.01	-2.32635	-2.326347874
0.011	-2.29037	-2.290367878
0.012	-2.25713	-2.257129244
0.013	-2.22621	-2.226211769
0.014	-2.19729	-2.197286377
0.015	-2.17009	-2.170090378
0.016	-2.14441	-2.144410621
0.017	-2.12007	-2.12007169
0.018	-2.09693	-2.096927429
0.019	-2.07485	-2.074854734
0.02	-2.05375	-2.053748911
0.021	-2.03352	-2.033520149
0.022	-2.01409	-2.014090812
0.023	-1.99539	-1.99539331
0.024	-1.97737	-1.977368428
0.025	-1.95996	-1.959963985
0.026	-1.94313	-1.943133751
0.027	-1.92684	-1.926836573
0.028	-1.91104	-1.911035648
0.029	-1.8957	-1.895697924
0.03	-1.88079	-1.880793608
0.031	-1.8663	-1.866295743
0.032	-1.85218	-1.852179859
0.033	-1.83842	-1.838423669
0.034	-1.82501	-1.825006821
0.035	-1.81191	-1.811910673
0.036	-1.79912	-1.799118107
0.037	-1.78661	-1.786613365
0.038	-1.77438	-1.77438191
0.039	-1.76241	-1.762410298
0.04	-1.75069	-1.750686071
0.041	-1.7392	-1.739197665
0.042	-1.72793	-1.727934322
0.043	-1.71689	-1.716886018
0.044	-1.70604	-1.706043397
0.045	-1.6954	-1.69539771
0.046	-1.68494	-1.684940768
0.047	-1.67466	-1.674664889
0.048	-1.66456	-1.664562861
0.049	-1.65463	-1.654627902
0.05	-1.64485	-1.644853627
0.051	-1.63523	-1.635234015
0.052	-1.62576	-1.625763386
0.053	-1.61644	-1.616436371
0.054	-1.60725	-1.607247892
0.055	-1.59819	-1.59819314
0.056	-1.58927	-1.589267557
0.057	-1.58047	-1.580466818
0.058	-1.57179	-1.571786817
0.059	-1.56322	-1.563223647
0.06	-1.55477	-1.554773595
0.061	-1.54643	-1.546433122
0.062	-1.5382	-1.538198859
0.063	-1.53007	-1.530067588
0.064	-1.52204	-1.522036242
0.065	-1.5141	-1.514101888
0.066	-1.50626	-1.506261723
0.067	-1.49851	-1.498513068
0.068	-1.49085	-1.490853355
0.069	-1.48328	-1.483280127
0.07	-1.47579	-1.475791028
0.071	-1.46838	-1.468383798
0.072	-1.46106	-1.461056269
0.073	-1.45381	-1.453806359
0.074	-1.44663	-1.446632067
0.075	-1.43953	-1.439531471
0.076	-1.4325	-1.432502721
0.077	-1.42554	-1.425544037
0.078	-1.41865	-1.418653706
0.079	-1.41183	-1.411830078
0.08	-1.40507	-1.40507156
0.081	-1.39838	-1.398376621
0.082	-1.39174	-1.391743779
0.083	-1.38517	-1.385171608
0.084	-1.37866	-1.378658729
0.085	-1.3722	-1.372203809
0.086	-1.36581	-1.365805563
0.087	-1.35946	-1.359462745
0.088	-1.35317	-1.353174155
0.089	-1.34694	-1.346938626
0.09	-1.34076	-1.340755034
0.091	-1.33462	-1.334622287
0.092	-1.32854	-1.328539329
0.093	-1.32251	-1.322505137
0.094	-1.31652	-1.316518718
0.095	-1.31058	-1.310579112
0.096	-1.30469	-1.304685385
0.097	-1.29884	-1.298836633
0.098	-1.29303	-1.293031976
0.099	-1.28727	-1.287270563
0.1	-1.28155	-1.281551566
0.101	-1.27587	-1.275874179
0.102	-1.27024	-1.270237622
0.103	-1.26464	-1.264641136
0.104	-1.25908	-1.25908398
0.105	-1.25357	-1.253565438
0.106	-1.24808	-1.248084811
0.107	-1.24264	-1.242641419
0.108	-1.23723	-1.237234599
0.109	-1.23186	-1.231863709
0.11	-1.22653	-1.22652812
0.111	-1.22123	-1.221227222
0.112	-1.21596	-1.21596042
0.113	-1.21073	-1.210727133
0.114	-1.20553	-1.205526796
0.115	-1.20036	-1.200358858
0.116	-1.19522	-1.195222781
0.117	-1.19012	-1.190118042
0.118	-1.18504	-1.185044128
0.119	-1.18	-1.18000054
0.12	-1.17499	-1.174986792
0.121	-1.17	-1.170002408
0.122	-1.16505	-1.165046922
0.123	-1.16012	-1.160119883
0.124	-1.15522	-1.155220847
0.125	-1.15035	-1.15034938
0.126	-1.14551	-1.145505061
0.127	-1.14069	-1.140687476
0.128	-1.1359	-1.135896221
0.129	-1.13113	-1.131130901
0.13	-1.12639	-1.126391129
0.131	-1.12168	-1.121676528
0.132	-1.11699	-1.116986728
0.133	-1.11232	-1.112321367
0.134	-1.10768	-1.107680092
0.135	-1.10306	-1.103062556
0.136	-1.09847	-1.09846842
0.137	-1.0939	-1.093897353
0.138	-1.08935	-1.089349028
0.139	-1.08482	-1.084823128
0.14	-1.08032	-1.080319341
0.141	-1.07584	-1.075837361
0.142	-1.07138	-1.071376889
0.143	-1.06694	-1.066937632
0.144	-1.06252	-1.062519302
0.145	-1.05812	-1.058121618
0.146	-1.05374	-1.053744302
0.147	-1.04939	-1.049387085
0.148	-1.04505	-1.0450497
0.149	-1.04073	-1.040731886
0.15	-1.03643	-1.036433389
0.151	-1.03215	-1.032153958
0.152	-1.02789	-1.027893346
0.153	-1.02365	-1.023651312
0.154	-1.01943	-1.019427618
0.155	-1.01522	-1.015222033
0.156	-1.01103	-1.011034328
0.157	-1.00686	-1.006864279
0.158	-1.00271	-1.002711665
0.159	-0.998576	-0.998576271
0.16	-0.994458	-0.994457883
0.161	-0.990356	-0.990356294
0.162	-0.986271	-0.986271299
0.163	-0.982203	-0.982202695
0.164	-0.97815	-0.978150286
0.165	-0.974114	-0.974113877
0.166	-0.970093	-0.970093277
0.167	-0.966088	-0.966088297
0.168	-0.962099	-0.962098754
0.169	-0.958124	-0.958124465
0.17	-0.954165	-0.954165253
0.171	-0.950221	-0.950220942
0.172	-0.946291	-0.946291358
0.173	-0.942376	-0.942376333
0.174	-0.938476	-0.938475698
0.175	-0.934589	-0.934589291
0.176	-0.930717	-0.930716949
0.177	-0.926859	-0.926858513
0.178	-0.923014	-0.923013826
0.179	-0.919183	-0.919182735
0.18	-0.915365	-0.915365088
0.181	-0.911561	-0.911560735
0.182	-0.90777	-0.90776953
0.183	-0.903991	-0.903991328
0.184	-0.900226	-0.900225986
0.185	-0.896473	-0.896473364
0.186	-0.892733	-0.892733324
0.187	-0.889006	-0.889005731
0.188	-0.88529	-0.885290449
0.189	-0.881587	-0.881587347
0.19	-0.877896	-0.877896295
0.191	-0.874217	-0.874217165
0.192	-0.87055	-0.87054983
0.193	-0.866894	-0.866894167
0.194	-0.86325	-0.863250052
0.195	-0.859617	-0.859617364
0.196	-0.855996	-0.855995985
0.197	-0.852386	-0.852385798
0.198	-0.848787	-0.848786686
0.199	-0.845199	-0.845198535
0.2	-0.841621	-0.841621234
0.201	-0.838055	-0.83805467
0.202	-0.834499	-0.834498735
0.203	-0.830953	-0.830953321
0.204	-0.827418	-0.827418321
0.205	-0.823894	-0.82389363
0.206	-0.820379	-0.820379146
0.207	-0.816875	-0.816874766
0.208	-0.81338	-0.813380388
0.209	-0.809896	-0.809895915
0.21	-0.806421	-0.806421247
0.211	-0.802956	-0.802956288
0.212	-0.799501	-0.799500943
0.213	-0.796055	-0.796055117
0.214	-0.792619	-0.792618718
0.215	-0.789192	-0.789191653
0.216	-0.785774	-0.785773832
0.217	-0.782365	-0.782365165
0.218	-0.778966	-0.778965564
0.219	-0.775575	-0.775574943
0.22	-0.772193	-0.772193214
0.221	-0.76882	-0.768820293
0.222	-0.765456	-0.765456097
0.223	-0.762101	-0.762100541
0.224	-0.758754	-0.758753545
0.225	-0.755415	-0.755415026
0.226	-0.752085	-0.752084907
0.227	-0.748763	-0.748763107
0.228	-0.74545	-0.745449548
0.229	-0.742144	-0.742144154
0.23	-0.738847	-0.738846849
0.231	-0.735558	-0.735557557
0.232	-0.732276	-0.732276205
0.233	-0.729003	-0.729002718
0.234	-0.725737	-0.725737024
0.235	-0.722479	-0.722479052
0.236	-0.719229	-0.71922873
0.237	-0.715986	-0.71598599
0.238	-0.712751	-0.71275076
0.239	-0.709523	-0.709522974
0.24	-0.706303	-0.706302563
0.241	-0.703089	-0.70308946
0.242	-0.699884	-0.6998836
0.243	-0.696685	-0.696684917
0.244	-0.693493	-0.693493346
0.245	-0.690309	-0.690308824
0.246	-0.687131	-0.687131287
0.247	-0.683961	-0.683960672
0.248	-0.680797	-0.680796919
0.249	-0.67764	-0.677639965
0.25	-0.67449	-0.67448975
0.251	-0.671346	-0.671346215
0.252	-0.668209	-0.6682093
0.253	-0.665079	-0.665078946
0.254	-0.661955	-0.661955096
0.255	-0.658838	-0.658837693
0.256	-0.655727	-0.655726679
0.257	-0.652622	-0.652621998
0.258	-0.649524	-0.649523596
0.259	-0.646431	-0.646431416
0.26	-0.643345	-0.643345405
0.261	-0.640266	-0.640265509
0.262	-0.637192	-0.637191675
0.263	-0.634124	-0.634123849
0.264	-0.631062	-0.631061979
0.265	-0.628006	-0.628006014
0.266	-0.624956	-0.624955903
0.267	-0.621912	-0.621911596
0.268	-0.618873	-0.618873041
0.269	-0.61584	-0.615840189
0.27	-0.612813	-0.612812991
0.271	-0.609791	-0.609791399
0.272	-0.606775	-0.606775364
0.273	-0.603765	-0.603764838
0.274	-0.60076	-0.600759774
0.275	-0.59776	-0.597760126
0.276	-0.594766	-0.594765847
0.277	-0.591777	-0.591776891
0.278	-0.588793	-0.588793212
0.279	-0.585815	-0.585814766
0.28	-0.582842	-0.582841507
0.281	-0.579873	-0.579873392
0.282	-0.57691	-0.576910377
0.283	-0.573952	-0.573952419
0.284	-0.570999	-0.570999473
0.285	-0.568051	-0.568051498
0.286	-0.565108	-0.565108452
0.287	-0.56217	-0.562170292
0.288	-0.559237	-0.559236978
0.289	-0.556308	-0.556308467
0.29	-0.553385	-0.55338472
0.291	-0.550466	-0.550465695
0.292	-0.547551	-0.547551353
0.293	-0.544642	-0.544641655
0.294	-0.541737	-0.54173656
0.295	-0.538836	-0.53883603
0.296	-0.53594	-0.535940027
0.297	-0.533049	-0.533048511
0.298	-0.530161	-0.530161445
0.299	-0.527279	-0.527278791
0.3	-0.524401	-0.524400513
0.301	-0.521527	-0.521526572
0.302	-0.518657	-0.518656932
0.303	-0.515792	-0.515791557
0.304	-0.51293	-0.512930411
0.305	-0.510073	-0.510073457
0.306	-0.507221	-0.507220661
0.307	-0.504372	-0.504371986
0.308	-0.501527	-0.501527399
0.309	-0.498687	-0.498686864
0.31	-0.49585	-0.495850347
0.311	-0.493018	-0.493017814
0.312	-0.490189	-0.490189232
0.313	-0.487365	-0.487364565
0.314	-0.484544	-0.484543782
0.315	-0.481727	-0.48172685
0.316	-0.478914	-0.478913734
0.317	-0.476104	-0.476104403
0.318	-0.473299	-0.473298825
0.319	-0.470497	-0.470496968
0.32	-0.467699	-0.467698799
0.321	-0.464904	-0.464904288
0.322	-0.462113	-0.462113402
0.323	-0.459326	-0.459326111
0.324	-0.456542	-0.456542384
0.325	-0.453762	-0.45376219
0.326	-0.450985	-0.450985499
0.327	-0.448212	-0.448212281
0.328	-0.445443	-0.445442506
0.329	-0.442676	-0.442676144
0.33	-0.439913	-0.439913166
0.331	-0.437154	-0.437153541
0.332	-0.434397	-0.434397242
0.333	-0.431644	-0.431644239
0.334	-0.428895	-0.428894504
0.335	-0.426148	-0.426148008
0.336	-0.423405	-0.423404722
0.337	-0.420665	-0.42066462
0.338	-0.417928	-0.417927672
0.339	-0.415194	-0.415193851
0.34	-0.412463	-0.412463129
0.341	-0.409735	-0.40973548
0.342	-0.407011	-0.407010876
0.343	-0.404289	-0.40428929
0.344	-0.401571	-0.401570696
0.345	-0.398855	-0.398855066
0.346	-0.396142	-0.396142374
0.347	-0.393433	-0.393432594
0.348	-0.390726	-0.3907257
0.349	-0.388022	-0.388021666
0.35	-0.38532	-0.385320466
0.351	-0.382622	-0.382622075
0.352	-0.379926	-0.379926467
0.353	-0.377234	-0.377233617
0.354	-0.374543	-0.374543499
0.355	-0.371856	-0.371856089
0.356	-0.369171	-0.369171363
0.357	-0.366489	-0.366489294
0.358	-0.36381	-0.363809859
0.359	-0.361133	-0.361133034
0.36	-0.358459	-0.358458793
0.361	-0.355787	-0.355787114
0.362	-0.353118	-0.353117972
0.363	-0.350451	-0.350451343
0.364	-0.347787	-0.347787204
0.365	-0.345126	-0.345125531
0.366	-0.342466	-0.342466301
0.367	-0.339809	-0.339809491
0.368	-0.337155	-0.337155077
0.369	-0.334503	-0.334503036
0.37	-0.331853	-0.331853346
0.371	-0.329206	-0.329205984
0.372	-0.326561	-0.326560927
0.373	-0.323918	-0.323918153
0.374	-0.321278	-0.32127764
0.375	-0.318639	-0.318639364
0.376	-0.316003	-0.316003304
0.377	-0.313369	-0.313369439
0.378	-0.310738	-0.310737745
0.379	-0.308108	-0.308108202
0.38	-0.305481	-0.305480788
0.381	-0.302855	-0.302855481
0.382	-0.300232	-0.300232259
0.383	-0.297611	-0.297611102
0.384	-0.294992	-0.294991988
0.385	-0.292375	-0.292374896
0.386	-0.28976	-0.289759805
0.387	-0.287147	-0.287146694
0.388	-0.284536	-0.284535543
0.389	-0.281926	-0.28192633
0.39	-0.279319	-0.279319034
0.391	-0.276714	-0.276713637
0.392	-0.27411	-0.274110116
0.393	-0.271508	-0.271508452
0.394	-0.268909	-0.268908624
0.395	-0.266311	-0.266310613
0.396	-0.263714	-0.263714398
0.397	-0.26112	-0.26111996
0.398	-0.258527	-0.258527277
0.399	-0.255936	-0.255936332
0.4	-0.253347	-0.253347103
0.401	-0.25076	-0.250759572
0.402	-0.248174	-0.248173718
0.403	-0.24559	-0.245589523
0.404	-0.243007	-0.243006967
0.405	-0.240426	-0.240426031
0.406	-0.237847	-0.237846695
0.407	-0.235269	-0.235268941
0.408	-0.232693	-0.232692749
0.409	-0.230118	-0.230118101
0.41	-0.227545	-0.227544977
0.411	-0.224973	-0.224973358
0.412	-0.222403	-0.222403227
0.413	-0.219835	-0.219834564
0.414	-0.217267	-0.21726735
0.415	-0.214702	-0.214701568
0.416	-0.212137	-0.212137198
0.417	-0.209574	-0.209574223
0.418	-0.207013	-0.207012623
0.419	-0.204452	-0.204452382
0.42	-0.201893	-0.201893479
0.421	-0.199336	-0.199335898
0.422	-0.19678	-0.19677962
0.423	-0.194225	-0.194224628
0.424	-0.191671	-0.191670902
0.425	-0.189118	-0.189118426
0.426	-0.186567	-0.186567182
0.427	-0.184017	-0.184017151
0.428	-0.181468	-0.181468317
0.429	-0.178921	-0.17892066
0.43	-0.176374	-0.176374165
0.431	-0.173829	-0.173828813
0.432	-0.171285	-0.171284586
0.433	-0.168741	-0.168741468
0.434	-0.166199	-0.16619944
0.435	-0.163658	-0.163658486
0.436	-0.161119	-0.161118589
0.437	-0.15858	-0.15857973
0.438	-0.156042	-0.156041893
0.439	-0.153505	-0.15350506
0.44	-0.150969	-0.150969215
0.441	-0.148434	-0.148434341
0.442	-0.1459	-0.14590042
0.443	-0.143367	-0.143367435
0.444	-0.140835	-0.14083537
0.445	-0.138304	-0.138304208
0.446	-0.135774	-0.135773931
0.447	-0.133245	-0.133244524
0.448	-0.130716	-0.130715968
0.449	-0.128188	-0.128188248
0.45	-0.125661	-0.125661347
0.451	-0.123135	-0.123135248
0.452	-0.12061	-0.120609934
0.453	-0.118085	-0.118085389
0.454	-0.115562	-0.115561597
0.455	-0.113039	-0.113038541
0.456	-0.110516	-0.110516204
0.457	-0.107995	-0.107994569
0.458	-0.105474	-0.105473622
0.459	-0.102953	-0.102953344
0.46	-0.100434	-0.100433721
0.461	-0.0979147	-0.097914734
0.462	-0.0953964	-0.095396369
0.463	-0.0928786	-0.092878609
0.464	-0.0903614	-0.090361437
0.465	-0.0878448	-0.087844838
0.466	-0.0853288	-0.085328795
0.467	-0.0828133	-0.082813292
0.468	-0.0802983	-0.080298313
0.469	-0.0777838	-0.077783842
0.47	-0.0752699	-0.075269862
0.471	-0.0727564	-0.072756358
0.472	-0.0702433	-0.070243314
0.473	-0.0677307	-0.067730713
0.474	-0.0652185	-0.06521854
0.475	-0.0627068	-0.062706778
0.476	-0.0601954	-0.060195412
0.477	-0.0576844	-0.057684425
0.478	-0.0551738	-0.055173802
0.479	-0.0526635	-0.052663527
0.48	-0.0501536	-0.050153583
0.481	-0.047644	-0.047643956
0.482	-0.0451346	-0.045134628
0.483	-0.0426256	-0.042625585
0.484	-0.0401168	-0.04011681
0.485	-0.0376083	-0.037608288
0.486	-0.0351	-0.035100002
0.487	-0.0325919	-0.032591937
0.488	-0.0300841	-0.030084077
0.489	-0.0275764	-0.027576406
0.49	-0.0250689	-0.025068908
0.491	-0.0225616	-0.022561568
0.492	-0.0200544	-0.02005437
0.493	-0.0175473	-0.017547298
0.494	-0.0150403	-0.015040337
0.495	-0.0125335	-0.01253347
0.496	-0.0100267	-0.010026681
0.497	-0.00751996	-0.007519956
0.498	-0.00501328	-0.005013278
0.499	-0.00250663	-0.002506631
0.5	0	-1.39214E-16