ID pohlavi vyska hmotnost Vi-mV Hi-mH (mV-Vi)(mH-Hi) H.stř e 1 0 175 82 1.65 7.35 12.1275 75.87355629 6.126443707 1 (Xi-mX)(Yi-mY) 1 2 0 172 89 -1.35 14.35 -19.3725 73.64890849 15.35109151 rXY = ------- Suma(i 1 až N) --------------------------------- = -------- Suma(…) zXi zYi 3 1 165 62 -8.35 -12.65 105.6275 68.45806361 -6.458063606 N-1 sX sY N-1 4 1 170 65 -3.35 -9.65 32.3275 72.16580995 -7.16580995 5 0 198 89 24.65 14.35 353.7275 92.92918947 -3.929189473 sX = odmocnina(s2X) 6 0 189 65 15.65 -9.65 -151.0225 86.25524606 -21.25524606 1 7 0 165 60 -8.35 -14.65 122.3275 68.45806361 -8.458063606 s2X = --------- Suma(i 1 až N) (Xi-mX)2 8 1 170 85 -3.35 10.35 -34.6725 72.16580995 12.83419005 N-1 9 1 178 74 4.65 -0.65 -3.0225 78.0982041 -4.098204099 10 0 152 68 -21.35 -6.65 141.9775 58.81792311 9.182076887 11 1 145 52 -28.35 -22.65 642.1275 53.62707823 -1.627078233 12 1 178 95 4.65 20.35 94.6275 78.0982041 16.9017959 13 1 170 77 -3.35 2.35 -7.8725 72.16580995 4.83419005 14 1 178 78 4.65 3.35 15.5775 78.0982041 -0.098204099 15 0 183 79 9.65 4.35 41.9775 81.80595044 -2.805950443 16 0 185 90 11.65 15.35 178.8275 83.28904898 6.71095102 17 1 165 58 -8.35 -16.65 139.0275 68.45806361 -10.45806361 18 1 180 75 6.65 0.35 2.3275 79.58130264 -4.581302637 19 0 199 100 25.65 25.35 650.2275 93.67073874 6.329261258 20 0 150 50 -23.35 -24.65 575.5775 57.33482458 -7.334824576 průměr 0.5 173.35 74.65 sd 0.512989176 14.32801819 14.33536297 r 0.741169333 korelace a -53.89756573 vzorec 0.741169333 b 0.741549269 r2 0.54933198 "H.stř = -53,9 + 0,742 * V" c 152.2342105 kovariance R 0.741169333 "mnohonásobná korelace, multiple correlation" ##### Sheet/List 2 ##### ID pohlavi vyska hmotnost Vi-mV Hi-mH (mV-Vi)(mH-Hi) H.stř e 1 0 175 82 1.65 7.35 12.1275 75.86425992 6.135740078 1 (Xi-mX)(Yi-mY) 1 2 0 172 89 -1.35 14.35 -19.3725 73.63920989 15.36079011 rXY = ------- Suma(i 1 až N) --------------------------------- = -------- Suma(…) zXi zYi 3 1 165 62 -8.35 -12.65 105.6275 68.46570074 -6.465700743 N-1 sX sY N-1 4 1 170 65 -3.35 -9.65 32.3275 72.17411746 -7.174117462 5 0 198 89 24.65 14.35 353.7275 92.92297683 -3.922976828 sX = odmocnina(s2X) 6 0 189 65 15.65 -9.65 -151.0225 86.24782673 -21.24782673 1 7 0 165 60 -8.35 -14.65 122.3275 68.44742649 -8.447426485 s2X = --------- Suma(i 1 až N) (Xi-mX)2 8 1 170 85 -3.35 10.35 -34.6725 72.17411746 12.82588254 N-1 9 1 178 74 4.65 -0.65 -3.0225 78.10758421 -4.107584212 10 0 152 68 -21.35 -6.65 141.9775 58.80554302 9.194456983 11 1 145 52 -28.35 -22.65 642.1275 53.63203387 -1.632033869 12 1 178 95 4.65 20.35 94.6275 78.10758421 16.89241579 13 1 170 77 -3.35 2.35 -7.8725 72.17411746 4.825882538 14 1 178 78 4.65 3.35 15.5775 78.10758421 -0.107584212 15 0 183 79 9.65 4.35 41.9775 81.79772667 -2.797726672 16 0 185 90 11.65 15.35 178.8275 83.28109336 6.71890664 17 1 165 58 -8.35 -16.65 139.0275 68.46570074 -10.46570074 18 1 180 75 6.65 0.35 2.3275 79.5909509 -4.590950899 19 0 199 100 25.65 25.35 650.2275 93.66466017 6.335339828 20 0 150 50 -23.35 -24.65 575.5775 57.32217633 -7.322176329 průměr 0.5 173.35 74.65 sd 0.512989176 14.32801819 14.33536297 rVH 0.741169333 korelace a -53.93032523 vzorec 0.741169333 b1 0.741683344 muži 176.8 77.2 r2 0.54933198 b2 0.018274258 ženy 169.9 72.1 c 152.2342105 kovariance SS 1759.654341 RHH.stř 0.741169589 "mnohonásobná korelace, multiple correlation" R2 0.54933236 rPH -0.182502864