ID Sex Výška Hmotnost Vi-mV Hi-mH zVi zHi z*z 1 1 175 91 -0.9 17.35 -0.069330161 0.935553089 -0.064862046 2 2 170 58 -5.9 -15.65 -0.454497723 -0.843885063 0.38354384 Korelace 0.566735369 3 1 185 85 9.1 11.35 0.701004963 0.612018879 0.429028272 Pearson 0.566735369 4 2 164 55 -11.9 -18.65 -0.916698798 -1.005652167 0.921880133 5 1 178 79 2.1 5.35 0.161770376 0.28848467 0.046668274 6 2 168 65 -7.9 -8.65 -0.608564748 -0.466428485 0.283851934 7 2 169 57 -6.9 -16.65 -0.531531236 -0.897807431 0.477212693 8 1 192 85 16.1 11.35 1.24023955 0.612018879 0.759050019 9 2 160 54 -15.9 -19.65 -1.224832847 -1.059574536 1.297801695 10 1 190 92 14.1 18.35 1.086172525 0.989475457 1.074741055 11 2 162 48 -13.9 -25.65 -1.070765822 -1.383108745 1.480985573 12 2 185 79 9.1 5.35 0.701004963 0.28848467 0.202229185 13 2 195 80 19.1 6.35 1.471340087 0.342407038 0.503797201 14 1 160 60 -15.9 -13.65 -1.224832847 -0.736040326 0.901526369 15 2 152 80 -23.9 6.35 -1.841100947 0.342407038 -0.630405922 16 1 191 63 15.1 -10.65 1.163206037 -0.574273222 -0.667998078 17 1 183 105 7.1 31.35 0.546937938 1.690466244 0.924580122 18 1 189 71 13.1 -2.65 1.009139013 -0.142894276 -0.144200188 19 2 165 51 -10.9 -22.65 -0.839665285 -1.22134164 1.025518177 20 1 185 115 9.1 41.35 0.701004963 2.229689926 1.563023704 průměr 175.9 73.65 SD 12.98136316 18.54517954 ##### Sheet/List 2 ##### ID Sex Výška Hmotnost Vi-mV Hi-mH zVi zHi z*z H.stř e 1 1 175 91 -0.9 17.35 -0.069330161 0.935553089 -0.064862046 72.9213255 18.0786745 2 2 170 58 -5.9 -15.65 -0.454497723 -0.843885063 0.38354384 68.87313386 -10.87313386 Korelace 0.566735369 3 1 185 85 9.1 11.35 0.701004963 0.612018879 0.429028272 81.01770879 3.982291211 Pearson 0.566735369 4 2 164 55 -11.9 -18.65 -0.916698798 -1.005652167 0.921880133 64.01530389 -9.015303892 5 1 178 79 2.1 5.35 0.161770376 0.28848467 0.046668274 75.35024049 3.64975951 a -68.76538197 6 2 168 65 -7.9 -8.65 -0.608564748 -0.466428485 0.283851934 67.25385721 -2.253857205 b 0.809638328 7 2 169 57 -6.9 -16.65 -0.531531236 -0.897807431 0.477212693 68.06349553 -11.06349553 8 1 192 85 16.1 11.35 1.24023955 0.612018879 0.759050019 86.68517709 -1.685177088 R 0.566735369 9 2 160 54 -15.9 -19.65 -1.224832847 -1.059574536 1.297801695 60.77675058 -6.776750578 R2 0.321188978 10 1 190 92 14.1 18.35 1.086172525 0.989475457 1.074741055 85.06590043 6.934099569 11 2 162 48 -13.9 -25.65 -1.070765822 -1.383108745 1.480985573 62.39602723 -14.39602723 12 2 185 79 9.1 5.35 0.701004963 0.28848467 0.202229185 81.01770879 -2.017708789 13 2 195 80 19.1 6.35 1.471340087 0.342407038 0.503797201 89.11409207 -9.114092073 14 1 160 60 -15.9 -13.65 -1.224832847 -0.736040326 0.901526369 60.77675058 -0.776750578 15 2 152 80 -23.9 6.35 -1.841100947 0.342407038 -0.630405922 54.29964395 25.70035605 16 1 191 63 15.1 -10.65 1.163206037 -0.574273222 -0.667998078 85.87553876 -22.87553876 17 1 183 105 7.1 31.35 0.546937938 1.690466244 0.924580122 79.39843213 25.60156787 18 1 189 71 13.1 -2.65 1.009139013 -0.142894276 -0.144200188 84.2562621 -13.2562621 19 2 165 51 -10.9 -22.65 -0.839665285 -1.22134164 1.025518177 64.82494222 -13.82494222 20 1 185 115 9.1 41.35 0.701004963 2.229689926 1.563023704 81.01770879 33.98229121 průměr 175.9 73.65 SD 12.98136316 18.54517954 ##### Sheet/List 3 ##### ID Sex Výška Hmotnost H.stř e 1 1 175 91 80.85117354 10.14882646 2 2 170 58 63.18061878 -5.180618777 3 1 185 85 85.65736131 -0.657361309 H = a + b1*V + b2*S 4 2 164 55 60.29690612 -5.296906117 5 1 178 79 82.29302987 -3.293029872 a 12.01034851 12.03436156 12.01034851 6 2 168 65 62.21938122 2.780618777 b1 0.480618777 0.480497068 -15.26746088 7 2 169 57 62.7 -5.7 b2 -15.26746088 -15.26917129 0.480618777 8 1 192 85 89.02169275 -4.021692745 9 2 160 54 58.37443101 -4.37443101 SS 3616.854979 3922.55 10 1 190 92 88.06045519 3.939544808 R 0.668208667 3863.49 11 2 162 48 59.33566856 -11.33566856 12 2 185 79 70.38990043 8.610099573 13 2 195 80 75.19608819 4.803911807 14 1 160 60 73.64189189 -13.64189189 15 2 152 80 54.5294808 25.4705192 16 1 191 63 88.54107397 -25.54107397 17 1 183 105 84.69612376 20.30387624 18 1 189 71 87.57983642 -16.57983642 19 2 165 51 60.77752489 -9.777524893 20 1 185 115 85.65736131 29.34263869 průměr 175.9 73.65 SD 12.98136316 18.54517954 VÝSLEDEK Regresní statistika Násobné R 0.668208667 Hodnota spolehlivosti R 0.446502823 Nastavená hodnota spolehlivosti R 0.381385508 Chyba stř. hodnoty 14.58616383 Pozorování 20 ANOVA Rozdíl SS MS F Významnost F Regrese 2 2917.695021 1458.847511 6.856898556 0.006553616 Rezidua 17 3616.854979 212.7561752 Celkem 19 6534.55 Koeficienty Chyba stř. hodnoty t Stat Hodnota P Dolní 95% Horní 95% "Dolní 95,0%" "Horní 95,0%" Hranice 12.01034851 61.33395275 0.195818922 0.847073466 -117.3929804 141.4136775 -117.3929804 141.4136775 Sex -15.26746088 7.782166771 -1.961852185 0.066365763 -31.68639756 1.1514758 -31.68639756 1.1514758 Výška 0.480618777 0.307530671 1.562832011 0.13651493 -0.168214223 1.129451776 -0.168214223 1.129451776 ##### Sheet/List 4 ##### ID Sex Výška Hmotnost zV zH zS zV.stř zH.stř eV eH 1 1 175 91 -0.069330161 0.935553089 -0.974679434 0.531531236 0.590449932 -0.600861397 0.345103157 2 2 170 58 -0.454497723 -0.843885063 0.974679434 -0.531531236 -0.590449932 0.077033512 -0.253435131 3 1 185 85 0.701004963 0.612018879 -0.974679434 0.531531236 0.590449932 0.169473727 0.021568947 4 2 164 55 -0.916698798 -1.005652167 0.974679434 -0.531531236 -0.590449932 -0.385167562 -0.415202235 5 1 178 79 0.161770376 0.28848467 -0.974679434 0.531531236 0.590449932 -0.36976086 -0.301965262 6 2 168 65 -0.608564748 -0.466428485 0.974679434 -0.531531236 -0.590449932 -0.077033512 0.124021447 7 2 169 57 -0.531531236 -0.897807431 0.974679434 -0.531531236 -0.590449932 0 -0.307357499 8 1 192 85 1.24023955 0.612018879 -0.974679434 0.531531236 0.590449932 0.708708314 0.021568947 9 2 160 54 -1.224832847 -1.059574536 0.974679434 -0.531531236 -0.590449932 -0.693301612 -0.469124604 10 1 190 92 1.086172525 0.989475457 -0.974679434 0.531531236 0.590449932 0.554641289 0.399025525 11 2 162 48 -1.070765822 -1.383108745 0.974679434 -0.531531236 -0.590449932 -0.539234587 -0.792658813 12 2 185 79 0.701004963 0.28848467 0.974679434 -0.531531236 -0.590449932 1.232536199 0.878934602 13 2 195 80 1.471340087 0.342407038 0.974679434 -0.531531236 -0.590449932 2.002871323 0.93285697 14 1 160 60 -1.224832847 -0.736040326 -0.974679434 0.531531236 0.590449932 -1.756364083 -1.326490258 15 2 152 80 -1.841100947 0.342407038 0.974679434 -0.531531236 -0.590449932 -1.309569711 0.93285697 16 1 191 63 1.163206037 -0.574273222 -0.974679434 0.531531236 0.590449932 0.631674802 -1.164723154 17 1 183 105 0.546937938 1.690466244 -0.974679434 0.531531236 0.590449932 0.015406702 1.100016312 18 1 189 71 1.009139013 -0.142894276 -0.974679434 0.531531236 0.590449932 0.477607777 -0.733344208 19 2 165 51 -0.839665285 -1.22134164 0.974679434 -0.531531236 -0.590449932 -0.30813405 -0.630891708 20 1 185 115 0.701004963 2.229689926 -0.974679434 0.531531236 0.590449932 0.169473727 1.639239994 průměr 1.5 175.9 73.65 r12*S 0.35443522 0.35443522 SD 0.512989176 12.98136316 18.54517954 rSV -0.545339541 rSH -0.605788848 rVH 0.566735369