中国高校课件下载中心 》 教学资源 》 大学文库

《EXCEL统计分析》09.5 卡方分布电脑实验

文档信息
资源类别:文库
文档格式:XLS
文档页数:6
文件大小:36.5KB
团购合买:点击进入团购
内容简介
《EXCEL统计分析》09.5 卡方分布电脑实验
刷新页面文档预览

卡方值卡方分布1卡方分布2卡方分布3卡方分布4 0.0 0卡方分布1自由度 0.20.8071710.452190.1614340.002262卡方分布2自由度 0.40.5164420.4093650.2065770.008187卡方分布3自由度 0.60.3815450.3704090.2289270.01668方分布4自由度 0.80.2989840.3351600.2391870.026813 1.00.2419710.3032650.2419710.037908 1998680.2744060.2398410.049393 1.40.1674330.2482930.2344060.060832 1.60.1417150.2246640.2267430.071893 1.80.1208950.2032850.2176110.082330 2.00.1037770.1839400.2075540.091970 2.20.0895310.1664360.1969690.100694 2.40.0775620.1505970.1861500.108430 2.60.0674280.1362660.1753130.115145 2. 0.0587920.123298 1646180.120833 3.00.0513930.1115650.1541800.125511 3.20.0450260.1009480.1440830.129214 3 0.0395250.0913420.1343840.131989 3.60.0347560.0826490.1251210.133892 3.80.0306100.0747840.1163170.134986 4.00.0269950.0676680.1079820.135335 4.20.0238380.061228 1001190.135008 4.40.0210730.0554020.0927230.134072 4.60.0186490.0501290.0857850.132592 4.80.0165190.0453590.0792910.130634 5.00.0146450.0410420.0732250.128258 5.20.0129940.0371370.0675690.125522 5.40.0115380.033603 0623030.122482 5.60.0102520.0304050.0574090.119188 5.80.0091150.0275120.0528650.115686 6.00.0081090.0248940.0486520.112021 6.20.0072180.0225250.0447500.108231 6.40.0064280.0203810.0411390.104351 6.60.0057280.0184420.0378020.100414 .0051060.016687 0347190.096449 7.00.0045530.0150990.0318730.092479 7.20.0040620.0136620.0292490.088529 7.40.0036260.0123620.0268310.084616 7.60.0032370.0111850.0246040.080758 7.80.0028910.0101210.0225530.076970 8.00.0025830.0091580.0206670.073263 8.20.0023090.0082860.0189330.069647 8.40.0020640.0074980.0173390.066130 8.60.0018460.0067840.0158740.062721 8.80.0016510.0061390.0145300.059422 9.00.0014770.0055540.0132960.056239

