Tõenäosusteooria ja matemaatiline statistika kodune KT 2014 (0)

Overview

Lähttabel
Ülesanne

Sheet 1: Lähttabel

Kood_i Sugu Vanusgrupp V03C V27C V30C V34C V36C V37C V38C V41C V42C 17 2 45-54 26653.99594 10777.38558 0 17559.738 8389.79414 0 215492.61882 5952 3226.5396 18 2 45-54 14138.93645 391.07718 389.35191 12355.128 4474.29667 0 0 1199 .28 1583.32928 39 2 45-54 15984.96824 10809.50175 0 4956.993 1273.06315 605.904 32868.42397 1866.4788 4062.9888 57 2 45-54 11514.19847 0 3897.66 3221.7108 0 568.9728 0 1833.48 0 73 2 45-54 20280.34632 572.18382 0 20077.368 2840.92895 938.3218 8159.919 4110.96 6870.68406 77 2 45-54 857.74965 326.17 0 6116.3376 0 0 1672.1352 741.168 0 84 2 45-54 15278.39822 0 490.72053 9179.9568 4573.88442 0 4845.92 4173.43133 13334.81268 88 2 45-54 8189.97903 462.34698 2322.69856 7176.8592 9004.67066 0 2835.42435 2219.616 6890.76118 92 2 45-54 12823.92535 11974.15076 0 9915.38857 439.0386 5679.39528 2524.98025 2028.372 5292.44082 106 2 45-54 7414.76883 646.81656 0 6266.34 0 0 0 2579.2 0 107 2 45-54 24619.25399 2276.5561 809.08967 2028.6552 1943.565 808.418 9828.61941 9297.84333 1620 .04725 130 2 45-54 15525.1035 5858.16192 7127.20008 3622.239 185.8766 2123.28 12375.5392 600.18 2745.6793 151 2 45-54 8027.29526 0 0 2038.26 0 1007.14562 678.50467 1575.68 329.44 153 2 45-54 13666.38811 0 0 20243.076 0 3222 .06456 0 5807.73 3989.24526 161 2 45-54 4929.02315 2647.6359 0 2161.4208 8509.536 0 9912.75748 2040.4 4588.47133 180 2 45-54 16504.68318 1379.49552 261.46553 3961.16 122.74349 622.208 0 3287.68 4907.18654 198 2 45-54 12556.20129 4424.4928 0 8816.792 406.20294 3765.51293 5849.97227 3936 10060.77432 199 2 45-54 14054.21269 1375.44004 0 12138.18 363.67682 1310.27 2959.112 2345 .04 0 201 2 45-54 10920.73488 0 3423.42 6516.496 2566.616 0 4071.808 1192 .2 132.041 206 2 45-54 9626.5246 348.35892 0 10672.338 128.04363 1157.21944 0 1526.25 0 240 2 45-54 9763.15926 3644.43222 6312.11217 9344.16 148.26955 1974.0672 7172.2794 3982.68 4496.63226 251 2 45-54 15785.08186 2776.4698 233.02578 7752.42 105.72965 0 0 2455.44 2052.973 252 2 45-54 7140.94127 0 0 3885.5716 1020.30062 1558.72 957.814 815.04 0 266 2 45-54 6470.62909 0 0 7372.8 1960.32 2601.37406 0 0 7599.68 286 2 45-54 29320.39188 0 0 36454.8384 1176.38235 0 22289.80647 10735.28776 1070 .5966 293 2 45-54 8250.70334 0 0 7035.12 159.91625 490.032 61443.9 4590.45 4808.56816 308 2 45-54 11439.42979 134.43495 583.29122 6383.9141 1625.06274 0 290.3032 4106.76 2247 .02218 310 2 45-54 13518.99742 309.07985 32201.85627 3683.7856 5009.718 26915.83683 10043.1454 809.68 6636.91644 336 2 45-54 10821.84952 0 211.68333 9844.3168 0 747.79813 0 2029.6 3120.87917 385 2 45-54 12114.13655 4752.1175 0 6467.274 0 5632.128 2418.24 4302.9 0 390 2 45-54 12060.69965 374.5118 7186.8264 7210.94246 9974.8777 0 19761.88009 1215 2039.69927 402 2 45-54 9241.6855 0 0 3507.4476 355.72446 0 632.99925 2377.68 0 403 2 45-54 14662.33798 0 0 11022.48 126.05645 0 13722.5455 3075.3 925.17156 407 2 45-54 3157.74202 0 0 2914.8048 0 0 3048.85941 1341.36 304.60664 416 2 45-54 13973.20764 0 0 5214.7512 0 0 0 2112.264 0 422 2 45-54 15194.38281 2319.01114 15042.5028 3909.20904 3023.46559 4297.29758 6997.91456 3258.32346 5990.25617 436 2 45-54 11751.76275 1713.85517 906.71464 15137.44 2077.13506 1074.29348 5845.46285 0 10680.32503 443 2 45-54 13952.41158 7198.48584 2528.24 5183.13 5058.64079 614.41809 1329.9624 2038.47 5932.95456 447 2 45-54 18887.08068 5119.64787 2233.88811 46491.77305 28609.11335 23829.03075 24013.93297 15988.8 29206.00026 461 2 45-54 9560.55074 0 89.726 11023.08 0 323.44 7518.95948 3946.02 13474.86011 463 2 45-54 16913.3679 0 0 6376.032 1378.3666 0 0 1728 .048 0 470 2 45-54 10005.19631 4734.756 258.14646 11606.244 2551.28328 0 0 1446.192 0 488 2 45-54 5652.87168 3808.01421 0 8781.7422 0 0 7062.48 2972.7 687.23044

