i V(ýška) H(motnost) P(ohlaví) Vi-mV zVi Hi-mH zHi zVi x zHi 1 172 85 1 -0.7 -0.050012088 9.75 0.614080057 -0.030711426 2 170 59 0 -2.7 -0.192903769 -16.25 -1.023466761 0.197430595 3 149 86 0 -23.7 -1.693266414 10.75 0.677062627 -1.146447405 V(ýška) H(motnost) 4 176 79 1 3.3 0.235771273 3.75 0.236184637 0.055685553 V(ýška) 1 5 185 86 1 12.3 0.878783835 10.75 0.677062627 0.594991691 H(motnost) 0.586992629 1 6 162 57 0 -10.7 -0.76447049 -18.25 -1.149431901 0.878706769 7 182 73 1 9.3 0.664446314 -2.25 -0.141710782 -0.094159207 8 190 96 1 17.3 1.236013036 20.75 1.306888326 1.615331007 9 154 55 0 -18.7 -1.336037212 -20.25 -1.275397041 1.703977907 10 167 63 1 -5.7 -0.407241289 -12.25 -0.771536481 0.314201511 11 204 93 0 31.3 2.236254799 17.75 1.117940616 2.500000068 12 155 52 1 -17.7 -1.264591372 -23.25 -1.46434475 1.851797737 13 174 80 1 1.3 0.092879592 4.75 0.299167207 0.027786528 14 185 110 0 12.3 0.878783835 34.75 2.188644305 1.923345235 15 169 70 1 -3.7 -0.264349609 -5.25 -0.330658492 0.087409443 16 173 65 0 0.3 0.021433752 -10.25 -0.645571342 -0.013837016 17 189 74 0 16.3 1.164567196 -1.25 -0.078728212 -0.091684294 18 154 60 0 -18.7 -1.336037212 -15.25 -0.960484191 1.283242621 19 176 68 1 3.3 0.235771273 -7.25 -0.456623632 -0.107658735 20 168 94 0 -4.7 -0.335795449 18.75 1.180923186 -0.396548632 kontrola r2 kovariance t df p m 172.7 75.25 rVH 0.586992629 0.586992629 0.344560347 130.4473684 3.076114836 18 0.007111186 s 13.99661613 15.87740864 rVP 0.139273582 0.019397131 0.596703272 18 0.326637698 rHP -0.003230938 1.0439E-05 -0.013707779 18 0.393403501 kontrola m 172.7 s 13.99661613 N t 20 50 100 200 1000 Poznámka kovariance různé 0 0 0 0 0 0 hodnoty 0.1 0.426401433 0.696310624 0.994936676 1.414213562 3.175028831 cVH = sV * rVH * sH r 0.2 0.866025404 1.414213562 2.020725942 2.872281323 6.448514041 0.3 1.33424877 2.178819118 3.11324713 4.425202547 9.934953281 rVH = cVH/(sV*sH) 0.4 1.8516402 3.023715784 4.320493799 6.141195789 13.78750297 0.5 2.449489743 4 5.715476066 8.124038405 18.23915203 0.6 3.181980515 5.196152423 7.424621202 10.55343546 23.6933535 0.7 4.158619681 6.790997501 9.703445921 13.79258113 30.96550896 0.8 5.656854249 9.237604307 13.19932658 18.76166304 42.12151733 0.9 8.759956741 14.30494946 20.43989906 29.05348969 65.22753697 0.99 29.7745296 48.62160324 69.47390241 98.750943 221.7042033 ##### Sheet/List 2 ##### i V(ýška) H(motnost) P(ohlaví) Vi-mV zVi Hi-mH zHi zVi x zHi Hi.stř ei 1 172 85 1 -0.7 -0.050012088 9.75 0.614080057 -0.030711426 74.78389125 10.21610875 2 170 59 0 -2.7 -0.192903769 -16.25 -1.023466761 0.197430595 73.45215195 -14.45215195 3 149 86 0 -23.7 -1.693266414 10.75 0.677062627 -1.146447405 59.46888937 26.53111063 b 0.665869647 4 176 79 1 3.3 0.235771273 3.75 0.236184637 0.055685553 77.44736984 1.552630165 a -39.74568803 5 185 86 1 12.3 0.878783835 10.75 0.677062627 0.594991691 83.44019666 2.559803342 6 162 57 0 -10.7 -0.76447049 -18.25 -1.149431901 0.878706769 68.12519478 -11.12519478 7 182 73 1 9.3 0.664446314 -2.25 -0.141710782 -0.094159207 81.44258772 -8.442587717 8 190 96 1 17.3 1.236013036 20.75 1.306888326 1.615331007 86.76954489 9.230455107 9 154 55 0 -18.7 -1.336037212 -20.25 -1.275397041 1.703977907 62.7982376 -7.798237601 10 167 63 1 -5.7 -0.407241289 -12.25 -0.771536481 0.314201511 71.45454301 -8.454543012 11 204 93 0 31.3 2.236254799 17.75 1.117940616 2.500000068 96.09171995 -3.091719951 12 155 52 1 -17.7 -1.264591372 -23.25 -1.46434475 1.851797737 63.46410725 -11.46410725 13 174 80 1 1.3 0.092879592 4.75 0.299167207 0.027786528 76.11563054 3.884369459 14 185 110 0 12.3 0.878783835 34.75 2.188644305 1.923345235 83.44019666 26.55980334 15 169 70 1 -3.7 -0.264349609 -5.25 -0.330658492 0.087409443 72.78628231 -2.786282306 16 173 65 0 0.3 0.021433752 -10.25 -0.645571342 -0.013837016 75.44976089 -10.44976089 17 189 74 0 16.3 1.164567196 -1.25 -0.078728212 -0.091684294 86.10367525 -12.10367525 18 154 60 0 -18.7 -1.336037212 -15.25 -0.960484191 1.283242621 62.7982376 -2.798237601 19 176 68 1 3.3 0.235771273 -7.25 -0.456623632 -0.107658735 77.44736984 -9.447369835 20 168 94 0 -4.7 -0.335795449 18.75 1.180923186 -0.396548632 72.12041266 21.87958734 m 172.7 75.25 s 13.99661613 15.87740864 kontrola r2 kovariance t df p rVH 0.586992629 0.586992629 0.344560347 130.4473684 3.076114836 18 0.007111186 kontrola rVP 0.139273582 0.019397131 0.596703272 18 0.326637698 m 172.7 rHP -0.003230938 1.0439E-05 -0.013707779 18 0.393403501 s 13.99661613 R 0.586992629 0.344560347 pro vztah H = a+bV+e Poznámka kovariance cVH = sV * rVH * sH rVH = cVH/(sV*sH) ##### Sheet/List 3 ##### i V(ýška) H(motnost) P(ohlaví) Vi-mV zVi Hi-mH zHi zVi x zHi Hi.stř ei ei 1 172 85 1 -0.7 -0.050012088 9.75 0.614080057 -0.030711426 73.43278627 11.56721373 10.21610875 2 170 59 0 -2.7 -0.192903769 -16.25 -1.023466761 0.197430595 74.75684434 -15.75684434 -14.45215195 3 149 86 0 -23.7 -1.693266414 10.75 0.677062627 -1.146447405 60.48702243 25.51297757 a -40.76076161 26.53111063 4 176 79 1 3.3 0.235771273 3.75 0.236184637 0.055685553 76.15084759 2.849152414 b1 0.679515329 1.552630165 5 185 86 1 12.3 0.878783835 10.75 0.677062627 0.594991691 82.26648555 3.733514451 b2 -2.68308873 2.559803342 6 162 57 0 -10.7 -0.76447049 -18.25 -1.149431901 0.878706769 69.32072171 -12.32072171 -11.12519478 7 182 73 1 9.3 0.664446314 -2.25 -0.141710782 -0.094159207 80.22793956 -7.227939561 SS 3104.115311 -8.442587717 8 190 96 1 17.3 1.236013036 20.75 1.306888326 1.615331007 85.66406219 10.33593781 9.230455107 9 154 55 0 -18.7 -1.336037212 -20.25 -1.275397041 1.703977907 63.88459907 -8.884599075 R 0.593233009 -7.798237601 10 167 63 1 -5.7 -0.407241289 -12.25 -0.771536481 0.314201511 70.03520962 -7.035209624 R2 0.351925403 -8.454543012 11 204 93 0 31.3 2.236254799 17.75 1.117940616 2.500000068 97.86036553 -4.860365532 -3.091719951 12 155 52 1 -17.7 -1.264591372 -23.25 -1.46434475 1.851797737 61.88102567 -9.881025674 -11.46410725 13 174 80 1 1.3 0.092879592 4.75 0.299167207 0.027786528 74.79181693 5.208183072 3.884369459 14 185 110 0 12.3 0.878783835 34.75 2.188644305 1.923345235 84.94957428 25.05042572 26.55980334 15 169 70 1 -3.7 -0.264349609 -5.25 -0.330658492 0.087409443 71.39424028 -1.394240282 -2.786282306 16 173 65 0 0.3 0.021433752 -10.25 -0.645571342 -0.013837016 76.79539033 -11.79539033 -10.44976089 17 189 74 0 16.3 1.164567196 -1.25 -0.078728212 -0.091684294 87.6676356 -13.6676356 -12.10367525 18 154 60 0 -18.7 -1.336037212 -15.25 -0.960484191 1.283242621 63.88459907 -3.884599075 -2.798237601 19 176 68 1 3.3 0.235771273 -7.25 -0.456623632 -0.107658735 76.15084759 -8.150847586 -9.447369835 20 168 94 0 -4.7 -0.335795449 18.75 1.180923186 -0.396548632 73.39781368 20.60218632 21.87958734 m 172.7 75.25 s 13.99661613 15.87740864 kontrola r2 kovariance t df p rVH 0.586992629 0.586992629 0.344560347 130.4473684 3.076114836 18 0.007111186 kontrola rVP 0.139273582 0.019397131 0.596703272 18 0.326637698 m 172.7 rHP -0.003230938 1.0439E-05 -0.013707779 18 0.393403501 s 13.99661613 R 0.593233009 0.351925403 pro vztah H = a+bV+e Poznámka kovariance cVH = sV * rVH * sH rVH = cVH/(sV*sH)