卡方值 卡方分布1 卡方分布2 卡方分布3 卡方分布4 0.0 0 0 卡方分布1 自由度 0.2 0.807171 0.452419 0.161434 0.002262 卡方分布2 自由度 0.4 0.516442 0.409365 0.206577 0.008187 卡方分布3 自由度 0.6 0.381545 0.370409 0.228927 0.016668 卡方分布4 自由度 0.8 0.298984 0.335160 0.239187 0.026813 1.0 0.241971 0.303265 0.241971 0.037908 1.2 0.199868 0.274406 0.239841 0.049393 1.4 0.167433 0.248293 0.234406 0.060832 1.6 0.141715 0.224664 0.226743 0.071893 1.8 0.120895 0.203285 0.217611 0.082330 2.0 0.103777 0.183940 0.207554 0.091970 2.2 0.089531 0.166436 0.196969 0.100694 2.4 0.077562 0.150597 0.186150 0.108430 2.6 0.067428 0.136266 0.175313 0.115145 2.8 0.058792 0.123298 0.164618 0.120833 3.0 0.051393 0.111565 0.154180 0.125511 3.2 0.045026 0.100948 0.144083 0.129214 3.4 0.039525 0.091342 0.134384 0.131989 3.6 0.034756 0.082649 0.125121 0.133892 3.8 0.030610 0.074784 0.116317 0.134986 4.0 0.026995 0.067668 0.107982 0.135335 4.2 0.023838 0.061228 0.100119 0.135008 4.4 0.021073 0.055402 0.092723 0.134072 4.6 0.018649 0.050129 0.085785 0.132592 4.8 0.016519 0.045359 0.079291 0.130634 5.0 0.014645 0.041042 0.073225 0.128258 5.2 0.012994 0.037137 0.067569 0.125522 5.4 0.011538 0.033603 0.062303 0.122482 5.6 0.010252 0.030405 0.057409 0.119188 5.8 0.009115 0.027512 0.052865 0.115686 6.0 0.008109 0.024894 0.048652 0.112021 6.2 0.007218 0.022525 0.044750 0.108231 6.4 0.006428 0.020381 0.041139 0.104351 6.6 0.005728 0.018442 0.037802 0.100414 6.8 0.005106 0.016687 0.034719 0.096449 7.0 0.004553 0.015099 0.031873 0.092479 7.2 0.004062 0.013662 0.029249 0.088529 7.4 0.003626 0.012362 0.026831 0.084616 7.6 0.003237 0.011185 0.024604 0.080758 7.8 0.002891 0.010121 0.022553 0.076970 8.0 0.002583 0.009158 0.020667 0.073263 8.2 0.002309 0.008286 0.018933 0.069647 8.4 0.002064 0.007498 0.017339 0.066130 8.6 0.001846 0.006784 0.015874 0.062721 8.8 0.001651 0.006139 0.014530 0.059422 9.0 0.001477 0.005554 0.013296 0.056239

9.20.0013220.0050260.0121630.053174 9.40.0011830.0045480.0111250.050229 9.60.0010600.0041150.0101730.047403 9.80.000990.0037230.0093000.044698 10.00.0008500. 0085000.042112 10 0.0007620.0030480.0077680.039644 10.40.0006820.0027580.0070970.037292 10.60.0006120.0024960.0064830.035053 10.80.0005480.0022580.0059220.032926 11.00.0004920.0020430.0054070.030906 20.0004410.0018490.0049370.02899 1.40.0003950.0016730.0045070.027178 11.60.0003550.0015140.0041140.025462 11.80.0003180.0013700.0037540.023840 12.00.0002850.0012390.0034260.022309 12.20.0002560.0011210.0031250.020864 0.0002300.0010150.0028510.019503 12.60.0002060.000918 0026000.01822 12.80.0001850.0008310.0023720.017014 13.00.0001660.0007520.0021630.015880 13.20.0001490.0006800.0019720.014814 13.40.0001340.0006150.0017980.013814 13.60.0001200.0005570.0016390.012875 13.80.0001080.0005040.0014940.011995 0000970.0004560.0013610.011171 14.20.0000870.0004130.0012400.010398 14.40.0000780.0003730.0011300.009676 14.60.0000710.0003380.0010300.009000 14.80.0000630.0003060.0009380.008368 15.00.0000570.0002770.0008550.007778 5.20.0000510.00025 0007780.007227 15.40.0000460.0002260.0007090.006712 15.60.0000410.0002050.0006460.006232 15.80.0000370.0001850.0005880.005785 16.00.0000330.0001680.0005350.005367 16.20.0000300.0001520.0004870.004979 6.40.0000270.0001370.0004440.004617 0000240.000124 0004040.004280 16.80.0000220.0001120.0003680.003967 17.00.0000200.0001020.0003350.003675 17.20.0000180.0000920.0003050.003404 17.40.0000160.0000830.0002770.003152 17.60.0000140.0000750.0002520.002918 17.80.0000130.0000680.0002300.00270 18.00.0000120.0000620.0002090.002499 18.20.0000100.0000560.0001900.002312 18.40.0000090.0000510.0001730.002138 18.60.0000080.0000460.0001570.001977