Sheet 2: Ülesanne

Kood_i Sugu Vanusgrupp V03C V34C V03C^2 V03C*V34C
V03C V34C
17 2 45-54 26653.99594 17559.738 710435499.569537 468037185.359464
n 43 43
18 2 45-54 14138.93645 12355.128 199909523.937139 174688369.623616
aritmeetiline keskmine 12633 9433
39 2 45-54 15984.96824 4956.993 255519209.633809 79237375.6709023
mediaan 12114 7177
57 2 45-54 11514.19847 3221.7108 132576766.40655 37095417.5641425
1- kvartiil 9401 4459
73 2 45-54 20280.34632 20077.368 411292446.859138 407175976.234086
2-kvartiil 12114 7177
77 2 45-54 857.74965 6116.3376 735734.462075122 5246286.43568184
3-kvartiil 15236 10847
84 2 45-54 15278.39822 9179.9568 233429452.168899 140255035.632797
minimaalne väärtus 858 2029
88 2 45-54 8189.97903 7176.8592 67075756.5118397 58778326.3492626
maksimaalne väärtus 29320 46492
92 2 45-54 12823.92535 9915.38857 164453061.382373 127154202.837923
standardhälbe (S) 5678 8498 106 2 45-54 7414.76883 6266.34 54978796.8023396 46463462.5101822
E(β=0,95) 1697 2540 107 2 45-54 24619.25399 2028.6552 606107667.024131 49943977.6269342
min 10936 6893 130 2 45-54 15525.1035 3622.239 241028838.685712 56235635.3767365
max 14330 11973 151 2 45-54 8027.29526 2038.26 64437469.1912185 16361714.8366476
Usaldusvahemik β=0,95 (10936;14330) (6893;11973) 153 2 45-54 13666.38811 20243.076 186770163.973149 276649733.156226
E(β=0,99) 2251 3369 161 2 45-54 4929.02315 2161.4208 24295269.2132359 10653693.1600915
min 10381 6064 180 2 45-54 16504.68318 3961.16 272404566.872175 65377690.8252888
max 14884 12803 198 2 45-54 12556.20129 8816.792 157658190.834998 110705415.084062
Usaldusvahemik β=0,99 (10381;14884) (6064;12803) 199 2 45-54 14054.21269 12138.18 197520894.335757 170592563.389504
E(β=0,95) 1749 2618 201 2 45-54 10920.73488 6516.496 119262450.319249 71164925.1625805
min 10884 6815 206 2 45-54 9626.5246 10672.338 92669975.8744052 102737524.296515
max 14382 12051 240 2 45-54 9763.15926 9344.16 95319278.7361238 91228522.2309216
Usaldusvahemik β=0,95 (10884;14382) (6815;12051) 251 2 45-54 15785.08186 7752.42 249168809.326901 122372584.313101
E(β=0,99) 2338 3499 252 2 45-54 7140.94127 3885.5716 50993042.2215892 27746638.5959799
min 10295 5934 266 2 45-54 6470.62909 7372.8 41869040.8203542 47706654.154752
max 14971 12932 286 2 45-54 29320.39188 36454.8384 859685379.99677 1068870147.81007
Usaldusvahemik β=0,99 (10295;14971) (5934;12932) 293 2 45-54 8250.70334 7035.12 68074105.6046872 58044688.0813008
Kxy 23900691
308 2 45-54 11439.42979 6383.9141 130860553.920339 73028337.132341
r(xy) 0.495 - Toidu- ja eluasekulud korreleeruvad
310 2 45-54 13518.99742 3683.7856 182763291.241967 49801088.0222332
336 2 45-54 10821.84952 9844.3168 117112427.033524 106533715.036808
385 2 45-54 12114.13655 6467.274 146752304.352046 78345440.3422647
390 2 45-54 12060.69965 7210.94246 145460476.04751 86969011.2034922
402 2 45-54 9241.6855 3507.4476 85408750.8809102 32414727.6269298
403 2 45-54 14662.33798 11022.48 214984155.03975 161615327.13779
407 2 45-54 3157.74202 2914.8048 9971334.66487368 9204201.5970577
416 2 45-54 13973.20764 5214.7512 195250531.750554 72866801.3085392
422 2 45-54 15194.38281 3909.20904 230869268.976823 59398018.6380726
436 2 45-54 11751.76275 15137.44 138103927.732288 177891603.52236
443 2 45-54 13952.41158 5183.13 194669788.897718 72317163.0326454
447 2 45-54 18887.08068 46491.77305 356721816.612829 878093868.5516
461 2 45-54 9560.55074 11023.08 91404130.4521146 105386715.651079
463 2 45-54 16913.3679 6376.032 286062013.72075 107840174.958173
470 2 45-54 10005.19631 11606.244 100103953.201638 116122749.64176
488 2 45-54 5652.87168 8781.7422 31954958.230546 49642061.7834409