(5-8)用Excel生成标准正态分布的分位数表—Book8

p0.0000.0010.0020.0030.0040.0050.0060.007 0.500.00000.00250.00500.00750.01000.01250.01500.0175 0.510.02510.02760.03010.03260.03510.03760.04010.0426 0.520.05020.05270.05520.05770.06020.06270.06520.0677 0.530.07530.07780.08030.08280.08530.08780.09040.0929 0.540.10040.10300.10550.10800.11050.11300.11560.1181 0.550.12570.12820.13070.13320.13580.13830.14080.1434 0.560.15100.15350.15600.15860.16110.16370.16620.1687 0.570.17640.17890.18150.18400.18660.18910.19170.1942 0.580.20190.20450.20700.20960.21210.21470.21730.2198 0.590.22750.23010.23270.23530.23780.24040.24300.2456 0.600.25330.25590.25850.26110.26370.26630.26890.2715 0.610.27930.28190.28450.28710.28980.29240.29500.2976 0.620.30550.30810.31070.31340.31600.31860.32130.3239 0.630.33190.33450.33720.33980.34250.34510.34780.3505 0.640.35850.36110.36380.36650.36920.37190.37450.3772 0.650.38530.38800.39070.39340.39610.39890.40160.4043

0.0080.009 0.02010.0226 0.04510.0476 0.07020.0728 0.09540.0979 0.12060.1231 0.14590.1484 0.17130.1738 0.19680.1993 0.22240.2250 0.24820.2508 0.27410.2767 0.30020.3029 0.32660.3292 0.35310.3558 0.37990.3826 0.40700.4097