《EXCEL统计分析》08.2 正态分布概率密度与累积概率的比较

X F(X) 均数标准差 40.0001343.16712E-05 0 3.90.0001994.80963E-05 3.80.0002927.2348E-05 f( -3.70.0004250.0001078 F( 3.60.0006120.000159109 0.8 -3.40.0012320.000336929 0.6 3.30.0017230.000483424 -3.20.0023840.000687138 -3.10.0032670.000967603 30.0044320.001349898 2.90.0059530.001865813 2.80.0079150.0025551 2.70.0104210.003466974 2.60.0135830.004661188 LLLLLLIOLLLLL 2.50.0175280.006209665 0 -2.40.0223950.008197536 X 83270.01072411 2.20.0354750.013903448 2.10.0439840.017864421 20.0539910.022750132 1.90.0656160.02871656 -1.80.078950.035930319 -1.70.0940490.044565463 1.60.1109210.054799292 1.50.1295180.066807201 -1.40.1497270.080756659 1.30.1713690.096800485 1.20.1941860.11506967 1.10.2178520.135666061 10.2419710.158655254 -0.90.2660850.184060125 -0.80.2896920.211855399 -0.70.3122540.241963652 0.60.3332250.274253118 0.50.3520650.308537539 0.40.368270.344578258 382088578 -0.20.3910430.42074029 0.10.3969530.460172163 00.398942 0.10.3969530.539827837 0.20.3910430.579259709 0.30.3813880.617911422 0.40.368270.655421742 0.50.3520650.691462461 0.60.3332250.725746882

X f(X ) F(X ) 均数 标准差 -4 0.000134 3.16712E-05 0 1 -3.9 0.000199 4.80963E-05 -3.8 0.000292 7.2348E-05 -3.7 0.000425 0.0001078 -3.6 0.000612 0.000159109 -3.5 0.000873 0.000232629 -3.4 0.001232 0.000336929 -3.3 0.001723 0.000483424 -3.2 0.002384 0.000687138 -3.1 0.003267 0.000967603 -3 0.004432 0.001349898 -2.9 0.005953 0.001865813 -2.8 0.007915 0.00255513 -2.7 0.010421 0.003466974 -2.6 0.013583 0.004661188 -2.5 0.017528 0.006209665 -2.4 0.022395 0.008197536 -2.3 0.028327 0.01072411 -2.2 0.035475 0.013903448 -2.1 0.043984 0.017864421 -2 0.053991 0.022750132 -1.9 0.065616 0.02871656 -1.8 0.07895 0.035930319 -1.7 0.094049 0.044565463 -1.6 0.110921 0.054799292 -1.5 0.129518 0.066807201 -1.4 0.149727 0.080756659 -1.3 0.171369 0.096800485 -1.2 0.194186 0.11506967 -1.1 0.217852 0.135666061 -1 0.241971 0.158655254 -0.9 0.266085 0.184060125 -0.8 0.289692 0.211855399 -0.7 0.312254 0.241963652 -0.6 0.333225 0.274253118 -0.5 0.352065 0.308537539 -0.4 0.36827 0.344578258 -0.3 0.381388 0.382088578 -0.2 0.391043 0.420740291 -0.1 0.396953 0.460172163 0 0.398942 0.5 0.1 0.396953 0.539827837 0.2 0.391043 0.579259709 0.3 0.381388 0.617911422 0.4 0.36827 0.655421742 0.5 0.352065 0.691462461 0.6 0.333225 0.725746882

0.70.3122540.758036348 0.80.2896920.788144601 0.90.2660850.815939875 10.2419710.841344746 1.10.2178520.864333939 1.20.1941860.88493033 1.30.1713690.903199515 1.40.1497270.919243341 1.50.1295180.933192799 1.60.1109210.945200708 1.70.0940490.955434537 1.80.078950.964069681 1.90.0656160.97128344 20.0539910.977249868 2.10.0439840.982135579 2.20.0354750.986096552 2.40.0223950.991802464 2.50.0175280.993790335 2.60.0135830.995338812 2.70.0104210.996533026 2.80.0079150.99744487 2.90.0059530.998134187 30.0044320.998650102 10.0032670.99903239 3.20.0023840.999312862 3.30.0017230.999516576 3.40.0012320.999663071 3.50.0008730.999767371 3.60.0006120.999840891 3.70.0004250.9998922 3.80.0002920.999927652 3.90.0001990.999951904 40.0001340.999968329

0.7 0.312254 0.758036348 0.8 0.289692 0.788144601 0.9 0.266085 0.815939875 1 0.241971 0.841344746 1.1 0.217852 0.864333939 1.2 0.194186 0.88493033 1.3 0.171369 0.903199515 1.4 0.149727 0.919243341 1.5 0.129518 0.933192799 1.6 0.110921 0.945200708 1.7 0.094049 0.955434537 1.8 0.07895 0.964069681 1.9 0.065616 0.97128344 2 0.053991 0.977249868 2.1 0.043984 0.982135579 2.2 0.035475 0.986096552 2.3 0.028327 0.98927589 2.4 0.022395 0.991802464 2.5 0.017528 0.993790335 2.6 0.013583 0.995338812 2.7 0.010421 0.996533026 2.8 0.007915 0.99744487 2.9 0.005953 0.998134187 3 0.004432 0.998650102 3.1 0.003267 0.999032397 3.2 0.002384 0.999312862 3.3 0.001723 0.999516576 3.4 0.001232 0.999663071 3.5 0.000873 0.999767371 3.6 0.000612 0.999840891 3.7 0.000425 0.9998922 3.8 0.000292 0.999927652 3.9 0.000199 0.999951904 4 0.000134 0.999968329

2 3 4