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 ##### Sheet/List 3 ##### ID pohlavi vyska hmotnost z.P z.V z.H V.stř H.stř e.V e.H 1 0 175 82 -0.974679434 0.115158983 0.512718095 0.240786964 0.177881788 0.125627981 -0.334836307 1 (Xi-mX)(Yi-mY) 1 2 0 172 89 -0.974679434 -0.094220986 1.001021043 0.240786964 0.177881788 0.33500795 -0.823139255 rXY = ------- Suma(i 1 až N) --------------------------------- = -------- Suma(…) zXi zYi 3 1 165 62 0.974679434 -0.582774246 -0.882433185 -0.240786964 -0.177881788 0.341987282 0.704551396 N-1 sX sY N-1 4 1 170 65 0.974679434 -0.233807632 -0.673160493 -0.240786964 -0.177881788 -0.006979332 0.495278704 5 0 198 89 -0.974679434 1.720405409 1.001021043 0.240786964 0.177881788 -1.479618445 -0.823139255 sX = odmocnina(s2X) 6 0 189 65 -0.974679434 1.092265503 -0.673160493 0.240786964 0.177881788 -0.851478539 0.851042281 1 7 0 165 60 -0.974679434 -0.582774246 -1.021948313 0.240786964 0.177881788 0.82356121 1.199830101 s2X = --------- Suma(i 1 až N) (Xi-mX)2 8 1 170 85 0.974679434 -0.233807632 0.721990787 -0.240786964 -0.177881788 -0.006979332 -0.899872576 N-1 9 1 178 74 0.974679434 0.324538951 -0.045342417 -0.240786964 -0.177881788 -0.565325915 -0.132539372 10 0 152 68 -0.974679434 -1.490087444 -0.463887801 0.240786964 0.177881788 1.730874408 0.641769589 11 1 145 52 0.974679434 -1.978640704 -1.580008824 -0.240786964 -0.177881788 1.73785374 1.402127036 12 1 178 95 0.974679434 0.324538951 1.419566427 -0.240786964 -0.177881788 -0.565325915 -1.597448215 13 1 170 77 0.974679434 -0.233807632 0.163930275 -0.240786964 -0.177881788 -0.006979332 -0.341812064 14 1 178 78 0.974679434 0.324538951 0.233687839 -0.240786964 -0.177881788 -0.565325915 -0.411569628 15 0 183 79 -0.974679434 0.673505566 0.303445403 0.240786964 0.177881788 -0.432718602 -0.125563615 16 0 185 90 -0.974679434 0.813092212 1.070778607 0.240786964 0.177881788 -0.572305248 -0.892896819 17 1 165 58 0.974679434 -0.582774246 -1.161463441 -0.240786964 -0.177881788 0.341987282 0.983581652 18 1 180 75 0.974679434 0.464125597 0.024415147 -0.240786964 -0.177881788 -0.704912561 -0.202296936 19 0 199 100 -0.974679434 1.790198732 1.768354247 0.240786964 0.177881788 -1.549411768 -1.590472459 20 0 150 50 -0.974679434 -1.62967409 -1.719523952 0.240786964 0.177881788 1.870461054 1.897405741 průměr 0.5 173.35 74.65 kontrola sd 0.512989176 14.32801819 14.33536297 rVH 0.741169333 rVH.P 0.730619363 0.730619363 rVP -0.247042213 rVP.H -0.169347442 rHP -0.182502864 rHP.V 0.000918122 ##### Sheet/List 4 ##### ID X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ ID X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ R X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 1 19 9 13 56 171 64 247 16 117 2223 1 12 15 14 54 180 52 168 21 210 2520 X 1 -0.002281814 0.056483062 0.764508667 0.680100019 0.842204529 0.712655833 0.020719562 0.049154291 0.572844131 2 16 13 12 58 208 56 192 18 156 2496 2 12 13 14 50 156 52 168 19 182 2184 Y -0.002281814 1 -0.053664327 0.642867304 0.715786112 -0.030831979 -0.028740369 0.831070846 0.649345969 0.531627957 3 21 14 11 70 294 64 231 18 154 3234 3 16 17 7 66 272 46 112 18 119 1904 Z 0.056483062 -0.053664327 1 0.008672034 0.011422853 0.585867724 0.724551117 0.497566051 0.707409275 0.586513526 4 12 17 8 58 204 40 96 19 136 1632 4 17 8 9 50 136 52 153 12 72 1224 XY 0.764508667 0.642867304 0.008672034 1 0.982349267 0.625236693 0.527353324 0.5515916 0.456229416 0.781482317 5 20 8 9 56 160 58 180 12 72 1440 5 21 17 11 76 357 64 231 20 187 3927 sXY 0.680100019 0.715786112 0.011422853 0.982349267 1 0.558207478 0.469659122 0.613481995 0.511315351 0.796819436 6 22 9 6 62 198 56 132 11 54 1188 6 19 9 11 56 171 60 209 14 99 1881 XZ 0.842204529 -0.030831979 0.585867724 0.625236693 0.558207478 1 0.96973684 0.285513879 0.421914017 0.781708229 7 11 16 14 54 176 50 154 21 224 2464 7 17 14 13 62 238 60 221 19 182 3094 sXZ 0.712655833 -0.028740369 0.724551117 0.527353324 0.469659122 0.96973684 1 0.363570296 0.524352131 0.809064683 8 14 14 13 56 196 54 182 19 182 2548 8 18 18 6 72 324 48 108 19 108 1944 uYZ 0.020719562 0.831070846 0.497566051 0.5515916 0.613481995 0.285513879 0.363570296 1 0.934479331 0.761796727 9 11 15 8 52 165 38 88 17 120 1320 9 22 9 14 62 198 72 308 17 126 2772 sYZ 0.049154291 0.649345969 0.707409275 0.456229416 0.511315351 0.421914017 0.524352131 0.934479331 1 0.830563932 10 16 10 14 52 160 60 224 17 140 2240 10 12 12 13 48 144 50 156 18 156 1872 vXYZ 0.572844131 0.531627957 0.586513526 0.781482317 0.796819436 0.781708229 0.809064683 0.761796727 0.830563932 1 11 19 9 10 56 171 58 190 13 90 1710 11 17 13 8 60 221 50 136 15 104 1768 12 18 12 10 60 216 56 180 16 120 2160 12 15 14 12 58 210 54 180 18 168 2520 F F1 F2 F3 FT X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 13 14 9 14 46 126 56 196 17 126 1764 13 20 10 8 60 200 56 160 13 80 1600 X 0.998069712 0.006305658 0.034355133 F1 0.998069712 -0.007658253 0.021301553 0.759542128 0.679412639 0.821680259 0.691498635 -0.005241046 0.018769645 0.555442222 14 12 17 7 58 204 38 84 18 119 1428 14 14 9 6 46 126 40 84 11 54 756 Y -0.007658253 0.997606063 -0.037835951 F2 0.006305658 0.997606063 -0.016030156 0.647931415 0.726833001 -0.003509428 0.000212091 0.850153554 0.680775993 0.5639642 15 21 11 8 64 231 58 168 14 88 1848 15 17 16 13 66 272 60 221 21 208 3536 Z 0.021301553 -0.016030156 0.997191949 F3 0.034355133 -0.037835951 0.997191949 0.001920398 0.005981462 0.566468011 0.715095596 0.508734953 0.723239638 0.592373744 16 20 10 10 60 200 60 200 14 100 2000 16 13 13 8 52 169 42 104 15 104 1352 XY 0.759542128 0.647931415 0.001920398 17 14 12 13 52 168 54 182 18 156 2184 17 16 14 8 60 224 48 128 16 112 1792 sXY 0.679412639 0.726833001 0.005981462 18 13 12 12 50 156 50 156 17 144 1872 18 17 10 13 54 170 60 221 16 130 2210 XZ 0.821680259 -0.003509428 0.566468011 19 16 16 11 64 256 54 176 19 176 2816 19 15 9 10 48 135 50 150 13 90 1350 sXZ 0.691498635 0.000212091 0.715095596 20 11 15 13 52 165 48 143 20 195 2145 20 15 17 12 64 255 54 180 21 204 3060 uYZ -0.005241046 0.850153554 0.508734953 21 10 13 12 46 130 44 120 18 156 1560 21 21 13 7 68 273 56 147 15 91 1911 sYZ 0.018769645 0.680775993 0.723239638 22 19 9 13 56 171 64 247 16 117 2223 22 15 11 13 52 165 56 195 17 143 2145 vXYZ 0.555442222 0.5639642 0.592373744 SS 0.003325369 23 15 15 8 60 225 46 120 17 120 1800 23 17 11 13 56 187 60 221 17 143 2431 24 22 9 6 62 198 56 132 11 54 1188 24 15 10 7 50 150 44 105 12 70 1050 R.stř. X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 25 10 18 9 56 180 38 90 20 162 1620 25 11 15 8 52 165 38 88 17 120 1320 X 0.997363187 -0.002652766 0.055418016 0.762227602 0.682889831 0.839533134 0.714732385 0.017607505 0.047873148 0.578277303 26 19 9 8 56 171 54 152 12 72 1368 26 18 17 7 70 306 50 126 18 119 2142 Y -0.002652766 0.996708065 -0.053884618 0.640490882 0.719663581 -0.031226517 -0.03214041 0.828910007 0.651638056 0.535947365 27 22 11 10 66 242 64 220 15 110 2420 27 16 15 11 62 240 54 176 19 165 2640 Z 0.055418016 -0.053884618 0.995102505 0.007707991 0.008785964 0.582436662 0.727814166 0.493566663 0.710695621 0.593501676 28 22 16 7 76 352 58 154 17 112 2464 28 14 15 11 58 210 50 154 19 165 2310 XY 0.762227602 0.640490882 0.007707991 0.99672305 0.986991943 0.622914748 0.526733033 0.547837373 0.456741396 0.788429483 29 16 9 14 50 144 60 224 17 126 2016 29 13 17 7 60 221 40 91 18 119 1547 sXY 0.682889831 0.719663581 0.008785964 0.986991943 0.989923523 0.559097492 0.474244384 0.617401805 0.511888822 0.790825519 30 16 15 13 62 240 58 208 20 195 3120 30 20 17 13 74 340 66 260 21 221 4420 XZ 0.839533134 -0.031226517 0.582436662 0.622914748 0.559097492 0.996056771 0.973268813 0.280892061 0.422725632 0.789977493 31 12 10 9 44 120 42 108 13 90 1080 31 13 15 9 56 195 44 117 17 135 1755 sXZ 0.714732385 -0.03214041 0.727814166 0.526733033 0.474244384 0.973268813 0.989532118 0.360350258 0.53030905 0.807811005 32 19 11 8 60 209 54 152 14 88 1672 32 12 13 6 50 156 36 72 14 78 936 uYZ 0.017607505 0.828910007 0.493566663 0.547837373 0.617401805 0.280892061 0.360350258 0.981599787 0.94660304 0.7779063 33 15 9 11 48 135 52 165 14 99 1485 33 18 12 8 60 216 52 144 14 96 1728 sYZ 0.047873148 0.651638056 0.710695621 0.456741396 0.511888822 0.422725632 0.53030905 0.94660304 0.986883825 0.822786913 34 17 14 6 62 238 46 102 15 84 1428 34 19 16 13 70 304 64 247 21 208 3952 vXYZ 0.578277303 0.535947365 0.593501676 0.788429483 0.790825519 0.789977493 0.807811005 0.7779063 0.822786913 0.977478333 35 14 16 9 60 224 46 126 18 144 2016 35 18 14 8 64 252 52 144 16 112 2016 36 19 17 7 72 323 52 133 18 119 2261 36 18 10 11 56 180 58 198 15 110 1980 R-Rstř X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 37 19 17 13 72 323 64 247 21 221 4199 37 11 11 10 44 121 42 110 15 110 1210 X 0.002636813 0.000370953 0.001065046 0.002281064 -0.002789813 0.002671395 -0.002076552 0.003112057 0.001281142 -0.005433172 38 10 16 9 52 160 38 90 18 144 1440 38 20 12 9 64 240 58 180 15 108 2160 Y 0.000370953 0.003291935 0.000220291 0.002376422 -0.003877469 0.000394538 0.003400041 0.00216084 -0.002292088 -0.004319408 39 18 16 11 68 288 58 198 19 176 3168 39 13 8 10 42 104 46 130 13 80 1040 Z 0.001065046 0.000220291 0.004897495 0.000964042 0.002636889 0.003431062 -0.003263049 0.003999388 -0.003286347 -0.006988151 40 14 8 6 44 112 40 84 10 48 672 40 19 9 11 56 171 60 209 14 99 1881 XY 0.002281064 0.002376422 0.000964042 0.00327695 -0.004642675 0.002321945 0.000620291 0.003754227 -0.00051198 -0.006947165 41 14 15 13 58 210 54 182 20 195 2730 41 12 12 10 48 144 44 120 16 120 1440 sXY -0.002789813 -0.003877469 0.002636889 -0.004642675 0.010076477 -0.000890013 -0.004585262 -0.00391981 -0.000573471 0.005993917 42 16 16 13 64 256 58 208 21 208 3328 42 18 10 9 56 180 54 162 13 90 1620 XZ 0.002671395 0.000394538 0.003431062 0.002321945 -0.000890013 0.003943229 -0.003531973 0.004621818 -0.000811615 -0.008269265 43 19 14 8 66 266 54 152 16 112 2128 43 17 16 7 66 272 48 119 17 112 1904 sXZ -0.002076552 0.003400041 -0.003263049 0.000620291 -0.004585262 -0.003531973 0.010467882 0.003220038 -0.005956919 0.001253678 44 15 14 12 58 210 54 180 18 168 2520 44 18 11 9 58 198 54 162 14 99 1782 uYZ 0.003112057 0.00216084 0.003999388 0.003754227 -0.00391981 0.004621818 0.003220038 0.018400213 -0.01212371 -0.016109573 45 13 11 6 48 143 38 78 13 66 858 45 14 18 11 64 252 50 154 21 198 2772 sYZ 0.001281142 -0.002292088 -0.003286347 -0.00051198 -0.000573471 -0.000811615 -0.005956919 -0.01212371 0.013116175 0.007777019 46 10 10 7 40 100 34 70 12 70 700 46 20 13 11 66 260 62 220 17 143 2860 vXYZ -0.005433172 -0.004319408 -0.006988151 -0.006947165 0.005993917 -0.008269265 0.001253678 -0.016109573 0.007777019 0.022521667 47 10 10 9 40 100 38 90 13 90 900 47 11 11 14 44 121 50 154 18 154 1694 48 19 13 12 64 247 62 228 18 156 2964 48 11 8 11 38 88 44 121 14 88 968 49 13 12 9 50 156 44 117 15 108 1404 49 20 14 7 68 280 54 140 16 98 1960 50 17 16 6 66 272 46 102 17 96 1632 50 14 18 7 64 252 42 98 19 126 1764 51 11 14 10 50 154 42 110 17 140 1540 51 21 17 13 76 357 68 273 21 221 4641 52 12 9 11 42 108 46 132 14 99 1188 52 14 15 11 58 210 50 154 19 165 2310 53 20 14 7 68 280 54 140 16 98 1960 53 14 10 10 48 140 48 140 14 100 1400 54 15 13 12 56 195 54 180 18 156 2340 54 14 17 14 62 238 56 196 22 238 3332 55 22 15 10 74 330 64 220 18 150 3300 55 11 14 8 50 154 38 88 16 112 1232 56 18 16 10 68 288 56 180 19 160 2880 56 13 15 11 56 195 48 143 19 165 2145 57 12 18 13 60 216 50 156 22 234 2808 57 20 11 10 62 220 60 200 15 110 2200 58 20 17 12 74 340 64 240 21 204 4080 58 12 16 13 56 192 50 156 21 208 2496 59 21 8 9 58 168 60 189 12 72 1512 59 18 11 10 58 198 56 180 15 110 1980 60 15 8 9 46 120 48 135 12 72 1080 60 19 15 13 68 285 64 247 20 195 3705 61 18 9 11 54 162 58 198 14 99 1782 61 14 18 11 64 252 50 154 21 198 2772 62 21 10 9 62 210 60 189 13 90 1890 62 13 12 9 50 156 44 117 15 108 1404 63 21 13 11 68 273 64 231 17 143 3003 63 13 11 8 48 143 42 104 14 88 1144 64 12 18 7 60 216 38 84 19 126 1512 64 14 10 10 48 140 48 140 14 100 1400 65 10 17 10 54 170 40 100 20 170 1700 65 19 9 11 56 171 60 209 14 99 1881 66 18 13 7 62 234 50 126 15 91 1638 66 10 9 11 38 90 42 110 14 99 990 67 13 14 13 54 182 52 169 19 182 2366 67 22 17 9 78 374 62 198 19 153 3366 68 20 15 14 70 300 68 280 21 210 4200 68 20 16 7 72 320 54 140 17 112 2240 69 18 12 8 60 216 52 144 14 96 1728 69 13 10 10 46 130 46 130 14 100 1300 70 17 12 11 58 204 56 187 16 132 2244 70 10 11 10 42 110 40 100 15 110 1100 71 15 17 12 64 255 54 180 21 204 3060 71 21 15 12 72 315 66 252 19 180 3780 72 16 13 6 58 208 44 96 14 78 1248 72 11 16 7 54 176 36 77 17 112 1232 73 13 13 8 52 169 42 104 15 104 1352 73 12 11 13 46 132 50 156 17 143 1716 74 14 9 7 46 126 42 98 11 63 882 74 19 9 7 56 171 52 133 11 63 1197 75 11 11 11 44 121 44 121 16 121 1331 75 12 10 7 44 120 38 84 12 70 840 76 13 10 8 46 130 42 104 13 80 1040 76 20 11 8 62 220 56 160 14 88 1760 77 12 10 10 44 120 44 120 14 100 1200 77 20 16 13 72 320 66 260 21 208 4160 78 12 12 7 48 144 38 84 14 84 1008 78 17 11 13 56 187 60 221 17 143 2431 79 21 16 9 74 336 60 189 18 144 3024 79 22 11 11 66 242 66 242 16 121 2662 80 17 11 10 56 187 54 170 15 110 1870 80 18 11 12 58 198 60 216 16 132 2376 81 13 11 7 48 143 40 91 13 77 1001 81 14 15 9 58 210 46 126 17 135 1890 82 17 17 10 68 289 54 170 20 170 2890 82 12 16 6 56 192 36 72 17 96 1152 83 19 10 12 58 190 62 228 16 120 2280 83 14 14 8 56 196 44 112 16 112 1568 84 20 14 8 68 280 56 160 16 112 2240 84 18 16 12 68 288 60 216 20 192 3456 85 15 10 12 50 150 54 180 16 120 1800 85 11 11 12 44 121 46 132 16 132 1452 86 16 16 11 64 256 54 176 19 176 2816 86 12 15 11 54 180 46 132 19 165 1980 87 21 16 7 74 336 56 147 17 112 2352 87 17 13 12 60 221 58 204 18 156 2652 88 22 11 13 66 242 70 286 17 143 3146 88 18 9 6 54 162 48 108 11 54 972 89 19 10 7 58 190 52 133 12 70 1330 89 18 16 9 68 288 54 162 18 144 2592 90 17 11 9 56 187 52 153 14 99 1683 90 10 15 11 50 150 42 110 19 165 1650 91 14 17 13 62 238 54 182 21 221 3094 91 10 12 9 44 120 38 90 15 108 1080 92 21 10 14 62 210 70 294 17 140 2940 92 18 16 7 68 288 50 126 17 112 2016 93 20 12 10 64 240 60 200 16 120 2400 93 13 13 11 52 169 48 143 17 143 1859 94 16 17 12 66 272 56 192 21 204 3264 94 11 13 7 48 143 36 77 15 91 1001 95 12 15 10 54 180 44 120 18 150 1800 95 21 9 12 60 189 66 252 15 108 2268 96 19 16 7 70 304 52 133 17 112 2128 96 22 10 11 64 220 66 242 15 110 2420 97 15 10 7 50 150 44 105 12 70 1050 97 11 18 7 58 198 36 77 19 126 1386 98 21 15 13 72 315 68 273 20 195 4095 98 14 9 12 46 126 52 168 15 108 1512 99 21 16 11 74 336 64 231 19 176 3696 99 19 18 11 74 342 60 209 21 198 3762 100 12 11 13 46 132 50 156 17 143 1716 100 12 14 12 52 168 48 144 18 168 2016 ##### Sheet/List 5 ##### ID X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ ID X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ R X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 1 21 15 13 72 315 68 273 20 195 4095 1 12 15 14 54 180 52 168 21 210 2520 X 1 -0.002281814 0.056483062 0.764508667 0.680100019 0.842204529 0.712655833 0.020719562 0.049154291 0.572844131 2 16 10 6 52 160 44 96 12 60 960 2 12 13 14 50 156 52 168 19 182 2184 Y -0.002281814 1 -0.053664327 0.642867304 0.715786112 -0.030831979 -0.028740369 0.831070846 0.649345969 0.531627957 3 21 8 12 58 168 66 252 14 96 2016 3 16 17 7 66 272 46 112 18 119 1904 Z 0.056483062 -0.053664327 1 0.008672034 0.011422853 0.585867724 0.724551117 0.497566051 0.707409275 0.586513526 4 11 15 9 52 165 40 99 17 135 1485 4 17 8 9 50 136 52 153 12 72 1224 XY 0.764508667 0.642867304 0.008672034 1 0.982349267 0.625236693 0.527353324 0.5515916 0.456229416 0.781482317 5 18 12 11 60 216 58 198 16 132 2376 5 21 17 11 76 357 64 231 20 187 3927 sXY 0.680100019 0.715786112 0.011422853 0.982349267 1 0.558207478 0.469659122 0.613481995 0.511315351 0.796819436 6 12 15 12 54 180 48 144 19 180 2160 6 19 9 11 56 171 60 209 14 99 1881 XZ 0.842204529 -0.030831979 0.585867724 0.625236693 0.558207478 1 0.96973684 0.285513879 0.421914017 0.781708229 7 21 12 9 66 252 60 189 15 108 2268 7 17 14 13 62 238 60 221 19 182 3094 sXZ 0.712655833 -0.028740369 0.724551117 0.527353324 0.469659122 0.96973684 1 0.363570296 0.524352131 0.809064683 8 17 18 11 70 306 56 187 21 198 3366 8 18 18 6 72 324 48 108 19 108 1944 uYZ 0.020719562 0.831070846 0.497566051 0.5515916 0.613481995 0.285513879 0.363570296 1 0.934479331 0.761796727 9 17 16 8 66 272 50 136 18 128 2176 9 22 9 14 62 198 72 308 17 126 2772 sYZ 0.049154291 0.649345969 0.707409275 0.456229416 0.511315351 0.421914017 0.524352131 0.934479331 1 0.830563932 10 20 18 12 76 360 64 240 22 216 4320 10 12 12 13 48 144 50 156 18 156 1872 vXYZ 0.572844131 0.531627957 0.586513526 0.781482317 0.796819436 0.781708229 0.809064683 0.761796727 0.830563932 1 11 22 14 13 72 308 70 286 19 182 4004 11 17 13 8 60 221 50 136 15 104 1768 12 22 9 13 62 198 70 286 16 117 2574 12 15 14 12 58 210 54 180 18 168 2520 F F1 F2 F3 meziv F1 F2 F3 FT X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 13 13 14 9 54 182 44 117 17 126 1638 13 20 10 8 60 200 56 160 13 80 1600 X 0.996958391 0.018882401 0.057559908 X 0.997354171 0.02054618 0.063981649 F1 0.996958391 -0.024347895 -0.00814908 0.746738118 0.665377463 0.80423315 0.670106181 -0.036466983 -0.01446372 0.527707713 14 15 16 13 62 240 56 195 21 208 3120 14 14 9 6 46 126 40 84 11 54 756 Y -0.024347895 0.998046509 0.014306861 Y -0.022762581 0.998052676 0.017124089 F2 0.018882401 0.998046509 -0.07249322 0.65799345 0.735600601 -0.021895225 -0.028349764 0.820108536 0.639327718 0.53770844 15 12 11 7 46 132 38 84 13 77 924 15 17 16 13 66 272 60 221 21 208 3536 Z -0.00814908 -0.07249322 0.995771316 Z -0.001899674 -0.069539508 0.995503363 F3 0.057559908 0.014306861 0.995771316 0.055290497 0.060776976 0.584822759 0.730115321 0.552769844 0.758416424 0.634337644 16 10 9 12 38 90 44 120 15 108 1080 16 13 13 8 52 169 42 104 15 104 1352 XY 0.746738118 0.65799345 0.055290497 XY 0.748076087 0.659275918 0.062018198 17 21 18 11 78 378 64 231 21 198 4158 17 16 14 8 60 224 48 128 16 112 1792 sXY 0.665377463 0.735600601 0.060776976 sXY 0.666866633 0.736777623 0.067216349 K F1 F2 F3 18 18 14 11 64 252 58 198 18 154 2772 18 17 10 13 54 170 60 221 16 130 2210 XZ 0.80423315 -0.021895225 0.584822759 XZ 0.807934422 -0.018949479 0.589892508 F1 1 0.00149689 0.00638492 19 22 15 10 74 330 64 220 18 150 3300 19 15 9 10 48 135 50 150 13 90 1350 sXZ 0.670106181 -0.028349764 0.730115321 sXZ 0.674725472 -0.025172036 0.734309455 F2 0.00149689 1 0.002978506 20 19 14 8 66 266 54 152 16 112 2128 20 15 17 12 64 255 54 180 21 204 3060 uYZ -0.036466983 0.820108536 0.552769844 uYZ -0.031709979 0.821700377 0.554979703 F3 0.00638492 0.002978506 1 21 19 12 11 62 228 60 209 16 132 2508 21 21 13 7 68 273 56 147 15 91 1911 sYZ -0.01446372 0.639327718 0.758416424 sYZ -0.008664288 0.641565015 0.760228315 22 17 11 7 56 187 48 119 13 77 1309 22 15 11 13 52 165 56 195 17 143 2145 vXYZ 0.527707713 0.53770844 0.634337644 vXYZ 0.532562798 0.540387738 0.639308583 SS 0.003368102 23 13 17 12 60 221 50 156 21 204 2652 23 17 11 13 56 187 60 221 17 143 2431 24 12 15 10 54 180 44 120 18 150 1800 24 15 10 7 50 150 44 105 12 70 1050 R.stř. X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 25 14 17 8 62 238 44 112 19 136 1904 25 11 15 8 52 165 38 88 17 120 1320 X 0.998391349 -0.002862055 0.054094113 0.761819206 0.682619382 0.839073349 0.714464698 0.015846727 0.047235025 0.577945311 26 14 16 7 60 224 42 98 17 112 1568 26 18 17 7 70 306 50 126 18 119 2142 Y -0.002862055 0.996902202 -0.055114882 0.640661236 0.72006319 -0.030144454 -0.031045344 0.828807281 0.651399162 0.535511811 27 13 15 7 56 195 40 91 17 105 1365 27 16 15 11 62 240 54 176 19 165 2640 Z 0.054094113 -0.055114882 0.996350318 0.007866776 0.00808638 0.582187825 0.727530703 0.49332357 0.710575042 0.593090805 28 15 10 14 50 150 58 210 17 140 2100 28 14 15 11 58 210 50 154 19 165 2310 XY 0.761819206 0.640661236 0.007866776 0.995845182 0.986486009 0.623462247 0.527880529 0.54767952 0.457709025 0.788604223 29 12 15 12 54 180 48 144 19 180 2160 29 13 17 7 60 221 40 91 18 119 1547 sXY 0.682619382 0.72006319 0.00808638 0.986486009 0.989777297 0.559493992 0.475059667 0.617074174 0.512374967 0.790720071 30 16 12 13 56 192 58 208 18 156 2496 30 20 17 13 74 340 66 260 21 221 4420 XZ 0.839073349 -0.030144454 0.582187825 0.623462247 0.559493992 0.995165113 0.972628621 0.28107123 0.423583502 0.790354955 31 11 16 9 54 176 40 99 18 144 1584 31 13 15 9 56 195 44 117 17 135 1755 sXZ 0.714464698 -0.031045344 0.727530703 0.527880529 0.475059667 0.972628621 0.988981914 0.360655119 0.531060131 0.80832275 32 17 14 12 62 238 58 204 18 168 2856 32 12 13 6 50 156 36 72 14 78 936 uYZ 0.015846727 0.828807281 0.49332357 0.54767952 0.617074174 0.28107123 0.360655119 0.981815904 0.946700193 0.777146144 33 21 17 13 76 357 68 273 21 221 4641 33 18 12 8 60 216 52 144 14 96 1728 sYZ 0.047235025 0.651399162 0.710575042 0.457709025 0.512374967 0.423583502 0.531060131 0.946700193 0.986865255 0.82264415 34 18 17 12 70 306 60 216 21 204 3672 34 19 16 13 70 304 64 247 21 208 3952 vXYZ 0.577945311 0.535511811 0.593090805 0.788604223 0.790720071 0.790354955 0.80832275 0.777146144 0.82264415 0.977146044 35 11 8 6 38 88 34 66 10 48 528 35 18 14 8 64 252 52 144 16 112 2016 36 13 14 12 54 182 50 156 18 168 2184 36 18 10 11 56 180 58 198 15 110 1980 R-Rstř X Y Z XY sXY XZ sXZ uYZ sYZ vXYZ 37 13 9 6 44 117 38 78 11 54 702 37 11 11 10 44 121 42 110 15 110 1210 X 0.001608651 0.000580241 0.002388948 0.002689461 -0.002519364 0.00313118 -0.001808864 0.004872835 0.001919266 -0.005101181 38 13 10 13 46 130 52 169 16 130 1690 38 20 12 9 64 240 58 180 15 108 2160 Y 0.000580241 0.003097798 0.001450555 0.002206068 -0.004277079 -0.000687525 0.002304975 0.002263565 -0.002053193 -0.003883855 39 18 17 7 70 306 50 126 18 119 2142 39 13 8 10 42 104 46 130 13 80 1040 Z 0.002388948 0.001450555 0.003649682 0.000805258 0.003336473 0.003679899 -0.002979586 0.004242481 -0.003165767 -0.00657728 40 19 15 6 68 285 50 114 16 90 1710 40 19 9 11 56 171 60 209 14 99 1881 XY 0.002689461 0.002206068 0.000805258 0.004154818 -0.004136742 0.001774446 -0.000527205 0.003912081 -0.001479609 -0.007121906 41 13 9 7 44 117 40 91 11 63 819 41 12 12 10 48 144 44 120 16 120 1440 sXY -0.002519364 -0.004277079 0.003336473 -0.004136742 0.010222703 -0.001286513 -0.005400545 -0.003592179 -0.001059616 0.006099365 42 15 15 10 60 225 50 150 18 150 2250 42 18 10 9 56 180 54 162 13 90 1620 XZ 0.00313118 -0.000687525 0.003679899 0.001774446 -0.001286513 0.004834887 -0.002891781 0.00444265 -0.001669485 -0.008646726 43 16 10 7 52 160 46 112 12 70 1120 43 17 16 7 66 272 48 119 17 112 1904 sXZ -0.001808864 0.002304975 -0.002979586 -0.000527205 -0.005400545 -0.002891781 0.011018086 0.002915177 -0.006708 0.000741934 44 17 13 14 60 221 62 238 19 182 3094 44 18 11 9 58 198 54 162 14 99 1782 uYZ 0.004872835 0.002263565 0.004242481 0.003912081 -0.003592179 0.00444265 0.002915177 0.018184096 -0.012220862 -0.015349417 45 22 11 8 66 242 60 176 14 88 1936 45 14 18 11 64 252 50 154 21 198 2772 sYZ 0.001919266 -0.002053193 -0.003165767 -0.001479609 -0.001059616 -0.001669485 -0.006708 -0.012220862 0.013134745 0.007919782 46 16 12 13 56 192 58 208 18 156 2496 46 20 13 11 66 260 62 220 17 143 2860 vXYZ -0.005101181 -0.003883855 -0.00657728 -0.007121906 0.006099365 -0.008646726 0.000741934 -0.015349417 0.007919782 0.022853956 47 17 13 13 60 221 60 221 18 169 2873 47 11 11 14 44 121 50 154 18 154 1694 48 11 8 12 38 88 46 132 14 96 1056 48 11 8 11 38 88 44 121 14 88 968 49 12 16 8 56 192 40 96 18 128 1536 49 20 14 7 68 280 54 140 16 98 1960 50 10 13 8 46 130 36 80 15 104 1040 50 14 18 7 64 252 42 98 19 126 1764 51 12 17 8 58 204 40 96 19 136 1632 51 21 17 13 76 357 68 273 21 221 4641 52 15 12 6 54 180 42 90 13 72 1080 52 14 15 11 58 210 50 154 19 165 2310 53 19 8 9 54 152 56 171 12 72 1368 53 14 10 10 48 140 48 140 14 100 1400 54 19 9 11 56 171 60 209 14 99 1881 54 14 17 14 62 238 56 196 22 238 3332 55 12 13 11 50 156 46 132 17 143 1716 55 11 14 8 50 154 38 88 16 112 1232 56 18 15 7 66 270 50 126 17 105 1890 56 13 15 11 56 195 48 143 19 165 2145 57 21 13 8 68 273 58 168 15 104 2184 57 20 11 10 62 220 60 200 15 110 2200 58 12 17 7 58 204 38 84 18 119 1428 58 12 16 13 56 192 50 156 21 208 2496 59 17 13 10 60 221 54 170 16 130 2210 59 18 11 10 58 198 56 180 15 110 1980 60 15 12 7 54 180 44 105 14 84 1260 60 19 15 13 68 285 64 247 20 195 3705 61 21 8 9 58 168 60 189 12 72 1512 61 14 18 11 64 252 50 154 21 198 2772 62 19 10 9 58 190 56 171 13 90 1710 62 13 12 9 50 156 44 117 15 108 1404 63 12 11 6 46 132 36 72 13 66 792 63 13 11 8 48 143 42 104 14 88 1144 64 15 17 13 64 255 56 195 21 221 3315 64 14 10 10 48 140 48 140 14 100 1400 65 22 13 10 70 286 64 220 16 130 2860 65 19 9 11 56 171 60 209 14 99 1881 66 15 11 14 52 165 58 210 18 154 2310 66 10 9 11 38 90 42 110 14 99 990 67 12 11 8 46 132 40 96 14 88 1056 67 22 17 9 78 374 62 198 19 153 3366 68 20 15 9 70 300 58 180 17 135 2700 68 20 16 7 72 320 54 140 17 112 2240 69 12 15 13 54 180 50 156 20 195 2340 69 13 10 10 46 130 46 130 14 100 1300 70 15 11 10 52 165 50 150 15 110 1650 70 10 11 10 42 110 40 100 15 110 1100 71 21 15 12 72 315 66 252 19 180 3780 71 21 15 12 72 315 66 252 19 180 3780 72 21 12 11 66 252 64 231 16 132 2772 72 11 16 7 54 176 36 77 17 112 1232 73 16 16 8 64 256 48 128 18 128 2048 73 12 11 13 46 132 50 156 17 143 1716 74 14 15 9 58 210 46 126 17 135 1890 74 19 9 7 56 171 52 133 11 63 1197 75 14 18 11 64 252 50 154 21 198 2772 75 12 10 7 44 120 38 84 12 70 840 76 15 15 7 60 225 44 105 17 105 1575 76 20 11 8 62 220 56 160 14 88 1760 77 13 10 12 46 130 50 156 16 120 1560 77 20 16 13 72 320 66 260 21 208 4160 78 17 8 12 50 136 58 204 14 96 1632 78 17 11 13 56 187 60 221 17 143 2431 79 15 14 8 58 210 46 120 16 112 1680 79 22 11 11 66 242 66 242 16 121 2662 80 16 18 14 68 288 60 224 23 252 4032 80 18 11 12 58 198 60 216 16 132 2376 81 20 17 8 74 340 56 160 19 136 2720 81 14 15 9 58 210 46 126 17 135 1890 82 19 9 10 56 171 58 190 13 90 1710 82 12 16 6 56 192 36 72 17 96 1152 83 20 11 10 62 220 60 200 15 110 2200 83 14 14 8 56 196 44 112 16 112 1568 84 19 9 7 56 171 52 133 11 63 1197 84 18 16 12 68 288 60 216 20 192 3456 85 21 18 9 78 378 60 189 20 162 3402 85 11 11 12 44 121 46 132 16 132 1452 86 12 8 8 40 96 40 96 11 64 768 86 12 15 11 54 180 46 132 19 165 1980 87 12 10 7 44 120 38 84 12 70 840 87 17 13 12 60 221 58 204 18 156 2652 88 15 16 8 62 240 46 120 18 128 1920 88 18 9 6 54 162 48 108 11 54 972 89 20 13 8 66 260 56 160 15 104 2080 89 18 16 9 68 288 54 162 18 144 2592 90 20 15 7 70 300 54 140 17 105 2100 90 10 15 11 50 150 42 110 19 165 1650 91 21 9 12 60 189 66 252 15 108 2268 91 10 12 9 44 120 38 90 15 108 1080 92 15 14 8 58 210 46 120 16 112 1680 92 18 16 7 68 288 50 126 17 112 2016 93 21 17 8 76 357 58 168 19 136 2856 93 13 13 11 52 169 48 143 17 143 1859 94 11 14 9 50 154 40 99 17 126 1386 94 11 13 7 48 143 36 77 15 91 1001 95 19 18 12 74 342 62 228 22 216 4104 95 21 9 12 60 189 66 252 15 108 2268 96 13 9 9 44 117 44 117 13 81 1053 96 22 10 11 64 220 66 242 15 110 2420 97 22 16 9 76 352 62 198 18 144 3168 97 11 18 7 58 198 36 77 19 126 1386 98 11 10 14 42 110 50 154 17 140 1540 98 14 9 12 46 126 52 168 15 108 1512 99 16 10 11 52 160 54 176 15 110 1760 99 19 18 11 74 342 60 209 21 198 3762 100 19 13 10 64 247 58 190 16 130 2470 100 12 14 12 52 168 48 144 18 168 2016