9.2 0.001322 0.005026 0.012163 0.053174 9.4 0.001183 0.004548 0.011125 0.050229 9.6 0.001060 0.004115 0.010173 0.047403 9.8 0.000949 0.003723 0.009300 0.044698 10.0 0.000850 0.003369 0.008500 0.042112 10.2 0.000762 0.003048 0.007768 0.039644 10.4 0.000682 0.002758 0.007097 0.037292 10.6 0.000612 0.002496 0.006483 0.035053 10.8 0.000548 0.002258 0.005922 0.032926 11.0 0.000492 0.002043 0.005407 0.030906 11.2 0.000441 0.001849 0.004937 0.028991 11.4 0.000395 0.001673 0.004507 0.027178 11.6 0.000355 0.001514 0.004114 0.025462 11.8 0.000318 0.001370 0.003754 0.023840 12.0 0.000285 0.001239 0.003426 0.022309 12.2 0.000256 0.001121 0.003125 0.020864 12.4 0.000230 0.001015 0.002851 0.019503 12.6 0.000206 0.000918 0.002600 0.018221 12.8 0.000185 0.000831 0.002372 0.017014 13.0 0.000166 0.000752 0.002163 0.015880 13.2 0.000149 0.000680 0.001972 0.014814 13.4 0.000134 0.000615 0.001798 0.013814 13.6 0.000120 0.000557 0.001639 0.012875 13.8 0.000108 0.000504 0.001494 0.011995 14.0 0.000097 0.000456 0.001361 0.011171 14.2 0.000087 0.000413 0.001240 0.010398 14.4 0.000078 0.000373 0.001130 0.009676 14.6 0.000071 0.000338 0.001030 0.009000 14.8 0.000063 0.000306 0.000938 0.008368 15.0 0.000057 0.000277 0.000855 0.007778 15.2 0.000051 0.000250 0.000778 0.007227 15.4 0.000046 0.000226 0.000709 0.006712 15.6 0.000041 0.000205 0.000646 0.006232 15.8 0.000037 0.000185 0.000588 0.005785 16.0 0.000033 0.000168 0.000535 0.005367 16.2 0.000030 0.000152 0.000487 0.004979 16.4 0.000027 0.000137 0.000444 0.004617 16.6 0.000024 0.000124 0.000404 0.004280 16.8 0.000022 0.000112 0.000368 0.003967 17.0 0.000020 0.000102 0.000335 0.003675 17.2 0.000018 0.000092 0.000305 0.003404 17.4 0.000016 0.000083 0.000277 0.003152 17.6 0.000014 0.000075 0.000252 0.002918 17.8 0.000013 0.000068 0.000230 0.002701 18.0 0.000012 0.000062 0.000209 0.002499 18.2 0.000010 0.000056 0.000190 0.002312 18.4 0.000009 0.000051 0.000173 0.002138 18.6 0.000008 0.000046 0.000157 0.001977

18.80.0000080.0000410.0001430.001827 19.00.0000070.0000370.0001300.001689 19.20.0000060.0000340.0001180.001560 19.40.0000060.0000310.0001080.001442 19.60.0000050.0000280.0000980.001331 19.80.0000040.0000250.0000890.001229 20.00.0000040.0000230.0000810.001135

18.8 0.000008 0.000041 0.000143 0.001827 19.0 0.000007 0.000037 0.000130 0.001689 19.2 0.000006 0.000034 0.000118 0.001560 19.4 0.000006 0.000031 0.000108 0.001442 19.6 0.000005 0.000028 0.000098 0.001331 19.8 0.000004 0.000025 0.000089 0.001229 20.0 0.000004 0.000023 0.000081 0.001135

0.5 一卡方分布1 卡方分布2 卡方分布3 卡方分布4 0.3 0.0 9 15 卡方值

1236

已到末页,全文结束
刷新页面下载完整文档
VIP每日下载上限内不扣除下载券和下载次数;
按次数下载不扣除下载券;
注册用户24小时内重复下载只扣除一次;
顺序:VIP每日次数-->可用次数-->下载券;
相关文档