We want to find a regression model that explains the academic performance in college. Our baseline regression model is: colgpa = Be + B. Inchsize) + B (In(hsize)) + Bghsperc + BeIn(sat) + Bxfemale +Rathlete + u where colgpa measures the cumulative college grade point average hsize is the size of the high school graduating class hsperc is the academic percentile in the high-school graduating class sat measures the combined SAT score female is a dummy variable summarizing the gender athlete is a dummy variable indicating whether the person is a student-athlete Using the data in "Computer_Exercise_12.xlsx", please answer the following questions. Note that the data is not normally distributed, but the sample size is large enough). 1. From the data, generate the two dummy variables, and the other variables of the model. 2. Consider the baseline regression model above. What are your expectations for the coefficients in this equation? Which ones are you unsure about? Explain. 3. Estimate the baseline regression and report the results in the usual form. What is the estimated GPA differential between athlete and non-athletes? Is it statistically significant? 4. Now modify the baseline regression model in such a way to allow the effect of being an athlete to differ by gender. To that end, introduce three dummy variables into the model (see slides 25-29, Chapter 7). Test the null hypothesis that there is no ceteris paribus difference between women athletes and women non-athletes. 5. In the model in part 4. above, what is the estimated intercept for (a) a female athlete, (b) a male athlete, (c) a female non-athlete, and (d) a male non-athlete? 6. Which model fits the data best; the model in part 3. or in part 4.? Explain your answer. 7. Show that you could have found the same intercepts as in part 5. by adding the interaction term between the two dummy variables to the baseline model, instead. 8. From your model estimates in part 7., what is the ceteris paribus effect of an increase in the combined SAT score by 6% on predicted college GPA? B C 1 Cross-sectional data set from Wooldridge 2 1. studenti student identification number 3 2. sat combined SAT score 4 3. tothrs total hours through fal semester 5 4. colgpa GPA after fall semester 6 5. student-athlete? 7 6. verbmath verbalmath SAT score 8 7. hsize size graduating class 9 8. hsrank rank in graduating class 10 9. hsperc high school percentile, from top 11 10. gender 12 13 studenti sat tothrs colgpa student-atl verbmath hsize hsrank hsperc gender 14 783813 920 43 2.04 athlete 0.48387 10 4 40 female 15 848389 1170 18 4 non-athlete 0.82813 940 191 20.31915 male 16 465081 810 14 1.78 athlete 0.88372 119 42 35.29412 male 17 740300 940 40 2.42 non-athlete 0.80769 571 252 44.1331 male 18 400647 1180 18 2.61 non-athlete 0.73529 214 86 40.18692 male 19 906469 980 114 3.03 non-athlete 0.81481 268 41 15.29851 female 20 590122 880 78 1.84 non-athlete 0.76 311 161 51.76849 male 21 682362 980 55 3.05 non-athlete 0.88462 268 101 37.68657 male 22 B77093 1240 18 3 non-athlete 0.69863 367 161 43.86921 male 23 816053 1230 17 2 non-athlete 0.86364 10 3 30 male 906466 1140 78 2.98 non-athlete 0.9322 334 95 28.44311 female 25 243522 1150 43 2.93 non-athlete 0.85484 359 13 3.62117 female 26 372079 1080 17 2 athlete 0.8 318 31 9.748427 male 27 999286 990 64 2.21 non-athlete 0.67797 192 51 26.5625 female 28 427833 1000 45 3.33 non-athlete 0.78571 369 29 7.859078 female 29 163044 1050 14 1.07 non-athlete 0.77966 266 134 50.37594 female 30 289127 1160 41 2.29 non-athlete 0.87097 145 99 68.27586 female 31 862812 1190 13 3.15 non-athlete 1.125 176 74 42.04546 male 32 692744 1030 110 2.65 non-athlete 1.10204 386 81 20.98446 female 33 731083 960 106 2.41 athlete 1 383 66 17.23238 male 34 655137 840 104 2.39 non-athlete 0.64706 107 7 6.542056 male 35 218437 920 115 2.64 non-athlete 1 217 65 29.95392 female 36 428916 840 96 2.18 non-athlete 0.86667 234 141 60.25641 female 37 955470 1000 50 2.84 non-athlete 0.78571 463 133 28.7257 male 38 112281 1150 100 2.84 non-athlete 0.79688 595 301 50.58823 female 39 553988 1040 112 2.93 non-athlete 0.96226 91 30 32.96703 male 40 599974 970 17 2.29 non-athlete 0.7963 436 41 9.403669 female 41 940359 1200 39 2.38 non-athlete 0.90476 812 209 25.73892 female 42 518753 1090 118 3.92 non-athlete 0.75806 60 2 3.333333 female 43 962788 1340 46 2.23 non-athlete 0.83562 376 130 34.57447 male 44 551081 740 12 1.33 non-athlete 1.3125 532 390 73.30827 female 45 271376 880 85 2.81 non-athlete 0.76 380 71 18.68421 male 24 = var Paste BI VE $ % 9 90 020 G K A B C 48 49 50 51 52 53 54 730 820 780 1040 870 940 56 57 58 59 50 16 71 78 13 19 47 103 105 72 18 16 15 42 14 17 38 15 18 29 482 390 78 492 186 185 152 10 637 12 252 10 127 13 3 28 32 372 254 54 55 56 57 58 59 202 79 537225 188852 338629 653150 453519 712578 261304 123862 874954 133662 627260 590096 769803 366714 578690 667048 352291 809106 484617 457456 569341 907915 688936 747889 714429 729534 346141 578110 267294 228655 466712 402434 637456 917449 231864 395303 763198 433753 103542 115749 854767 737745 818310 131609 774748 980 1020 1180 1100 1030 960 910 1060 880 1010 700 930 900 1090 1120 960 890 1240 1090 820 940 820 970 790 1080 850 850 820 1120 880 1540 780 1280 1260 830 980 500 1040 930 D E F 1.9 athlete 0.78049 3 non-athlete 0.86364 2.4 athlete 0.69565 2.16 non-athlete 1.03922 2.07 non-athlet 1.175 2.21 non-athlete 1.29268 2 athlete 0.92157 2.91 non-athlete 0.96154 3 athlete 0.87302 2.72 non-athlete 1.11538 3.55 non-athlete 1.10204 3.25 non-athlete 1.04255 2.86 non-athlete 1.45946 2.04 non-athlete 0.96296 1.92 non-athlete 1.37838 3.58 non-athlete 0.94231 2.39 athlete 1 3.46 non-athlete 0.86 3.16 non-athlete 0.91489 1.03 non-athlete 0.91228 3 non-athlete 1.24 2.33 athlete 0.77778 2.45 athlete 0.78 3.65 non-athlete 0.7971 3.61 non-athlete 0.84746 3.25 non-athlete 1.10256 3.81 non-athlete 0.77358 2.25 athlete 1.10256 2.41 athlete 0.67241 2.82 athlete 1.07895 2.3 non-athlete 1.11765 3.27 non-athlete 0.80851 2.66 athlete 0.80851 2.26 athlete 0.70833 2.33 athlete 0.67164 2.37 athlete 1.09524 4 non-athlete 0.97436 3.81 non-athlete 1 3.87 non-athlete 1.03175 4 non-athlete 0.75 1.95 athlete 0.84444 2.43 non-athlete 0.68966 1.21 athlete 1.27273 3 non-athlete 0.96226 1.75 non-athlete 0.82353 15 37 47 113 47 16 40 39 17 13 48 15 95 12 43 85 86 55 13 83 16 14 15 12 14 75 76 77 78 79 30 81 32 33 34 85 B6 B7 88 89 90 91 92 H 273 56.639 male 102 26.15385 female 17 21.79487 male 92 18.69919 male 86 46.23656 female 41 22.16216 male 45 29.60526 male 2 20 female 255 40.0314 malo 2 16.66667 male 27 10.71429 male 5 50 female 28 22.04725 male 1 7.692307 male 1 33.33333 female 2 7.142857 female 22 68.75 male 67 18.01075 female 69 27.16535 male 121 59.90099 male 78 16.59575 female 320 71.58836 male 50 40.32258 male 31 5.772812 male 50 13.73626 female 68 10.72555 female 53 15.49708 male 344 60.24518 male 83 14.66431 male 72 12.0603 male 7 70 female 54 17.41936 female 5 6.849315 female 98 74.80916 male 20 4.098361 male 70 17.19902 female 1 0.434783 male 38 10.95101 male 3 1.477833 female 5 2.304147 female 84 42 male 28 30.43478 male 329 71.99125 male 31 8.587257 male 26 8 female 470 447 124 537 364 634 342 571 566 597 10 310 73 131 488 407 230 347 203 217 200 92 457 361 325 10 Arial $ % , H av Av Paste BI U 20 E B TONIO 543222 444608 936709 909559 710404 613429 339125 0 958248 1 154924 2 441243 3 912441 4 353541 5 569951 6 802223 7 257035 8 101562 9 930597 0 168979 1 457366 2 749774 724998 14 748555 15 896494 16 417106 17 177166 272701 19 364122 20 587348 21 333708 22 249622 561272 24 868658 25 479620 26 900814 27 421058 28 115211 29 374667 30 759203 31 140976 32 309994 33 769422 34 855079 135 350580 136 650131 137 916031 570 820 1310 770 1180 1310 1150 1130 1110 1210 1090 1040 1340 900 650 1190 990 1160 1140 1180 1120 1010 1160 1200 720 1190 970 1210 930 1000 970 960 980 960 970 960 1160 1080 990 1130 1060 1060 1120 1030 1070 79 13 16 15 18 53 63 113 122 16 20 54 81 76 52 77 16 50 71 87 49 15 113 16 16 36 14 17 49 74 42 45 47 118 79 79 96 80 14 18 12 15 73 17 48 D F SOS 1.73 athlete 0.96552 1.84 non-athlete 0.82222 2.25 non-athlete 0.95522 2.13 non-athlete 0.7907 3.77 non-athlete 0.87302 3.22 non-athlete 0.92647 2.17 non-athlete 1.12963 2.77 non-athlete 0.91525 3.36 non-athlete 1.09434 3.62 non-athlete 1.01667 3.7 non-athlete 1.01852 2 non-athlete "0.82456 3.69 non-athlete 1.0303 1.75 non-athlete 0.91489 2.19 athlete 0.80556 3.4 non-athlete 0.67606 1.43 non-athlete 0.73684 2.78 non-athlete 0.73134 2.61 athlete 0.58333 3.09 athlete 1.18519 2.83 non-athlete 0.83607 1.93 non-athlete 0.77193 2.88 non-athlete 0.9661 3.31 non-athlete 1.10526 1.93 athlete 0.94595 2.41 non-athlete 0.91935 2.92 non-athlete 0.76364 3.52 non-athlete 0.95161 2.93 non-athlete 0.72222 2.28 non-athlete 0.85185 1.95 non-athlete 0.76364 3.02 athlete 0.88235 3.25 non-athlete 1.27907 3.32 non-athlete 0.92 2.03 athlete 0.73214 2.34 non-athlete 1 3.41 non-athlete 0.93333 2.56 non-athlete 0.6875 4 non-athlete 0.8 1.33 non-athlete 0.79365 2.25 non-athlete 0.85965 2.6 non-athlete 0.89286 2.63 non-athlete 0.77778 2.58 non-athlete 0.63492 3.04 non-athlets 0.78333 G UU 324 303 467 100 480 320 302 166 204 293 187 355 111 86 206 424 251 372 241 469 10 319 402 432 430 261 341 511 200 236 433 10 10 226 10 74 212 212 305 235 235 235 295 278 315 187 57.71605 male 147 48.51485 female 122 26.1242 male 30 30 female 48 10 male 30 9.375 male 64 21.19205 male 33 19.87952 male 9 4.411765 female 14 4.778157 male 6 3.208556 female 82 23.09859 female 15 13.51351 female 16 18.60465 male 57 27.6699 male 26 6.132075 female 39 15.53785 female 79 21.23656 female 24 9.958507 male 36 7.675906 male 1 10 female 157 49.2163 female 15 3.731343 male 209 48.37963 female 230 53.48837 female 97 37.16475 male 116 34.0176 female 1 0.195695 female 65 32.5 male 75 31.77966 male 130 30.02309 male 3 30 female 4 40 male 96 42.47787 male 3 30 male 7 9.459459 female 19 8.962264 male 100 47.16981 malo 3 0.983607 female 91 38.7234 female 66 28.08511 male 44 18.7234 female 15 5.084746 male 59 21.22302 male 2 Insert Draw Home Page Layout General 10 ~ A K Arial ||||| HIU III [G YA $ % ) Paste BIUP 020 K J H G E B 13 108 38 39 40 106 372 373 373 371 410 600 285 217 42 43 156 45 46 47 48 49 50 151 52 53 154 155 156 157 58 159 160 17 46 35 15 16 17 50 48 104 41 14 107 18 14 15 110 102 15 192267 170363 654191 901333 333724 295748 869121 966109 153599 181529 677002 681866 342884 842535 798515 127094 118482 649113 840716 829904 473652 B26127 129624 279861 507164 433468 793342 209975 824842 959096 952474 621621 114486 379083 246902 987474 886599 920841 169206 863096 884925 647777 967630 443593 910 1100 1000 1000 970 1070 950 1140 1060 940 960 890 1120 1150 1270 1100 1150 1090 1220 1070 1030 980 930 1030 1100 1100 1070 980 1000 1190 1060 1240 950 1300 860 1010 1180 1040 1010 1000 1030 1100 1240 1110 1070 D F 2.76 non-athlete 0.75 1.95 non-athlete 1 2.92 non-athlete 0.78571 3.41 non-athlete 0.75439 2.73 non-athlete 0.67241 2.54 non-athlete 0.55072 3.06 non-athlete 0.66667 1.93 non-athlete 0.86885 3.23 non-athlet 0.89286 2.54 athlete 0.70909 2.22 non-athlete 0.71429 1.99 non-athlete 0.93478 1.75 non-athlete 0.89831 3.14 non-athlete 0.8254 3.24 non-athlete 0.78873 2 non-athlete 0.83333 2.5 non-athlete 0.94915 1.6 non-athlete 0.91228 3.05 non-athlete 0.84848 2.41 non-athlete 0.7541 2.73 non-athlete 1.01961 2.93 non-athlete 0.63333 2.5 non-athlete 0.82353 2.69 non-athlete 0.98077 2.61 athlete 0.80328 2.94 non-athlete 0.92982 3.44 non-athlete 0.91071 3.12 non-athlete 0.75 3.46 non-athlete 1.12766 3.64 non-athlete 1.01695 2.57 non-athlete 0.65625 3.43 non-athlete 0.85075 2.24 non-athlete 0.86275 2.78 non-athlete 0.66667 2.13 athlete 0.45763 2.69 non-athlete 0.74138 3.29 non-athlete 0.76119 2.31 non-athlete 1 2.31 non-athlete 0.74138 1.88 non-athlete 0.85185 2.47 non-athlete 0.74576 2.66 non-athlete 0.92982 2.77 non-athlett 0.77143 3.77 athlete 0.91379 1 non-athleted 87710 85 22.84946 male 188 50.40215 male 127 34.04826 male 99 26.68464 male 113 27.56098 female 62 10.33333 male 24 8.421053 male 34 15.6682 female 27 17 30769 male 45 17.92829 male 39 39 male 38 18.09524 male 152 46.34146 female 4 40 male 4 40 male 4 40 female 5 50 male 79 52.66667 male 5 50 female 5 50 male 4 2.941176 female 17 5.3125 male 40 14.76015 female 62 20.12987 female 99 32.35294 male 28 9.032258 male 10 5.617978 male 21 9.251101 male 23 12.92135 female 40 22.47191 female 76 29.11877 male 41 13.94558 female 70 33.01887 female 142 54.40613 male 110 40.14598 male 74 28.90625 male 94 36.71875 female 4 40 female 36 18.46154 female 35 17.85714 male 3 30 male 22 9.322034 male 16 27.58621 malo 20 41.66667 female 251 100 210 328 10 10 10 10 150 10 10 136 320 271 308 306 310 178 227 178 178 261 294 212 261 274 256 161 44 43 71 18 50 16 50 17 35 16 115 42 92 94 117 69 16 17 17 18 92 45 14 162 63 164 165 166 167 168 169 170 171 172 173 174 175 258 176 177 178 179 180 181 182 10 195 196 10 236 58 48 10 865023 We want to find a regression model that explains the academic performance in college. Our baseline regression model is: colgpa = Be + B. Inchsize) + B (In(hsize)) + Bghsperc + BeIn(sat) + Bxfemale +Rathlete + u where colgpa measures the cumulative college grade point average hsize is the size of the high school graduating class hsperc is the academic percentile in the high-school graduating class sat measures the combined SAT score female is a dummy variable summarizing the gender athlete is a dummy variable indicating whether the person is a student-athlete Using the data in "Computer_Exercise_12.xlsx", please answer the following questions. Note that the data is not normally distributed, but the sample size is large enough). 1. From the data, generate the two dummy variables, and the other variables of the model. 2. Consider the baseline regression model above. What are your expectations for the coefficients in this equation? Which ones are you unsure about? Explain. 3. Estimate the baseline regression and report the results in the usual form. What is the estimated GPA differential between athlete and non-athletes? Is it statistically significant? 4. Now modify the baseline regression model in such a way to allow the effect of being an athlete to differ by gender. To that end, introduce three dummy variables into the model (see slides 25-29, Chapter 7). Test the null hypothesis that there is no ceteris paribus difference between women athletes and women non-athletes. 5. In the model in part 4. above, what is the estimated intercept for (a) a female athlete, (b) a male athlete, (c) a female non-athlete, and (d) a male non-athlete? 6. Which model fits the data best; the model in part 3. or in part 4.? Explain your answer. 7. Show that you could have found the same intercepts as in part 5. by adding the interaction term between the two dummy variables to the baseline model, instead. 8. From your model estimates in part 7., what is the ceteris paribus effect of an increase in the combined SAT score by 6% on predicted college GPA? B C 1 Cross-sectional data set from Wooldridge 2 1. studenti student identification number 3 2. sat combined SAT score 4 3. tothrs total hours through fal semester 5 4. colgpa GPA after fall semester 6 5. student-athlete? 7 6. verbmath verbalmath SAT score 8 7. hsize size graduating class 9 8. hsrank rank in graduating class 10 9. hsperc high school percentile, from top 11 10. gender 12 13 studenti sat tothrs colgpa student-atl verbmath hsize hsrank hsperc gender 14 783813 920 43 2.04 athlete 0.48387 10 4 40 female 15 848389 1170 18 4 non-athlete 0.82813 940 191 20.31915 male 16 465081 810 14 1.78 athlete 0.88372 119 42 35.29412 male 17 740300 940 40 2.42 non-athlete 0.80769 571 252 44.1331 male 18 400647 1180 18 2.61 non-athlete 0.73529 214 86 40.18692 male 19 906469 980 114 3.03 non-athlete 0.81481 268 41 15.29851 female 20 590122 880 78 1.84 non-athlete 0.76 311 161 51.76849 male 21 682362 980 55 3.05 non-athlete 0.88462 268 101 37.68657 male 22 B77093 1240 18 3 non-athlete 0.69863 367 161 43.86921 male 23 816053 1230 17 2 non-athlete 0.86364 10 3 30 male 906466 1140 78 2.98 non-athlete 0.9322 334 95 28.44311 female 25 243522 1150 43 2.93 non-athlete 0.85484 359 13 3.62117 female 26 372079 1080 17 2 athlete 0.8 318 31 9.748427 male 27 999286 990 64 2.21 non-athlete 0.67797 192 51 26.5625 female 28 427833 1000 45 3.33 non-athlete 0.78571 369 29 7.859078 female 29 163044 1050 14 1.07 non-athlete 0.77966 266 134 50.37594 female 30 289127 1160 41 2.29 non-athlete 0.87097 145 99 68.27586 female 31 862812 1190 13 3.15 non-athlete 1.125 176 74 42.04546 male 32 692744 1030 110 2.65 non-athlete 1.10204 386 81 20.98446 female 33 731083 960 106 2.41 athlete 1 383 66 17.23238 male 34 655137 840 104 2.39 non-athlete 0.64706 107 7 6.542056 male 35 218437 920 115 2.64 non-athlete 1 217 65 29.95392 female 36 428916 840 96 2.18 non-athlete 0.86667 234 141 60.25641 female 37 955470 1000 50 2.84 non-athlete 0.78571 463 133 28.7257 male 38 112281 1150 100 2.84 non-athlete 0.79688 595 301 50.58823 female 39 553988 1040 112 2.93 non-athlete 0.96226 91 30 32.96703 male 40 599974 970 17 2.29 non-athlete 0.7963 436 41 9.403669 female 41 940359 1200 39 2.38 non-athlete 0.90476 812 209 25.73892 female 42 518753 1090 118 3.92 non-athlete 0.75806 60 2 3.333333 female 43 962788 1340 46 2.23 non-athlete 0.83562 376 130 34.57447 male 44 551081 740 12 1.33 non-athlete 1.3125 532 390 73.30827 female 45 271376 880 85 2.81 non-athlete 0.76 380 71 18.68421 male 24 = var Paste BI VE $ % 9 90 020 G K A B C 48 49 50 51 52 53 54 730 820 780 1040 870 940 56 57 58 59 50 16 71 78 13 19 47 103 105 72 18 16 15 42 14 17 38 15 18 29 482 390 78 492 186 185 152 10 637 12 252 10 127 13 3 28 32 372 254 54 55 56 57 58 59 202 79 537225 188852 338629 653150 453519 712578 261304 123862 874954 133662 627260 590096 769803 366714 578690 667048 352291 809106 484617 457456 569341 907915 688936 747889 714429 729534 346141 578110 267294 228655 466712 402434 637456 917449 231864 395303 763198 433753 103542 115749 854767 737745 818310 131609 774748 980 1020 1180 1100 1030 960 910 1060 880 1010 700 930 900 1090 1120 960 890 1240 1090 820 940 820 970 790 1080 850 850 820 1120 880 1540 780 1280 1260 830 980 500 1040 930 D E F 1.9 athlete 0.78049 3 non-athlete 0.86364 2.4 athlete 0.69565 2.16 non-athlete 1.03922 2.07 non-athlet 1.175 2.21 non-athlete 1.29268 2 athlete 0.92157 2.91 non-athlete 0.96154 3 athlete 0.87302 2.72 non-athlete 1.11538 3.55 non-athlete 1.10204 3.25 non-athlete 1.04255 2.86 non-athlete 1.45946 2.04 non-athlete 0.96296 1.92 non-athlete 1.37838 3.58 non-athlete 0.94231 2.39 athlete 1 3.46 non-athlete 0.86 3.16 non-athlete 0.91489 1.03 non-athlete 0.91228 3 non-athlete 1.24 2.33 athlete 0.77778 2.45 athlete 0.78 3.65 non-athlete 0.7971 3.61 non-athlete 0.84746 3.25 non-athlete 1.10256 3.81 non-athlete 0.77358 2.25 athlete 1.10256 2.41 athlete 0.67241 2.82 athlete 1.07895 2.3 non-athlete 1.11765 3.27 non-athlete 0.80851 2.66 athlete 0.80851 2.26 athlete 0.70833 2.33 athlete 0.67164 2.37 athlete 1.09524 4 non-athlete 0.97436 3.81 non-athlete 1 3.87 non-athlete 1.03175 4 non-athlete 0.75 1.95 athlete 0.84444 2.43 non-athlete 0.68966 1.21 athlete 1.27273 3 non-athlete 0.96226 1.75 non-athlete 0.82353 15 37 47 113 47 16 40 39 17 13 48 15 95 12 43 85 86 55 13 83 16 14 15 12 14 75 76 77 78 79 30 81 32 33 34 85 B6 B7 88 89 90 91 92 H 273 56.639 male 102 26.15385 female 17 21.79487 male 92 18.69919 male 86 46.23656 female 41 22.16216 male 45 29.60526 male 2 20 female 255 40.0314 malo 2 16.66667 male 27 10.71429 male 5 50 female 28 22.04725 male 1 7.692307 male 1 33.33333 female 2 7.142857 female 22 68.75 male 67 18.01075 female 69 27.16535 male 121 59.90099 male 78 16.59575 female 320 71.58836 male 50 40.32258 male 31 5.772812 male 50 13.73626 female 68 10.72555 female 53 15.49708 male 344 60.24518 male 83 14.66431 male 72 12.0603 male 7 70 female 54 17.41936 female 5 6.849315 female 98 74.80916 male 20 4.098361 male 70 17.19902 female 1 0.434783 male 38 10.95101 male 3 1.477833 female 5 2.304147 female 84 42 male 28 30.43478 male 329 71.99125 male 31 8.587257 male 26 8 female 470 447 124 537 364 634 342 571 566 597 10 310 73 131 488 407 230 347 203 217 200 92 457 361 325 10 Arial $ % , H av Av Paste BI U 20 E B TONIO 543222 444608 936709 909559 710404 613429 339125 0 958248 1 154924 2 441243 3 912441 4 353541 5 569951 6 802223 7 257035 8 101562 9 930597 0 168979 1 457366 2 749774 724998 14 748555 15 896494 16 417106 17 177166 272701 19 364122 20 587348 21 333708 22 249622 561272 24 868658 25 479620 26 900814 27 421058 28 115211 29 374667 30 759203 31 140976 32 309994 33 769422 34 855079 135 350580 136 650131 137 916031 570 820 1310 770 1180 1310 1150 1130 1110 1210 1090 1040 1340 900 650 1190 990 1160 1140 1180 1120 1010 1160 1200 720 1190 970 1210 930 1000 970 960 980 960 970 960 1160 1080 990 1130 1060 1060 1120 1030 1070 79 13 16 15 18 53 63 113 122 16 20 54 81 76 52 77 16 50 71 87 49 15 113 16 16 36 14 17 49 74 42 45 47 118 79 79 96 80 14 18 12 15 73 17 48 D F SOS 1.73 athlete 0.96552 1.84 non-athlete 0.82222 2.25 non-athlete 0.95522 2.13 non-athlete 0.7907 3.77 non-athlete 0.87302 3.22 non-athlete 0.92647 2.17 non-athlete 1.12963 2.77 non-athlete 0.91525 3.36 non-athlete 1.09434 3.62 non-athlete 1.01667 3.7 non-athlete 1.01852 2 non-athlete "0.82456 3.69 non-athlete 1.0303 1.75 non-athlete 0.91489 2.19 athlete 0.80556 3.4 non-athlete 0.67606 1.43 non-athlete 0.73684 2.78 non-athlete 0.73134 2.61 athlete 0.58333 3.09 athlete 1.18519 2.83 non-athlete 0.83607 1.93 non-athlete 0.77193 2.88 non-athlete 0.9661 3.31 non-athlete 1.10526 1.93 athlete 0.94595 2.41 non-athlete 0.91935 2.92 non-athlete 0.76364 3.52 non-athlete 0.95161 2.93 non-athlete 0.72222 2.28 non-athlete 0.85185 1.95 non-athlete 0.76364 3.02 athlete 0.88235 3.25 non-athlete 1.27907 3.32 non-athlete 0.92 2.03 athlete 0.73214 2.34 non-athlete 1 3.41 non-athlete 0.93333 2.56 non-athlete 0.6875 4 non-athlete 0.8 1.33 non-athlete 0.79365 2.25 non-athlete 0.85965 2.6 non-athlete 0.89286 2.63 non-athlete 0.77778 2.58 non-athlete 0.63492 3.04 non-athlets 0.78333 G UU 324 303 467 100 480 320 302 166 204 293 187 355 111 86 206 424 251 372 241 469 10 319 402 432 430 261 341 511 200 236 433 10 10 226 10 74 212 212 305 235 235 235 295 278 315 187 57.71605 male 147 48.51485 female 122 26.1242 male 30 30 female 48 10 male 30 9.375 male 64 21.19205 male 33 19.87952 male 9 4.411765 female 14 4.778157 male 6 3.208556 female 82 23.09859 female 15 13.51351 female 16 18.60465 male 57 27.6699 male 26 6.132075 female 39 15.53785 female 79 21.23656 female 24 9.958507 male 36 7.675906 male 1 10 female 157 49.2163 female 15 3.731343 male 209 48.37963 female 230 53.48837 female 97 37.16475 male 116 34.0176 female 1 0.195695 female 65 32.5 male 75 31.77966 male 130 30.02309 male 3 30 female 4 40 male 96 42.47787 male 3 30 male 7 9.459459 female 19 8.962264 male 100 47.16981 malo 3 0.983607 female 91 38.7234 female 66 28.08511 male 44 18.7234 female 15 5.084746 male 59 21.22302 male 2 Insert Draw Home Page Layout General 10 ~ A K Arial ||||| HIU III [G YA $ % ) Paste BIUP 020 K J H G E B 13 108 38 39 40 106 372 373 373 371 410 600 285 217 42 43 156 45 46 47 48 49 50 151 52 53 154 155 156 157 58 159 160 17 46 35 15 16 17 50 48 104 41 14 107 18 14 15 110 102 15 192267 170363 654191 901333 333724 295748 869121 966109 153599 181529 677002 681866 342884 842535 798515 127094 118482 649113 840716 829904 473652 B26127 129624 279861 507164 433468 793342 209975 824842 959096 952474 621621 114486 379083 246902 987474 886599 920841 169206 863096 884925 647777 967630 443593 910 1100 1000 1000 970 1070 950 1140 1060 940 960 890 1120 1150 1270 1100 1150 1090 1220 1070 1030 980 930 1030 1100 1100 1070 980 1000 1190 1060 1240 950 1300 860 1010 1180 1040 1010 1000 1030 1100 1240 1110 1070 D F 2.76 non-athlete 0.75 1.95 non-athlete 1 2.92 non-athlete 0.78571 3.41 non-athlete 0.75439 2.73 non-athlete 0.67241 2.54 non-athlete 0.55072 3.06 non-athlete 0.66667 1.93 non-athlete 0.86885 3.23 non-athlet 0.89286 2.54 athlete 0.70909 2.22 non-athlete 0.71429 1.99 non-athlete 0.93478 1.75 non-athlete 0.89831 3.14 non-athlete 0.8254 3.24 non-athlete 0.78873 2 non-athlete 0.83333 2.5 non-athlete 0.94915 1.6 non-athlete 0.91228 3.05 non-athlete 0.84848 2.41 non-athlete 0.7541 2.73 non-athlete 1.01961 2.93 non-athlete 0.63333 2.5 non-athlete 0.82353 2.69 non-athlete 0.98077 2.61 athlete 0.80328 2.94 non-athlete 0.92982 3.44 non-athlete 0.91071 3.12 non-athlete 0.75 3.46 non-athlete 1.12766 3.64 non-athlete 1.01695 2.57 non-athlete 0.65625 3.43 non-athlete 0.85075 2.24 non-athlete 0.86275 2.78 non-athlete 0.66667 2.13 athlete 0.45763 2.69 non-athlete 0.74138 3.29 non-athlete 0.76119 2.31 non-athlete 1 2.31 non-athlete 0.74138 1.88 non-athlete 0.85185 2.47 non-athlete 0.74576 2.66 non-athlete 0.92982 2.77 non-athlett 0.77143 3.77 athlete 0.91379 1 non-athleted 87710 85 22.84946 male 188 50.40215 male 127 34.04826 male 99 26.68464 male 113 27.56098 female 62 10.33333 male 24 8.421053 male 34 15.6682 female 27 17 30769 male 45 17.92829 male 39 39 male 38 18.09524 male 152 46.34146 female 4 40 male 4 40 male 4 40 female 5 50 male 79 52.66667 male 5 50 female 5 50 male 4 2.941176 female 17 5.3125 male 40 14.76015 female 62 20.12987 female 99 32.35294 male 28 9.032258 male 10 5.617978 male 21 9.251101 male 23 12.92135 female 40 22.47191 female 76 29.11877 male 41 13.94558 female 70 33.01887 female 142 54.40613 male 110 40.14598 male 74 28.90625 male 94 36.71875 female 4 40 female 36 18.46154 female 35 17.85714 male 3 30 male 22 9.322034 male 16 27.58621 malo 20 41.66667 female 251 100 210 328 10 10 10 10 150 10 10 136 320 271 308 306 310 178 227 178 178 261 294 212 261 274 256 161 44 43 71 18 50 16 50 17 35 16 115 42 92 94 117 69 16 17 17 18 92 45 14 162 63 164 165 166 167 168 169 170 171 172 173 174 175 258 176 177 178 179 180 181 182 10 195 196 10 236 58 48 10 865023