当前位置:高等教育资讯网  >  中国高校课件下载中心  >  大学文库  >  浏览文档

《EXCEL统计分析》08 概率分布

资源类别:文库,文档格式:XLS,文档页数:12,文件大小:47KB,团购合买
点击下载完整版文档(XLS)

X fX)1 fX )2 fX)3 均数标准差 40.0001340.00171361.183E-05 f(X)1 3.90.0001990.00246651.781E05 f(X)2 011 0.9 3.80.0002920.00350672.659E-05 f(X)3 -3.70.0004250.00492433.9 3.60.0006120.00683015.7 0.5f(X) 3.50.0008730.00935738.4 -3.40.0012320.01266220.0 3.30.0017230.01692420.0 -3.20.0023840.02234320.0 -3.10.0032670.02913540 30.0044320.03752630.0 2.90.0059530.04774060. 2.80.0079150.059990.0 2.70.0104210.07445740.0 2.60.0135830.09127990.0 2.50.0175280.11053020.0 -2.40.0223950.1321980.0 3270.15617350.-4 10 2.20.0354750.18223340.0 2.10.0439840.21003280. 20.0539910.23910270.0087978 1.90.0656160.26885640.0112268 -1.80.078950.29860320.0142085 -1.70.0940490.32757210.0178341 1.60.1109210.35494220.0222006 1.50.1295180.37988030.0274087 -1.40.1497270.4015820.033560 1.30.1713690.41931470.0407541 1.20.1941860.43245830.0490827 1.10.2178520.44054140.0586268 10.2419710.44326920.0694505 -0.90.2660850.44054140.0815952 -0.80.2896920.43245830.0950748 -0.70.3122540.41931470.1098693 0.60.3332250.4015820.1259211 0.50.3520650.37988030.1431302 -0.40.368270.35494220.1613521 -0.30.3813880.32757210.1803969 -0.20.3910430.29860320.2000296 0.10.3969530.26885640.2199734 00.3989420.23910270.2399147 0.10.3969530.21003280.2595102 0.20.3910430.18223340.2783958 0.30.3813880.15617350.2961977 0.40.368270.1321980.3125443 0.50.3520650.11053020.3270787 0.60.3332250.09127990.3394718

X f(X )1 f(X )2 f(X )3 均数 标准差 -4 0.000134 0.0017136 1.183E-05 f(X)1 0 1 -3.9 0.000199 0.0024665 1.781E-05 f(X)2 -1 0.9 -3.8 0.000292 0.0035067 2.659E-05 f(X)3 1 1.1 -3.7 0.000425 0.0049243 3.938E-05 -3.6 0.000612 0.0068301 5.783E-05 -3.5 0.000873 0.0093573 8.423E-05 -3.4 0.001232 0.0126622 0.0001217 -3.3 0.001723 0.0169242 0.0001743 -3.2 0.002384 0.0223432 0.0002476 -3.1 0.003267 0.0291354 0.000349 -3 0.004432 0.0375263 0.0004877 -2.9 0.005953 0.0477406 0.000676 -2.8 0.007915 0.05999 0.0009292 -2.7 0.010421 0.0744574 0.0012668 -2.6 0.013583 0.0912799 0.0017128 -2.5 0.017528 0.1105302 0.0022968 -2.4 0.022395 0.132198 0.0030546 -2.3 0.028327 0.1561735 0.004029 -2.2 0.035475 0.1822334 0.0052704 -2.1 0.043984 0.2100328 0.0068376 -2 0.053991 0.2391027 0.0087978 -1.9 0.065616 0.2688564 0.0112268 -1.8 0.07895 0.2986032 0.0142085 -1.7 0.094049 0.3275721 0.0178341 -1.6 0.110921 0.3549422 0.0222006 -1.5 0.129518 0.3798803 0.0274087 -1.4 0.149727 0.401582 0.0335602 -1.3 0.171369 0.4193147 0.0407541 -1.2 0.194186 0.4324583 0.0490827 -1.1 0.217852 0.4405414 0.0586268 -1 0.241971 0.4432692 0.0694505 -0.9 0.266085 0.4405414 0.0815952 -0.8 0.289692 0.4324583 0.0950748 -0.7 0.312254 0.4193147 0.1098693 -0.6 0.333225 0.401582 0.1259211 -0.5 0.352065 0.3798803 0.1431302 -0.4 0.36827 0.3549422 0.1613521 -0.3 0.381388 0.3275721 0.1803969 -0.2 0.391043 0.2986032 0.2000296 -0.1 0.396953 0.2688564 0.2199734 0 0.398942 0.2391027 0.2399147 0.1 0.396953 0.2100328 0.2595102 0.2 0.391043 0.1822334 0.2783958 0.3 0.381388 0.1561735 0.2961977 0.4 0.36827 0.132198 0.3125443 0.5 0.352065 0.1105302 0.3270787 0.6 0.333225 0.0912799 0.3394718

