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 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 1 172 85 1 -0.7 9.75 -0.050012088 0.614080057 -0.030711426 120.8 35.8 2 170 59 0 -2.7 -16.25 -0.192903769 -1.023466761 0.197430595 119.5 60.5 a 26 3 149 86 0 -23.7 10.75 -1.693266414 0.677062627 -1.146447405 107.95 21.95 b1 0.55 4 176 79 1 3.3 3.75 0.235771273 0.236184637 0.055685553 123 44 b2 0.2 5 185 86 1 12.3 10.75 0.878783835 0.677062627 0.594991691 127.95 41.95 6 162 57 0 -10.7 -18.25 -0.76447049 -1.149431901 0.878706769 115.1 58.1 H = a + b1V + b2P + e 7 182 73 1 9.3 -2.25 0.664446314 -0.141710782 -0.094159207 126.3 53.3 8 190 96 1 17.3 20.75 1.236013036 1.306888326 1.615331007 130.7 34.7 Hi^ = a + b1Vi + b2Pi 9 154 55 0 -18.7 -20.25 -1.336037212 -1.275397041 1.703977907 110.7 55.7 10 167 63 1 -5.7 -12.25 -0.407241289 -0.771536481 0.314201511 118.05 55.05 Hi = Hi^ + ei 11 204 93 0 31.3 17.75 2.236254799 1.117940616 2.500000068 138.2 45.2 12 155 52 1 -17.7 -23.25 -1.264591372 -1.46434475 1.851797737 111.45 59.45 z toho 13 174 80 1 1.3 4.75 0.092879592 0.299167207 0.027786528 121.9 41.9 14 185 110 0 12.3 34.75 0.878783835 2.188644305 1.923345235 127.75 17.75 ei = Hi^ - Hi 15 169 70 1 -3.7 -5.25 -0.264349609 -0.330658492 0.087409443 119.15 49.15 16 173 65 0 0.3 -10.25 0.021433752 -0.645571342 -0.013837016 121.15 56.15 SS 45210.89 snaha minimalizovat 17 189 74 0 16.3 -1.25 1.164567196 -0.078728212 -0.091684294 129.95 55.95 18 154 60 0 -18.7 -15.25 -1.336037212 -0.960484191 1.283242621 110.7 50.7 R2 0.343174847 snaha maximalizovat 19 176 68 1 3.3 -7.25 0.235771273 -0.456623632 -0.107658735 123 55 20 168 94 0 -4.7 18.75 -0.335795449 1.180923186 -0.396548632 118.4 24.4 m 172.7 75.25 0.5 kontrola r2 s 13.99661613 15.87740864 rVH 0.586992629 0.586992629 0.344560347 kontrola rVe -0.123983062 m 172.7 75.25 0.5 8.29892E-16 0 RHe -0.876098108 s 13.99661613 15.87740864 0.512989176 1 1 R 0.585811273 vícenásobná korelace (rHH^)