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Š H^ Š^ 1 5 30 11 2 1 5 0.54 3 3 12 3.5 4 9 62 22 5 10 96 38.5 6 2 18 1.6 7 4 23 5.6 8 6 35 10.2 9 7 42 16 10 6 23 18.2 11 2 13 4.1 12 9 76 31 13 2 12 2.9 14 1 4 0.4 15 4 19 8.1 16 7 51 25 17 3 15 6.2 18 10 89 45 19 8 64 37 20 3 10 6.1 r2 rZH 0.952386428 rHŠ.Z rZŠ 0.933616856 0.596156613 0.355402707 rHŠ 0.954285277 0.910660389