0.70.3122540.07445740.3494346 0.80.2896920.059990.3567294 0.90.2660850.04774060.3611792 10.2419710.03752630.3626748 1.10.2178520.02913540.3611792 1.20.1941860.02234320.3567294 1.30.1713690.01692420.3494346 1.40.1497270.01266220.3394718 1.50.1295180.00935730.3270787 1.60.1109210.00683010.3125443 1.70.0940490.00492430.2961977 1.80.078950.00350670.2783958 1.90.0656160.00246650.2595102 20.0539910.00171360.2399147 2.10.0439840.0011760.2199734 2.20.0354750.00079710.2000296 2.30.0283270.00053360.1803969 2.40.0223950.00035290.1613521 2.50.0175280.00023050.1431302 2.60.0135830.00014870.1259211 2.70.0104219.476E-050.1098693 2.80.0079155.964E-050.0950748 2.90.0059533.708E-050.0815952 0044322.277E-050.0694505 10.0032671.381E-050.0586268 3.20.0023848.273E-060.0490827 3.30.0017234.896E-060.0407541 3.40.0012322.861E-060.0335602 3.50.0008731.652E-060.0274087 3.60.0006129.42E-070.0222006 3.70.0004255.305E-070.0178341 3.80.0002922.95E-070.0142085 3.90.0001991.622E-070.0112268 40.0001348.802E-080.0087978

0.7 0.312254 0.0744574 0.3494346 0.8 0.289692 0.05999 0.3567294 0.9 0.266085 0.0477406 0.3611792 1 0.241971 0.0375263 0.3626748 1.1 0.217852 0.0291354 0.3611792 1.2 0.194186 0.0223432 0.3567294 1.3 0.171369 0.0169242 0.3494346 1.4 0.149727 0.0126622 0.3394718 1.5 0.129518 0.0093573 0.3270787 1.6 0.110921 0.0068301 0.3125443 1.7 0.094049 0.0049243 0.2961977 1.8 0.07895 0.0035067 0.2783958 1.9 0.065616 0.0024665 0.2595102 2 0.053991 0.0017136 0.2399147 2.1 0.043984 0.001176 0.2199734 2.2 0.035475 0.0007971 0.2000296 2.3 0.028327 0.0005336 0.1803969 2.4 0.022395 0.0003529 0.1613521 2.5 0.017528 0.0002305 0.1431302 2.6 0.013583 0.0001487 0.1259211 2.7 0.010421 9.476E-05 0.1098693 2.8 0.007915 5.964E-05 0.0950748 2.9 0.005953 3.708E-05 0.0815952 3 0.004432 2.277E-05 0.0694505 3.1 0.003267 1.381E-05 0.0586268 3.2 0.002384 8.273E-06 0.0490827 3.3 0.001723 4.896E-06 0.0407541 3.4 0.001232 2.861E-06 0.0335602 3.5 0.000873 1.652E-06 0.0274087 3.6 0.000612 9.42E-07 0.0222006 3.7 0.000425 5.305E-07 0.0178341 3.8 0.000292 2.951E-07 0.0142085 3.9 0.000199 1.622E-07 0.0112268 4 0.000134 8.802E-08 0.0087978

f(X)1 f(X)2 f(X)3

X F(X) 均数标准差 40.0001343.16712E-05 0 3.90.0001994.80963E-05 3.80.0002927.2348E-05 ) -3.70.0004250.0001078 3.60.0006120.000159109 F( 0.8 -3.40.0012320.000336929 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 2.50.0175280.006209665 -2.40.0223950.008197536 83270.01072411 X 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

3 4

p(x)1 p(x)2 两个参数p(x)1p(x)2 00.0312500.000798 10.1562500.006839 0.02720.4 30.3125000.071 40.1562500.1300.3 50.0312500.178 NUM!0.191(0.3 #NUM!0.1644 0.2 9 0.065 0#NM!0.030-0.2 II #NUM!0.012 12 #NUM!0.0030.1 13#NUM!0.001( 14#NUM!0.000 15 M!0.000( 0.0 01234567.8910

x p(x)1 p(x)2 两个参数 p(x)1 p(x)2 0 0.031250 0.000798 n 5 20 1 0.156250 0.006839 p 0.5 0.3 2 0.312500 0.027846 3 0.312500 0.071604 4 0.156250 0.130421 5 0.031250 0.178863 6 #NUM! 0.191639 7 #NUM! 0.164262 8 #NUM! 0.114397 9 #NUM! 0.065370 10 #NUM! 0.030817 11 #NUM! 0.012007 12 #NUM! 0.003859 13 #NUM! 0.001018 14 #NUM! 0.000218 15 #NUM! 0.000037

x)1图p(x)2 Bn⊥ 1112131415

点击下载完整版文档(XLS)VIP每日下载上限内不扣除下载券和下载次数;
按次数下载不扣除下载券;
注册用户24小时内重复下载只扣除一次;
顺序:VIP每日次数-->可用次数-->下载券;
共12页,试读已结束,阅读完整版请下载
相关文档

关于我们|帮助中心|下载说明|相关软件|意见反馈|联系我们

Copyright © 2008-现在 cucdc.com 高等教育资讯网 版权所有