i V(ýška) H(motnost) P(ohlaví) Vi-mV Hi-mH zVi zHi zVi x zHi 1 172 85 1 -0.7 9.75 -0.050012088 0.614080057 -0.030711426 2 170 59 0 -2.7 -16.25 -0.192903769 -1.023466761 0.197430595 3 149 86 0 -23.7 10.75 -1.693266414 0.677062627 -1.146447405 pokračování výpočtem z-skórů a následně korelací 4 176 79 1 3.3 3.75 0.235771273 0.236184637 0.055685553 následně graf 5 185 86 1 12.3 10.75 0.878783835 0.677062627 0.594991691 outlieři 6 162 57 0 -10.7 -18.25 -0.76447049 -1.149431901 0.878706769 7 182 73 1 9.3 -2.25 0.664446314 -0.141710782 -0.094159207 8 190 96 1 17.3 20.75 1.236013036 1.306888326 1.615331007 9 154 55 0 -18.7 -20.25 -1.336037212 -1.275397041 1.703977907 10 167 63 1 -5.7 -12.25 -0.407241289 -0.771536481 0.314201511 11 204 93 0 31.3 17.75 2.236254799 1.117940616 2.500000068 12 155 52 1 -17.7 -23.25 -1.264591372 -1.46434475 1.851797737 13 174 80 1 1.3 4.75 0.092879592 0.299167207 0.027786528 14 185 110 0 12.3 34.75 0.878783835 2.188644305 1.923345235 15 169 70 1 -3.7 -5.25 -0.264349609 -0.330658492 0.087409443 16 173 65 0 0.3 -10.25 0.021433752 -0.645571342 -0.013837016 17 189 74 0 16.3 -1.25 1.164567196 -0.078728212 -0.091684294 18 154 60 0 -18.7 -15.25 -1.336037212 -0.960484191 1.283242621 19 176 68 1 3.3 -7.25 0.235771273 -0.456623632 -0.107658735 Statistická významnost V(ýška) H(motnost) 20 168 94 0 -4.7 18.75 -0.335795449 1.180923186 -0.396548632 t 3.076114836 V(ýška) 1 df 18 H(motnost) 0.586992629 1 m 172.7 75.25 0.5 kontrola r2 p-hodnota 0.006510526 s 13.99661613 15.87740864 rVH 0.586992629 0.586992629 0.344560347 kontrola m 172.7 75.25 0.5 8.29892E-16 0 s 13.99661613 15.87740864 0.512989176 1 1 ##### Sheet/List 2 ##### i V(ýška) H(motnost) P(ohlaví) Vi-mV Hi-mH zVi zHi zVi x zHi 2 170 59 0 -2.7 -16.25 -0.192903769 -1.023466761 0.197430595 3 149 86 0 -23.7 10.75 -1.693266414 0.677062627 -1.146447405 6 162 57 0 -10.7 -18.25 -0.76447049 -1.149431901 0.878706769 pokračování výpočtem z-skórů a následně korelací 9 154 55 0 -18.7 -20.25 -1.336037212 -1.275397041 1.703977907 následně graf ženy muži Dvouvýběrový t-test s rovností rozptylů Dvouvýběrový t-test s nerovností rozptylů 11 204 93 0 31.3 17.75 2.236254799 1.117940616 2.500000068 outlieři 170 172 14 185 110 0 12.3 34.75 0.878783835 2.188644305 1.923345235 149 176 ženy muži ženy muži 16 173 65 0 0.3 -10.25 0.021433752 -0.645571342 -0.013837016 162 185 Stř. hodnota 170.8 174.6 Stř. hodnota 170.8 174.6 17 189 74 0 16.3 -1.25 1.164567196 -0.078728212 -0.091684294 154 182 Rozptyl 307.2888889 98.26666667 Rozptyl 307.2888889 98.26666667 18 154 60 0 -18.7 -15.25 -1.336037212 -0.960484191 1.283242621 204 190 Pozorování 10 10 Pozorování 10 10 20 168 94 0 -4.7 18.75 -0.335795449 1.180923186 -0.396548632 185 167 Společný rozptyl 202.7777778 Hyp. rozdíl stř. hodnot 0 1 172 85 1 -0.7 9.75 -0.050012088 0.614080057 -0.030711426 173 155 Hyp. rozdíl stř. hodnot 0 Rozdíl 14 4 176 79 1 3.3 3.75 0.235771273 0.236184637 0.055685553 189 174 Rozdíl 18 t Stat -0.596703272 5 185 86 1 12.3 10.75 0.878783835 0.677062627 0.594991691 154 169 t Stat -0.596703272 P(T<=t) (1) 0.280115834 7 182 73 1 9.3 -2.25 0.664446314 -0.141710782 -0.094159207 168 176 P(T<=t) (1) 0.279068322 t krit (1) 1.761310136 8 190 96 1 17.3 20.75 1.236013036 1.306888326 1.615331007 t krit (1) 1.734063607 P(T<=t) (2) 0.560231667 10 167 63 1 -5.7 -12.25 -0.407241289 -0.771536481 0.314201511 P(T<=t) (2) 0.558136644 t krit (2) 2.144786688 12 155 52 1 -17.7 -23.25 -1.264591372 -1.46434475 1.851797737 t krit (2) 2.10092204 13 174 80 1 1.3 4.75 0.092879592 0.299167207 0.027786528 15 169 70 1 -3.7 -5.25 -0.264349609 -0.330658492 0.087409443 Statistická významnost 19 176 68 1 3.3 -7.25 0.235771273 -0.456623632 -0.107658735 t 0.596703272 df 18 m 172.7 75.25 0.5 kontrola r2 p-hodnota 0.558136644 s 13.99661613 15.87740864 rVP 0.139273582 0.019397131 kontrola m 172.7 75.25 0.5 s 13.99661613 15.87740864 0.512989176 ##### Sheet/List 3 ##### i V(ýška) H(motnost) P(ohlaví) Vi-mV Hi-mH zVi zHi zVi x zHi Hi^ ei 1 172 85 1 -0.7 9.75 -0.050012088 0.614080057 -0.030711426 74.78389125 -10.21610875 2 170 59 0 -2.7 -16.25 -0.192903769 -1.023466761 0.197430595 73.45215195 14.45215195 3 149 86 0 -23.7 10.75 -1.693266414 0.677062627 -1.146447405 59.46888937 -26.53111063 a -39.74568803 4 176 79 1 3.3 3.75 0.235771273 0.236184637 0.055685553 77.44736984 -1.552630165 b 0.665869647 5 185 86 1 12.3 10.75 0.878783835 0.677062627 0.594991691 83.44019666 -2.559803342 6 162 57 0 -10.7 -18.25 -0.76447049 -1.149431901 0.878706769 68.12519478 11.12519478 H = a + bV + e 7 182 73 1 9.3 -2.25 0.664446314 -0.141710782 -0.094159207 81.44258772 8.442587717 8 190 96 1 17.3 20.75 1.236013036 1.306888326 1.615331007 86.76954489 -9.230455107 Hi^ = a + bVi 9 154 55 0 -18.7 -20.25 -1.336037212 -1.275397041 1.703977907 62.7982376 7.798237601 10 167 63 1 -5.7 -12.25 -0.407241289 -0.771536481 0.314201511 71.45454301 8.454543012 Hi = Hi^ + ei 11 204 93 0 31.3 17.75 2.236254799 1.117940616 2.500000068 96.09171995 3.091719951 12 155 52 1 -17.7 -23.25 -1.264591372 -1.46434475 1.851797737 63.46410725 11.46410725 z toho 13 174 80 1 1.3 4.75 0.092879592 0.299167207 0.027786528 76.11563054 -3.884369459 14 185 110 0 12.3 34.75 0.878783835 2.188644305 1.923345235 83.44019666 -26.55980334 ei = Hi^ - Hi 15 169 70 1 -3.7 -5.25 -0.264349609 -0.330658492 0.087409443 72.78628231 2.786282306 16 173 65 0 0.3 -10.25 0.021433752 -0.645571342 -0.013837016 75.44976089 10.44976089 SS 3139.39208 17 189 74 0 16.3 -1.25 1.164567196 -0.078728212 -0.091684294 86.10367525 12.10367525 18 154 60 0 -18.7 -15.25 -1.336037212 -0.960484191 1.283242621 62.7982376 2.798237601 19 176 68 1 3.3 -7.25 0.235771273 -0.456623632 -0.107658735 77.44736984 9.447369835 20 168 94 0 -4.7 18.75 -0.335795449 1.180923186 -0.396548632 72.12041266 -21.87958734 m 172.7 75.25 0.5 kontrola r2 s 13.99661613 15.87740864 rVH 0.586992629 0.586992629 0.344560347 kontrola rVe -4.53131E-16 m 172.7 75.25 0.5 8.29892E-16 0 RHe -0.809592276 s 13.99661613 15.87740864 0.512989176 1 1 R 0.586992629 R2 0.344560347 ##### Sheet/List 4 ##### i V(ýška) H(motnost) P(ohlaví) Vi-mV Hi-mH zVi zHi zVi x zHi Hi^ ei P(ohlaví) V(ýška) H(motnost) 1 172 85 1 -0.7 9.75 -0.050012088 0.614080057 -0.030711426 73.43364168 -11.56635832 1 172 85 VÝSLEDEK 2 170 59 0 -2.7 -16.25 -0.192903769 -1.023466761 0.197430595 74.75704619 15.75704619 a -40.74293176 0 170 59 3 149 86 0 -23.7 10.75 -1.693266414 0.677062627 -1.146447405 60.48940185 -25.51059815 b1 0.679411635 0 149 86 Regresní statistika 4 176 79 1 3.3 3.75 0.235771273 0.236184637 0.055685553 76.15128822 -2.848711778 b2 -2.682227773 1 176 79 Násobné R 0.593233009 5 185 86 1 12.3 10.75 0.878783835 0.677062627 0.594991691 82.26599294 -3.734007063 1 185 86 Hodnota spolehlivosti R 0.351925403 6 162 57 0 -10.7 -18.25 -0.76447049 -1.149431901 0.878706769 69.32175311 12.32175311 H = a + b1V + b2P + e 0 162 57 Nastavená hodnota spolehlivosti R 0.275681333 7 182 73 1 9.3 -2.25 0.664446314 -0.141710782 -0.094159207 80.22775803 7.227758032 1 182 73 Chyba stř. hodnoty 13.51277239 8 190 96 1 17.3 20.75 1.236013036 1.306888326 1.615331007 85.66305111 -10.33694889 Hi^ = a + b1Vi + b2Pi 1 190 96 Pozorování 20 9 154 55 0 -18.7 -20.25 -1.336037212 -1.275397041 1.703977907 63.88646003 8.886460026 0 154 55 10 167 63 1 -5.7 -12.25 -0.407241289 -0.771536481 0.314201511 70.03658351 7.036583508 Hi = Hi^ + ei 1 167 63 ANOVA 11 204 93 0 31.3 17.75 2.236254799 1.117940616 2.500000068 97.85704177 4.857041774 0 204 93 Rozdíl SS MS F Významnost F 12 155 52 1 -17.7 -23.25 -1.264591372 -1.46434475 1.851797737 61.88364389 9.883643888 z toho 1 155 52 Regrese 2 1685.634701 842.8173507 4.615774088 0.025050274 13 174 80 1 1.3 4.75 0.092879592 0.299167207 0.027786528 74.79246495 -5.207535048 1 174 80 Rezidua 17 3104.115299 182.5950176 14 185 110 0 12.3 34.75 0.878783835 2.188644305 1.923345235 84.94822071 -25.05177929 ei = Hi^ - Hi 0 185 110 Celkem 19 4789.75 15 169 70 1 -3.7 -5.25 -0.264349609 -0.330658492 0.087409443 71.39540678 1.395406778 1 169 70 16 173 65 0 0.3 -10.25 0.021433752 -0.645571342 -0.013837016 76.79528109 11.79528109 SS 3104.115384 snaha minimalizovat 0 173 65 Koeficienty Chyba stř. hodnoty t Stat Hodnota P Dolní 95% Horní 95% "Dolní 95,0%" "Horní 95,0%" 17 189 74 0 16.3 -1.25 1.164567196 -0.078728212 -0.091684294 87.66586725 13.66586725 0 189 74 Hranice -40.76912877 38.44022542 -1.06058506 0.303714932 -121.8709152 40.33265763 -121.8709152 40.33265763 18 154 60 0 -18.7 -15.25 -1.336037212 -0.960484191 1.283242621 63.88646003 3.886460026 R2 0.351925403 snaha maximalizovat 0 154 60 P(ohlaví) -2.682334247 6.102571541 -0.439541631 0.665805497 -15.55763475 10.19296626 -15.55763475 10.19296626 19 176 68 1 3.3 -7.25 0.235771273 -0.456623632 -0.107658735 76.15128822 8.151288222 1 176 68 V(ýška) 0.679561644 0.223665 3.038301227 0.007422476 0.207669743 1.151453545 0.207669743 1.151453545 20 168 94 0 -4.7 18.75 -0.335795449 1.180923186 -0.396548632 73.39822292 -20.60177708 0 168 94 m 172.7 75.25 0.5 kontrola r2 s 13.99661613 15.87740864 rVH 0.586992629 0.586992629 0.344560347 REZIDUA PRAVDĚPODOBNOST kontrola rVe -0.000163671 Pozorování Očekávané H(motnost) Rezidua Normovaná rezidua Percentil H(motnost) m 172.7 75.25 0.5 8.29892E-16 0 RHe -0.805127231 1 73.43313973 11.56686027 0.904947465 2.5 52 s 13.99661613 15.87740864 0.512989176 1 1 R 0.593233009 vícenásobná korelace (rHH^) 2 74.75635068 -15.75635068 -1.232717373 7.5 55 3 60.48555616 25.51444384 1.996153729 12.5 57 4 76.1513863 2.848613699 0.222864778 17.5 59 5 82.2674411 3.732558904 0.292021312 22.5 60 6 69.31985753 -12.31985753 -0.963859127 27.5 63 7 80.22875616 -7.228756164 -0.565550582 32.5 65 8 85.66524932 10.33475068 0.808551864 37.5 68 9 63.88336438 -8.883364384 -0.695000881 42.5 70 10 70.03533151 -7.035331507 -0.550417768 47.5 73 11 97.86144658 -4.861446575 -0.380341221 52.5 74 12 61.88059178 -9.880591781 -0.773020186 57.5 79 13 74.79226301 5.207736986 0.407433674 62.5 80 14 84.94977534 25.05022466 1.959834974 67.5 85 15 71.39445479 -1.394454795 -0.109096877 72.5 86 16 76.79503562 -11.79503562 -0.922799042 77.5 86 17 87.66802192 -13.66802192 -1.069334417 82.5 93 18 63.88336438 -3.883364384 -0.303819764 87.5 94 19 76.1513863 -8.151386301 -0.63773368 92.5 96 20 73.3972274 20.6027726 1.611883121 97.5 110 ##### Sheet/List 5 ##### i Z(ávažnost) H(asiči) Š(koda) zZ zH zŠ zH^ zŠ^ ezH ezŠ nestandardizované H^ Š^ eH eŠ 1 5 30 11 -0.033063735 -0.173424819 -0.262019268 -0.031489453 -0.030868861 -0.141935367 -0.231150407 34.05120829 14.21734177 -4.051208285 -3.217341772 2 1 5 0.54 -1.355613144 -1.049307745 -1.013519554 -1.291067559 -1.265623281 0.241759814 0.252103728 -1.900460299 -2.968987342 6.900460299 3.508987342 3 3 12 3.5 -0.69433844 -0.804060526 -0.800857905 -0.661278506 -0.648246071 -0.14278202 -0.152611834 16.07537399 5.624177215 -4.075373993 -2.124177215 4 9 62 22 1.289485674 0.947705326 0.5282774 1.228088654 1.20388556 -0.280383328 -0.67560816 70.00287687 31.40367089 -8.00287687 -9.403670886 5 10 96 38.5 1.620123026 2.138906105 1.713722401 1.542983181 1.512574165 0.595922924 0.201148236 78.99079402 35.70025316 17.00920598 2.799746835 6 2 18 1.6 -1.024975792 -0.593848624 -0.937363693 -0.976173033 -0.956934676 0.382324409 0.019570983 7.087456847 1.327594937 10.91254315 0.272405063 7 4 23 5.6 -0.363701087 -0.418672039 -0.649983086 -0.346383979 -0.339557466 -0.072288059 -0.310425621 25.06329114 9.920759494 -2.063291139 -4.320759494 8 6 35 10.2 0.297573617 0.001751766 -0.319495389 0.283405074 0.277819745 -0.281653308 -0.597315134 43.03912543 18.51392405 -8.039125432 -8.313924051 9 7 42 16 0.628210969 0.246998985 0.09720649 0.598299601 0.58650835 -0.351300616 -0.48930186 52.02704258 22.81050633 -10.02704258 -6.810506329 10 6 23 18.2 0.297573617 -0.418672039 0.255265824 0.283405074 0.277819745 -0.702077113 -0.022553921 43.03912543 18.51392405 -20.03912543 -0.313924051 11 2 13 4.1 -1.024975792 -0.769025209 -0.757750814 -0.976173033 -0.956934676 0.207147824 0.199183862 7.087456847 1.327594937 5.912543153 2.772405063 12 9 76 31 1.289485674 1.438199764 1.174883764 1.228088654 1.20388556 0.21011111 -0.029001796 70.00287687 31.40367089 5.99712313 -0.403670886 13 2 12 2.9 -1.024975792 -0.804060526 -0.843964996 -0.976173033 -0.956934676 0.172112507 0.11296968 7.087456847 1.327594937 4.912543153 1.572405063 14 1 4 0.4 -1.355613144 -1.084343062 -1.023577875 -1.291067559 -1.265623281 0.206724497 0.242045406 -1.900460299 -2.968987342 5.900460299 3.368987342 15 4 19 8.1 -0.363701087 -0.558813307 -0.470370207 -0.346383979 -0.339557466 -0.212429327 -0.130812742 25.06329114 9.920759494 -6.063291139 -1.820759494 16 7 51 25 0.628210969 0.562316838 0.743812854 0.598299601 0.58650835 -0.035982762 0.157304505 52.02704258 22.81050633 -1.027042578 2.189493671 17 3 15 6.2 -0.69433844 -0.698954575 -0.606875996 -0.661278506 -0.648246071 -0.037676069 0.041370075 16.07537399 5.624177215 -1.075373993 0.575822785 18 10 89 45 1.620123026 1.893658886 2.180715886 1.542983181 1.512574165 0.350675705 0.668141721 78.99079402 35.70025316 10.00920598 9.299746835 19 8 64 37 0.958848321 1.01777596 1.605954674 0.913194127 0.895196955 0.104581832 0.710757719 61.01495972 27.10708861 2.985040276 9.892911392 20 3 10 6.1 -0.69433844 -0.87413116 -0.614060511 -0.661278506 -0.648246071 -0.212852654 0.03418556 16.07537399 5.624177215 -6.075373993 0.475822785 m 5.1 34.95 14.647 1.33227E-16 -7.77156E-17 0 sd 3.024461675 28.5426274 13.91882372 1 1 1 Podle vzorce Pomocí funkce na základě analýzy r2 rZH 0.952386428 rHŠ.Z r2 b1 0.952386428 rHŠ.Z rHŠ.Z rZŠ 0.933616856 0.596156613 0.355402707 b2 0.933616856 0.596156613 0.596156613 rHŠ 0.954285277 0.910660389 pro nestandardizovaná data bb1 8.987917146 bb2 4.296582278 a1 -10.88837745 a2 -7.26556962 ##### Sheet/List 6 ##### A a d B i k b e j l c f A * B a*i+d*j a*k+d*l b*i+e*j b*k+e*l c*i+f*j c*k+f*l B b1 BT b1 b2 b3 b4 b5 b2 b3 B*BT b1b1 b1b2 b1b3 b1b4 b1b5 b4 b2b1 b2b2 b2b3 b2b4 b2b5 b5 B 1 BT 1 2 3 5 7 2 3 B*BT 1 2 3 5 7 5 2 4 6 10 14 7 3 6 9 15 21 5 10 15 25 35 7 14 21 35 49 B 1 10 BT 1 2 3 5 7 2 20 10 20 30 40 50 3 30 5 40 B*BT 101 202 303 405 507 7 50 202 404 606 810 1014 303 606 909 1215 1521 405 810 1215 1625 2035 507 1014 1521 2035 2549