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

《EXCEL统计分析》09.3 t分布电脑实验

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

t分布1t分布2正态分布 4.00.0187240.0023460.000134 -3.90.0196370.0027550.000199 正态分布均数 0 -3.80.0206160.0032380.000292 标准差 3.70.0216680.0038100.000425 3.60.0228020.0044870.000612 t分布1自由度1(v1)1 -3.50.0240230.0052880.000873 分布2自由度2(v2)9 -3.40.0253430.0062370.001232 3.30.0267710.0073610.001723 0.0283190.0086910.002384 -3.10.0300010.0102650.003267 3.00.0318310.0121260.004432 2.90.0338270.0143250.005953 -2.80.0360080.0169190.007915 -2.70.0383970.0199750.010421 2.60.0410190.0235670.013583 2.50.0439050.0277800.017528 -2.40.0470870.0327080.022395 2.30.0506060.0384520.028327 2.20.0545050.0451240.035475 -2.10.0588370.0528370.043984 -2.00.0636620.0617120.053991 1.90.0690480.0718630.065616 -1.80.0750730.0834020.078950 -1.70.0818280.0964220.094049 160.089130.1109930.110921 1.50.0979420.1271510.129518 -1.40.1075370.1448870.149727 1.30.1183310.1641330.171369 1.20.1304550.1847480.194186 1.10.1440320.2065160.217852 1.00.1591550.2291310.241971 -0.90.1758620.2521960.266085 0.80.1940910.2752320.289692 0.70.2136310.2976820.312254 0.60.2340510.3189360.333225 -0.50.2546480.3383570.352065 0.40.2744050.3553090.368270 -0.30.2920270.3692020.381388 -0.20.3060670.3795260.391043 0.10.3151580.3858860.396953 0.00.3183100.3880350.398942 0.10.3151580.3858860.396953 0.20.3060670.3795260.391043 0.30.2920270.3692020.381388 0.40.2744050.3553090.368270 0.50.2546480.3383570.352065 0.60.2340510.3189360.333225

t t 分布1 t 分布2 正态分布 -4.0 0.018724 0.002346 0.000134 -3.9 0.019637 0.002755 0.000199 正态分布 均数 0 -3.8 0.020616 0.003238 0.000292 标准差 1 -3.7 0.021668 0.003810 0.000425 -3.6 0.022802 0.004487 0.000612 t 分布1 自由度1(n1) 1 -3.5 0.024023 0.005288 0.000873 t 分布2 自由度2(n2) 9 -3.4 0.025343 0.006237 0.001232 -3.3 0.026771 0.007361 0.001723 -3.2 0.028319 0.008691 0.002384 -3.1 0.030001 0.010265 0.003267 -3.0 0.031831 0.012126 0.004432 -2.9 0.033827 0.014325 0.005953 -2.8 0.036008 0.016919 0.007915 -2.7 0.038397 0.019975 0.010421 -2.6 0.041019 0.023567 0.013583 -2.5 0.043905 0.027780 0.017528 -2.4 0.047087 0.032708 0.022395 -2.3 0.050606 0.038452 0.028327 -2.2 0.054505 0.045124 0.035475 -2.1 0.058837 0.052837 0.043984 -2.0 0.063662 0.061712 0.053991 -1.9 0.069048 0.071863 0.065616 -1.8 0.075073 0.083402 0.078950 -1.7 0.081828 0.096422 0.094049 -1.6 0.089413 0.110993 0.110921 -1.5 0.097942 0.127151 0.129518 -1.4 0.107537 0.144887 0.149727 -1.3 0.118331 0.164133 0.171369 -1.2 0.130455 0.184748 0.194186 -1.1 0.144032 0.206516 0.217852 -1.0 0.159155 0.229131 0.241971 -0.9 0.175862 0.252196 0.266085 -0.8 0.194091 0.275232 0.289692 -0.7 0.213631 0.297682 0.312254 -0.6 0.234051 0.318936 0.333225 -0.5 0.254648 0.338357 0.352065 -0.4 0.274405 0.355309 0.368270 -0.3 0.292027 0.369202 0.381388 -0.2 0.306067 0.379526 0.391043 -0.1 0.315158 0.385886 0.396953 0.0 0.318310 0.388035 0.398942 0.1 0.315158 0.385886 0.396953 0.2 0.306067 0.379526 0.391043 0.3 0.292027 0.369202 0.381388 0.4 0.274405 0.355309 0.368270 0.5 0.254648 0.338357 0.352065 0.6 0.234051 0.318936 0.333225

0.70.2136310.2976820.312254 0.80.1940910.2752320.289692 0.90.1758620.2521960.266085 1.00.1591550.2291310.241971 1.10.1440320.2065160.217852 1.20.1304550.1847480.194186 1.30.1183310.1641330.171369 1.40.1075370.1448870.149727 1.50.0979420.1271510.129518 1.60.0894130.1109930.110921 1.70.0818280.0964220.094049 1.80.0750730.0834020.078950 1.90.0690480.0718630.065616 2.00.0636620.0617120.053991 2.10.0588370.0528370.043984 2.20.0545050.0451240.035475 0.0506060.0384520.028327 2.40.0470870.0327080.022395 2.50.0439050.0277800.017528 2.60.0410190.0235670.013583 2.70.0383970.0199750.010421 2.80.0360080.0169190.007915 2.90.0338270.0143250.005953 3.00.0318310.0121260.004432 3.10.0300010.0102650.003267 3.20.0283190.0086910.002384 3.30.0267710.0073610.001723 3.40.0253430.0062370.001232 3.50.0240230.0052880.000873 3.60.0228020.0044870.000612 3.70.0216680.0038100.000425 3.80.0206160.0032380.000292 3.90.0196370.0027550.000199 4.00.0187240.0023460.000134

0.7 0.213631 0.297682 0.312254 0.8 0.194091 0.275232 0.289692 0.9 0.175862 0.252196 0.266085 1.0 0.159155 0.229131 0.241971 1.1 0.144032 0.206516 0.217852 1.2 0.130455 0.184748 0.194186 1.3 0.118331 0.164133 0.171369 1.4 0.107537 0.144887 0.149727 1.5 0.097942 0.127151 0.129518 1.6 0.089413 0.110993 0.110921 1.7 0.081828 0.096422 0.094049 1.8 0.075073 0.083402 0.078950 1.9 0.069048 0.071863 0.065616 2.0 0.063662 0.061712 0.053991 2.1 0.058837 0.052837 0.043984 2.2 0.054505 0.045124 0.035475 2.3 0.050606 0.038452 0.028327 2.4 0.047087 0.032708 0.022395 2.5 0.043905 0.027780 0.017528 2.6 0.041019 0.023567 0.013583 2.7 0.038397 0.019975 0.010421 2.8 0.036008 0.016919 0.007915 2.9 0.033827 0.014325 0.005953 3.0 0.031831 0.012126 0.004432 3.1 0.030001 0.010265 0.003267 3.2 0.028319 0.008691 0.002384 3.3 0.026771 0.007361 0.001723 3.4 0.025343 0.006237 0.001232 3.5 0.024023 0.005288 0.000873 3.6 0.022802 0.004487 0.000612 3.7 0.021668 0.003810 0.000425 3.8 0.020616 0.003238 0.000292 3.9 0.019637 0.002755 0.000199 4.0 0.018724 0.002346 0.000134

f( t分布1 t分布2 正态分布 小.3 0.3 /0.2 0.2 0.1 0 t

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

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

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