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

《EXCEL统计分析》08.1 正态分布电脑实验

资源类别:文库,文档格式:XLS,文档页数:4,文件大小:34.5KB,团购合买
点击下载完整版文档(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

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

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

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