číslo sex výška hmotnost Vi - mV Hi - mH ( ) x ( ) 1 1 180 95 6.3 19.05 120.015 2 2 168 72 -5.7 -3.95 22.515 1 N (xi-mx)(yi-my) 3 1 172 80 -1.7 4.05 -6.885 rxy = ------------- S ------------- 4 2 170 59 -3.7 -16.95 62.715 N - 1 i=1 sxsy 5 2 175 60 1.3 -15.95 -20.735 6 1 190 100 16.3 24.05 392.015 7 2 160 120 -13.7 44.05 -603.485 cxy = sxrxysy 8 1 205 80 31.3 4.05 126.765 9 1 178 63 4.3 -12.95 -55.685 10 2 165 59 -8.7 -16.95 147.465 rxy2 koeficient determinace 11 1 182 71 8.3 -4.95 -41.085 12 2 175 50 1.3 -25.95 -33.735 13 1 165 78 -8.7 2.05 -17.835 14 2 155 50 -18.7 -25.95 485.265 15 1 179 120 5.3 44.05 233.465 16 1 171 80 -2.7 4.05 -10.935 17 1 193 90 19.3 14.05 271.165 18 2 167 57 -6.7 -18.95 126.965 19 1 170 90 -3.7 14.05 -51.985 20 2 154 45 -19.7 -30.95 609.715 Průměr 173.7 75.95 SD 12.49884205 21.72913397 r 0.340239327 c 92.40526316 r 0.340239327 r2 0.1157628 t 1.535098942 df 18 p 0.142149903 ##### Sheet/List 2 ##### číslo sex výška hmotnost Vi - mV Hi - mH ( ) x ( ) 1 1 180 95 6.3 19.05 120.015 2 2 168 72 -5.7 -3.95 22.515 1 N (xi-mx)(yi-my) 3 1 172 80 -1.7 4.05 -6.885 rxy = ------------- S ------------- 4 2 170 59 -3.7 -16.95 62.715 N - 1 i=1 sxsy 5 2 175 60 1.3 -15.95 -20.735 6 1 190 100 16.3 24.05 392.015 7 2 160 90 -13.7 14.05 -192.485 cxy = sxrxysy 8 1 205 110 31.3 34.05 1065.765 9 1 178 63 4.3 -12.95 -55.685 10 2 165 59 -8.7 -16.95 147.465 rxy2 koeficient determinace 11 1 182 71 8.3 -4.95 -41.085 12 2 175 50 1.3 -25.95 -33.735 13 1 165 78 -8.7 2.05 -17.835 14 2 155 50 -18.7 -25.95 485.265 15 1 179 120 5.3 44.05 233.465 16 1 171 80 -2.7 4.05 -10.935 17 1 193 90 19.3 14.05 271.165 18 2 167 57 -6.7 -18.95 126.965 19 1 170 90 -3.7 14.05 -51.985 20 2 154 45 -19.7 -30.95 609.715 Průměr 173.7 75.95 SD 12.49884205 20.98990986 r 0.623053798 c 163.4578947 r 0.623053798 r2 0.388196035 t 3.379524948 df 18 p 0.003339516 ##### Sheet/List 3 ##### číslo sex výška hmotnost Vi - mV Hi - mH ( ) x ( ) Hstř e 1 1 180 95 6.3 19.05 120.015 82.54184354 12.45815646 2 2 168 72 -5.7 -3.95 22.515 69.98595108 2.014048919 1 N (xi-mx)(yi-my) 3 1 172 80 -1.7 4.05 -6.885 74.17124857 5.828751432 rxy = ------------- S ------------- 4 2 170 59 -3.7 -16.95 62.715 72.07859982 -13.07859982 N - 1 i=1 sxsy 5 2 175 60 1.3 -15.95 -20.735 77.31022168 -17.31022168 6 1 190 100 16.3 24.05 392.015 93.00508726 6.994912742 7 2 160 90 -13.7 14.05 -192.485 61.61535611 28.38464389 cxy = sxrxysy 8 1 205 110 31.3 34.05 1065.765 108.6999528 1.300047167 9 1 178 63 4.3 -12.95 -55.685 80.4491948 -17.4491948 10 2 165 59 -8.7 -16.95 147.465 66.84697797 -7.846977966 rxy2 koeficient determinace 11 1 182 71 8.3 -4.95 -41.085 84.63449228 -13.63449228 12 2 175 50 1.3 -25.95 -33.735 77.31022168 -27.31022168 Y = a + bX + e 13 1 165 78 -8.7 2.05 -17.835 66.84697797 11.15302203 H = a + bV + e e = H - (a + bV) = H - Hstř 14 2 155 50 -18.7 -25.95 485.265 56.38373425 -6.38373425 b 15 1 179 120 5.3 44.05 233.465 81.49551917 38.50448083 X Y e 16 1 171 80 -2.7 4.05 -10.935 73.1249242 6.875075804 17 1 193 90 19.3 14.05 271.165 96.14406037 -6.144060373 sy 18 2 167 57 -6.7 -18.95 126.965 68.93962671 -11.93962671 b = rxy ------------- 19 1 170 90 -3.7 14.05 -51.985 72.07859982 17.92140018 sx 20 2 154 45 -19.7 -30.95 609.715 55.33740988 -10.33740988 a = my - bmx Průměr 173.7 75.95 SD 12.49884205 20.98990986 r 0.623053798 c 163.4578947 b 1.046324372 r 0.623053798 r2 0.388196035 a -105.7965434 t 3.379524948 df 18 p 0.003339516 ##### Sheet/List 4 ##### číslo sex výška hmotnost Vi - mV Hi - mH ( ) x ( ) Hstř e SUMMARY OUTPUT 1 1 180 95 6.3 19.05 120.015 88.57741311 6.422586889 H = a + b1V + b2S + e 2 2 168 72 -5.7 -3.95 22.515 61.57510764 10.42489236 Regression Statistics 3 1 172 80 -1.7 4.05 -6.885 84.34250315 -4.342503145 a 13.94187941 Multiple R 0.738643875 4 2 170 59 -3.7 -16.95 62.715 62.63383513 -3.63383513 b1 0.529363746 R Square 0.545594773 5 2 175 60 1.3 -15.95 -20.735 65.28065386 -5.280653858 b2 -20.64994052 Adjusted R Square 0.492135335 6 1 190 100 16.3 24.05 392.015 93.87105057 6.128949432 Standard Error 14.95838036 7 2 160 90 -13.7 14.05 -192.485 57.34019767 32.65980233 SS 3803.803441 Observations 20 8 1 205 110 31.3 34.05 1065.765 101.8115068 8.188493247 9 1 178 63 4.3 -12.95 -55.685 87.51868562 -24.51868562 R 0.738643874 ANOVA 10 2 165 59 -8.7 -16.95 147.465 59.9870164 -0.987016402 R2 0.545594773 df SS MS F Significance F 11 1 182 71 8.3 -4.95 -41.085 89.6361406 -18.6361406 Regression 2 4567.146569 2283.573284 10.20577076 0.001225373 12 2 175 50 1.3 -25.95 -33.735 65.28065386 -15.28065386 V H Residual 17 3803.803431 223.753143 13 1 165 78 -8.7 2.05 -17.835 80.63695693 -2.636956926 S -0.612970585 -0.695376325 Total 19 8370.95 14 2 155 50 -18.7 -25.95 485.265 54.69337894 -4.693378945 H 0.623053798 15 1 179 120 5.3 44.05 233.465 88.04804937 31.95195063 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% "Lower 95,0%" "Upper 95,0%" 16 1 171 80 -2.7 4.05 -10.935 83.8131394 -3.8131394 Intercept 13.92790637 68.70115086 0.202731777 0.841751233 -131.0188506 158.8746634 -131.0188506 158.8746634 17 1 193 90 19.3 14.05 271.165 95.4591418 -5.459141805 sex -20.64905529 8.509357347 -2.426629232 0.026649228 -38.60222981 -2.695880762 -38.60222981 -2.695880762 18 2 167 57 -6.7 -18.95 126.965 61.04574389 -4.045743893 výška 0.529437097 0.347498378 1.523567106 0.146002615 -0.203720386 1.262594581 -0.203720386 1.262594581 19 1 170 90 -3.7 14.05 -51.985 83.28377565 6.716224346 20 2 154 45 -19.7 -30.95 609.715 54.1640152 -9.164015199 Průměr 173.7 75.95 SD 12.50 20.99 r 0.623053798 c 163.4578947 r 0.623053798 r2 0.388196035 t 3.379524948 df 18 p 0.003339516 ##### Sheet/List 5 ##### číslo sex výška hmotnost I1 I2 I3 I4 I5 I6 I7 I8 I9 I10 1 1 180 95 rSV -0.612970585 I1 1.00 0.58 0.49 0.43 0.04 0.14 0.54 0.38 0.40 0.50 2 2 168 72 rSH -0.695376325 I2 0.58 1.00 0.46 0.36 -0.03 0.12 0.57 0.55 0.44 0.47 3 1 172 80 rVH 0.623053798 I3 0.49 0.46 1.00 0.36 0.11 0.05 0.47 0.38 0.35 0.29 4 2 170 59 I4 0.43 0.36 0.36 1.00 0.06 -0.04 0.27 0.35 0.42 0.37 5 2 175 60 rVH·S 0.346612246 I5 0.04 -0.03 0.11 0.06 1.00 0.03 0.01 0.13 -0.04 0.01 6 1 190 100 I6 0.14 0.12 0.05 -0.04 0.03 1.00 0.14 0.10 0.07 0.09 7 2 160 90 I7 0.54 0.57 0.47 0.27 0.01 0.14 1.00 0.44 0.29 0.43 8 1 205 110 I8 0.38 0.55 0.38 0.35 0.13 0.10 0.44 1.00 0.41 0.51 9 1 178 63 I9 0.40 0.44 0.35 0.42 -0.04 0.07 0.29 0.41 1.00 0.41 10 2 165 59 I10 0.50 0.47 0.29 0.37 0.01 0.09 0.43 0.51 0.41 1.00 11 1 182 71 12 2 175 50 I1 I2 I3 I4 I5 I6 I7 I8 I9 I10 13 1 165 78 -0.773149995 -0.797466414 -0.669592144 -0.606616316 -0.067529545 -0.160390883 -0.719453212 -0.716559121 -0.643176286 -0.706023695 14 2 155 50 I1 -0.773150 0.597760916 0.616561155 0.517695163 0.469005402 0.052210467 0.124006211 0.556245248 0.554007681 0.497271743 0.545862217 15 1 179 120 I2 -0.797466 0.616561155 0.635952682 0.533977246 0.483756138 0.053852544 0.127906342 0.573739774 0.571431833 0.512911487 0.563030185 16 1 171 80 I3 -0.669592 0.517695163 0.533977246 0.448353639 0.406185519 0.045217253 0.107396475 0.481740219 0.479802358 0.430665788 0.47274792 17 1 193 90 I4 -0.606616 0.469005402 0.483756138 0.406185519 0.367983355 0.040964524 0.097295727 0.436432057 0.434676454 0.390161229 0.428285493 18 2 167 57 I5 -0.067530 0.052210467 0.053852544 0.045217253 0.040964524 0.004560239 0.010831123 0.048584348 0.048388911 0.043433402 0.047677459 19 1 170 90 I6 -0.160391 0.124006211 0.127906342 0.107396475 0.097295727 0.010831123 0.025725235 0.115393736 0.11492955 0.103159612 0.113239764 20 2 154 45 I7 -0.719453 0.556245248 0.573739774 0.481740219 0.436432057 0.048584348 0.115393736 0.517612925 0.515530761 0.462735245 0.507951016 I8 -0.716559 0.554007681 0.571431833 0.479802358 0.434676454 0.048388911 0.11492955 0.515530761 0.513456973 0.460873834 0.505907718 I9 -0.643176 0.497271743 0.512911487 0.430665788 0.390161229 0.043433402 0.103159612 0.462735245 0.460873834 0.413675735 0.454097698 I10 -0.706024 0.545862217 0.563030185 0.47274792 0.428285493 0.047677459 0.113239764 0.507951016 0.505907718 0.454097698 0.498469458 ##### Sheet/List 6 ##### číslo sex výška hmotnost 1 1 175 77 rSV ° H -0.013274471 2 2 170 58 rSH ° V -0.597324705 3 1 172 93 rVH ° S 0.661453364 4 2 152 48 5 1 180 83 Korelace 6 1 177 80 7 2 158 50 sex výška hmotnost 8 2 165 55 sex 9 1 186 90 výška -0.678943677 10 2 164 45 hmotnost -0.808226174 0.83471563 11 2 158 60 12 1 192 94 13 1 168 65 14 2 175 60 15 1 198 96 16 1 168 62 17 2 174 62 18 1 186 106 19 2 167 51 20 1 182 71 ##### Sheet/List 7 ##### R House Child Shop f House 1 0.863113 0.549620 House 0.930528765 -0.911243 Child 0.863113 1 0.535640 Child 0.925594696 -0.930573 Shop 0.549620 0.535640 1 Shop 0.76770849 -0.813854 0.930528765 0.925594696 0.76770849 R se stř. House Child Shop 0.930528765 0.865883782 House 0.865883782 0.861292 0.714375 0.925594696 0.861292489 Child 0.861292 0.856725541 0.710587 0.76770849 0.714374833 Shop 0.714375 0.710587 0.589376326 R rez. House Child Shop House 0.134116218 0.00182096 -0.164755163 Child 0.00182096 0.143274459 -0.174947125 Shop -0.164755163 -0.174947125 0.410623674 SS 0.322634684 ##### Sheet/List 8 ##### R WORK TRANSPORT HOUSEHOLD CHILDREN SHOPPING PERSONAL CARE MEAL SLEEP TV LEISURE F1 F2 WORK 1.000000 0.933080 -0.910894 -0.834194 -0.659432 -0.032368 -0.456959 -0.630458 0.128058 -0.452111 0.537699 -0.831283 TRANSPORT 0.933080 1.000000 -0.866047 -0.766630 -0.488073 -0.044059 -0.596350 -0.772311 0.166808 -0.380433 0.655254 -0.723611 HOUSEHOLD -0.910894 -0.866047 1.000000 0.863113 0.549620 -0.076672 0.300474 0.452223 -0.403996 0.160198 -0.382645 0.844966 CHILDREN -0.834194 -0.766630 0.863113 1.000000 0.535640 -0.044549 0.315813 0.307995 -0.110707 0.076637 -0.326477 0.791489 SHOPPING -0.659432 -0.488073 0.549620 0.535640 1.000000 0.496551 -0.199914 0.080194 0.051567 0.248532 0.175901 0.872870 PERSONAL CARE -0.032368 -0.044059 -0.076672 -0.044549 0.496551 1.000000 -0.247624 -0.089321 0.115720 0.055605 0.415705 0.363819 MEAL -0.456959 -0.596350 0.300474 0.315813 -0.199914 -0.247624 1.000000 0.810766 0.265190 0.336731 -0.937827 -0.042436 SLEEP -0.630458 -0.772311 0.452223 0.307995 0.080194 -0.089321 0.810766 1.000000 -0.008385 0.525314 -0.886892 0.214444 TV 0.128058 0.166808 -0.403996 -0.110707 0.051567 0.115720 0.265190 -0.008385 1.000000 0.008160 -0.100672 -0.276904 LEISURE -0.452111 -0.380433 0.160198 0.076637 0.248532 0.055605 0.336731 0.525314 0.008160 1.000000 -0.492990 0.185705 R se stř. WORK TRANSPORT HOUSEHOLD CHILDREN SHOPPING PERSONAL CARE MEAL SLEEP TV LEISURE WORK 0.980151 0.953855 -0.908154 -0.833497 -0.631019 -0.078912 -0.468992 -0.655144 0.176054 -0.419454 TRANSPORT 0.953855 0.952972 -0.862157 -0.786656 -0.516358 0.009129 -0.583808 -0.736314 0.134405 -0.457413 HOUSEHOLD -0.908154 -0.862157 0.860385 0.793706 0.670238 0.148347 0.322998 0.520563 -0.195453 0.345555 CHILDREN -0.833497 -0.786656 0.793706 0.733042 0.633439 0.152240 0.272591 0.459280 -0.186299 0.307934 SHOPPING -0.631019 -0.516358 0.670238 0.633439 0.792843 0.390689 -0.202006 0.031176 -0.259409 0.075379 PERSONAL CARE -0.078912 0.009129 0.148347 0.152240 0.390689 0.305175 -0.405299 -0.290667 -0.142593 -0.137376 MEAL -0.468992 -0.583808 0.322998 0.272591 -0.202006 -0.405299 0.881320 0.822651 0.106163 0.454459 SLEEP -0.655144 -0.736314 0.520563 0.459280 0.031176 -0.290667 0.822651 0.832563 0.029905 0.477052 TV 0.176054 0.134405 -0.195453 -0.186299 -0.259409 -0.142593 0.106163 0.029905 0.086811 -0.001792 LEISURE -0.419454 -0.457413 0.345555 0.307934 0.075379 -0.137376 0.454459 0.477052 -0.001792 0.277526 R rez. WORK TRANSPORT HOUSEHOLD CHILDREN SHOPPING PERSONAL CARE MEAL SLEEP TV LEISURE WORK 0.019849 -0.020775 -0.002740 -0.000697 -0.028412 0.046544 0.012032 0.024686 -0.047996 -0.032657 SS 3.333364552 TRANSPORT -0.020775 0.047028 -0.003890 0.020026 0.028285 -0.053189 -0.012542 -0.035997 0.032403 0.076980 HOUSEHOLD -0.002740 -0.003890 0.139615 0.069407 -0.120618 -0.225019 -0.022524 -0.068340 -0.208543 -0.185357 CHILDREN -0.000697 0.020026 0.069407 0.266958 -0.097799 -0.196788 0.043221 -0.151286 0.075592 -0.231297 SHOPPING -0.028412 0.028285 -0.120618 -0.097799 0.207157 0.105862 0.002092 0.049018 0.310977 0.173153 PERSONAL CARE 0.046544 -0.053189 -0.225019 -0.196788 0.105862 0.694825 0.157675 0.201346 0.258312 0.192980 MEAL 0.012032 -0.012542 -0.022524 0.043221 0.002092 0.157675 0.118680 -0.011885 0.159026 -0.117727 SLEEP 0.024686 -0.035997 -0.068340 -0.151286 0.049018 0.201346 -0.011885 0.167437 -0.038290 0.048262 TV -0.047996 0.032403 -0.208543 0.075592 0.310977 0.258312 0.159026 -0.038290 0.913189 0.009953 LEISURE -0.032657 0.076980 -0.185357 -0.231297 0.173153 0.192980 -0.117727 0.048262 0.009953 0.722474