Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TAB] Id Age 301 451 501 642 901 1701 1752 1753 1901 1951 1952 2001 2101 2401 3102 3142 3541 3551 4201 4301 4351 5151

TAB] Id Age 301 451 501 642 901 1701 1752 1753 1901 1951 1952 2001 2101 2401 3102 3142 3541 3551 4201 4301 4351 5151 5152 5201 5601 5642 5702 6042 6101 6801 6851 7201 7251 7252 7253 8501 8801 9101 9201 9301 9501 9801 10041 10401 10451 FEV 9 8 7 9 9 8 6 6 8 9 6 8 8 8 8 7 5 6 9 9 5 5 4 7 9 3 9 5 8 9 5 9 8 7 5 8 9 8 8 8 9 8 5 8 5 Hgt 1.708 1.724 1.72 1.558 1.895 2.336 1.919 1.415 1.987 1.942 1.602 1.735 2.193 2.118 2.258 1.932 1.472 1.878 2.352 2.604 1.4 1.256 0.839 2.578 2.988 1.404 2.348 1.755 2.98 2.1 1.282 3 2.673 2.093 1.612 2.175 2.725 2.071 1.547 2.004 3.135 2.42 1.776 1.931 1.343 Sex 57 67.5 54.5 53 57 61 58 56 58.5 60 53 54 58.5 60.5 58 53 50 53 59 61.5 49 52.5 48 62.5 65 51.5 60 52 60 60 49 65.5 60 57.5 52 59 59 55 57 57 60 59 51 57 50 Page PAGE] Smoke 0 0 0 1 1 0 0 0 0 0 0 1 0 1 1 1 1 0 1 1 0 0 0 1 0 1 1 1 0 0 0 1 0 0 0 0 1 1 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 10601 10701 10751 10841 11201 11241 11501 12001 12201 12241 12402 13351 13701 13751 14051 14101 14201 14251 14252 14501 14541 14601 14651 15153 15201 15241 15301 15401 15443 15601 15701 15741 15842 16101 16151 16251 16252 16501 16601 16651 18101 18501 18843 18844 19401 20152 9 7 8 6 8 5 9 9 8 6 9 9 7 4 8 8 8 6 4 8 6 9 7 5 9 8 8 9 9 9 7 5 5 9 6 7 6 8 8 7 8 7 9 5 9 9 2.076 1.624 1.344 1.65 2.732 2.017 2.797 3.556 1.703 1.634 2.57 3.016 2.419 1.569 1.698 2.123 2.481 1.481 1.577 1.94 1.747 2.069 1.631 1.536 2.56 1.962 2.531 2.715 2.457 2.09 1.789 1.858 1.452 3.842 1.719 2.111 1.695 2.211 1.794 1.917 2.144 1.253 2.659 1.58 2.126 3.029 57 54 52.5 55 60.5 54.5 61.5 62 54.5 54 57 62.5 60 50 57.5 60 60 51 49 59 57.5 58 55.5 52 60.5 57 58 60 59 59.5 56 53 51 69 53 57 53 63 54.5 58 63 52 61.5 52.5 62 61.5 Page PAGE] 0 1 0 1 1 1 0 1 1 1 1 0 0 0 0 1 0 0 0 1 1 1 0 0 0 1 0 1 1 1 1 1 1 1 0 0 0 1 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 20801 20841 21552 22201 22901 23101 23441 23442 23641 23653 23801 23802 23841 23902 23941 24401 24843 24851 25001 25052 25201 27001 27401 27952 28452 28501 28551 28801 29001 29101 29151 29401 29443 29601 29701 29741 29901 29954 30001 30043 31001 31501 31551 32501 32542 32742 9 7 8 8 9 9 9 7 8 8 7 9 4 9 6 8 6 7 7 8 7 7 7 7 8 7 5 8 7 9 7 7 6 8 8 8 9 7 8 9 8 8 9 8 6 6 2.964 1.611 2.215 2.388 2.196 1.751 2.165 1.682 1.523 1.292 1.649 2.588 0.796 2.574 1.979 2.354 1.718 1.742 1.603 2.639 1.829 2.084 2.22 1.473 2.341 1.698 1.196 1.872 2.219 2.42 1.827 1.461 1.338 2.09 1.697 1.562 2.04 1.609 2.458 2.65 1.429 1.675 1.947 2.069 1.572 1.348 64.5 57.5 60 60 61 58 61.5 55 55 52 54 63 47 60.5 56 58.5 55 58.5 51 59.5 54 58 58 52.5 60.5 54.5 46.5 56.5 55 57 54.5 54 53 57 59 55 55.5 51.5 61 63.5 57.5 53 56.5 54 52 53 Page PAGE] 1 1 0 0 1 1 1 1 1 0 1 1 1 0 1 1 1 0 0 0 0 1 1 0 0 0 0 0 1 1 0 0 1 1 0 1 0 0 0 1 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 32751 33301 33351 33501 33601 33641 33801 34101 34301 34341 35102 35103 35601 37201 37301 37901 38051 38152 38241 38242 38801 39001 39101 39141 39201 39251 39301 39401 39741 39801 39841 39901 39941 40001 40501 40541 42101 42201 42501 42552 42901 42941 43201 43242 43651 43901 8 9 5 7 9 6 9 9 9 6 8 9 8 8 9 9 9 7 8 6 9 9 9 7 8 5 8 9 6 9 6 8 5 7 7 4 9 8 9 9 9 5 9 7 6 9 2.288 1.773 0.791 1.905 2.463 1.431 2.631 3.114 2.135 1.527 2.293 3.042 2.927 2.665 2.301 2.46 2.592 1.75 1.759 1.536 2.259 2.048 2.571 2.046 1.78 1.552 1.953 2.893 1.713 2.851 1.624 2.631 1.819 1.658 2.158 1.789 3.004 2.503 1.933 2.091 2.316 1.704 1.606 1.165 2.102 2.32 61.5 58.5 52 58 61 51 62 64.5 58.5 52.5 58 66 63.5 64 58.5 64 60.5 55 53 48 58.5 64.5 60.5 56 58.5 54 58 64.5 50.5 60 51.5 59 53 53 53.5 52 64 63 58 58.5 59.5 51 57.5 47 55.5 57 Page PAGE] 0 1 0 1 0 1 0 1 1 1 0 0 1 0 1 1 0 0 1 1 0 0 1 1 0 0 0 1 1 0 1 1 1 1 1 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 44201 44301 44501 44551 44701 45001 45041 45241 45251 45301 45641 45642 45653 46101 46151 46641 46642 47001 47053 47242 47301 47341 47552 48052 48101 48401 48402 48901 49301 49401 49501 49542 49551 49701 49741 49751 50501 50701 50951 51241 51301 51341 51501 51542 52101 53601 9 9 7 5 8 9 7 9 8 9 6 6 8 9 5 6 6 9 7 9 8 5 7 6 9 7 9 9 8 9 7 9 4 9 5 8 9 8 3 9 8 6 9 8 8 7 2.23 1.716 1.79 1.146 2.187 2.717 1.796 1.953 1.335 2.119 1.666 1.826 2.709 2.871 1.092 2.262 2.104 2.166 1.69 2.973 2.145 1.971 2.095 1.697 2.455 1.92 2.164 2.13 2.993 2.529 1.726 2.442 1.102 2.056 1.808 2.305 1.969 1.556 1.072 2.042 1.512 1.423 3.681 1.991 1.897 1.37 61 55.5 53.5 50 61.5 61.5 55 58 56.5 57 52 52.5 62.5 65 50 57.5 56.5 57.5 54 59.5 59.5 58 57 55 60 56.5 60 59 63 59 53 61.5 48 63 55.5 64.5 59 58.5 46 62 53 49.5 68 59.5 55.5 55 Page PAGE] 1 1 1 0 0 1 1 1 0 1 1 1 0 1 0 1 1 0 0 1 0 1 0 0 0 1 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 53651 54201 54701 54751 54941 54952 55645 55652 57651 57901 58341 58601 58602 60051 60251 60801 61101 61601 61801 61901 62301 62351 62641 62702 63102 63201 63941 64101 64151 64152 64201 70001 70401 71101 71241 71401 71444 71851 72001 72051 72052 72501 73001 73151 73342 74201 6 8 9 4 7 8 8 9 6 8 6 8 9 8 7 9 8 7 9 8 9 6 8 9 8 9 9 8 7 5 7 8 9 9 6 8 7 9 7 7 5 9 9 8 8 9 1.338 2.016 2.639 1.389 1.612 2.135 2.681 3.223 1.796 2.01 1.523 1.744 2.485 2.335 1.415 2.076 2.435 1.728 2.85 1.844 1.754 1.343 2.303 2.246 2.476 3.239 2.457 2.382 1.64 1.589 2.056 2.226 1.886 2.833 1.715 2.631 2.55 1.912 1.877 1.935 1.539 2.803 2.923 2.358 2.094 1.855 51.5 56 63 48 56.5 59 60.5 65 55 55 51 52.5 64 59 53.5 60.5 59.5 56.5 63 56.5 61.5 52 57 63.5 63 65 61.5 62 55 51 54 57 56 61.5 53 59 56 59 52.5 52.5 50 59.5 64 61 57.5 60 Page PAGE] 0 1 0 0 1 0 1 0 0 1 0 1 0 0 0 1 1 0 0 0 0 0 1 1 0 1 1 0 0 0 1 1 0 1 1 1 1 0 0 0 0 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 74241 74401 74441 74601 74641 74652 74941 75701 75751 75901 75951 76501 76541 76751 77141 77901 78301 78352 80001 80301 80341 80601 80801 80841 81241 81401 81451 81501 81751 82701 83801 83841 83901 83952 201 202 341 351 401 551 601 641 1751 2041 2042 2142 6 7 5 9 5 7 6 8 7 8 4 8 5 8 7 7 9 9 8 9 6 8 9 4 6 7 9 8 6 8 7 5 8 7 11 10 14 11 11 12 10 11 10 14 13 14 1.535 2.135 1.93 2.182 1.359 2.002 1.699 2.5 2.366 2.069 1.418 2.333 1.514 1.758 2.535 2.564 2.487 1.591 1.624 2.798 1.691 1.999 1.869 1.004 1.427 1.826 2.688 1.657 1.672 2.015 2.371 2.115 2.328 1.495 2.884 2.328 3.381 2.17 3.47 3.058 1.811 2.524 2.642 3.741 4.336 4.842 55 56 51 59.5 50.5 57.5 54 57 58 60 49 57 52 52 59.5 58 64 57 53 62 53 56.5 57 48 49.5 51 59.5 56 54 57.5 55.5 50 60 57 69 64 63 58 66.5 60.5 57 64 61 68.5 69.5 72 Page PAGE] 0 1 1 0 1 0 1 1 0 0 0 0 1 0 1 0 0 0 1 1 1 0 1 1 1 1 0 1 0 0 0 1 0 0 1 1 1 0 1 0 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TAB] 2143 2451 2801 2851 3141 3501 3901 4001 4341 4901 4952 5001 5101 5251 5351 5352 5641 5701 6001 6041 6145 6201 6401 7101 7241 7901 8301 8541 8542 8842 8901 9141 9142 9502 9802 10001 10053 10054 10501 10642 10801 10901 10942 11101 11151 11301 12 12 10 13 10 11 10 11 10 13 14 11 10 11 13 10 10 12 10 10 10 11 11 11 10 11 11 13 13 11 11 14 11 10 10 10 14 13 10 14 10 11 13 12 13 10 4.55 2.841 3.166 3.816 2.561 3.654 2.481 2.665 3.203 3.549 2.236 3.222 3.111 3.49 3.147 2.52 2.292 2.889 2.246 1.937 2.646 2.957 4.007 2.386 3.251 2.762 3.011 4.305 3.906 3.583 3.236 3.436 3.058 3.007 3.489 2.864 3.428 2.819 2.25 4.683 2.352 3.108 3.994 4.393 3.208 2.592 71 63 61.5 63.5 62 65 61 63 66 68 66 72 66 67 64 60.5 63 64 60.5 62 60 64.5 67 61.5 66 60 64 68.5 67 67 66 62.5 61 62 66.5 60 64 62 58 68.5 61.5 64.5 67 68.5 61 65 Page PAGE] 1 0 0 0 1 0 1 0 1 1 0 1 1 0 0 0 1 0 1 1 1 1 1 0 1 0 0 1 1 1 0 1 1 1 1 0 0 0 0 1 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 TAB] 11341 11601 11642 11901 11942 12501 13301 14001 14143 14401 15101 15141 15152 15302 15342 15451 15751 15801 15841 16201 16551 16901 16941 16951 16952 17301 17401 17801 17851 18502 18541 18551 18801 18841 18842 19601 19901 20101 21301 21352 21353 21501 22253 23151 23401 23601 13 11 14 11 13 11 11 10 11 11 10 11 13 12 10 10 14 11 10 11 10 11 13 13 10 11 11 12 10 10 11 10 11 14 13 12 11 11 11 14 12 10 12 11 10 11 3.193 1.694 3.957 2.346 4.789 3.515 2.754 2.72 2.463 2.633 3.048 3.111 3.745 2.384 2.094 3.183 3.074 3.977 3.354 3.411 2.387 3.171 3.887 2.646 2.504 3.587 3.845 2.971 2.891 1.823 2.417 2.175 2.735 4.273 2.976 3.835 4.065 2.318 3.596 3.395 2.751 2.673 2.556 2.542 2.608 2.354 70 60 72 59 69 67.5 65.5 65.5 64.5 62 65.5 67.5 68 63.5 58.5 65.5 65 70.5 63 63.5 66 63 67.5 61.5 60 64.5 68.5 64.5 61 57 62.5 58 62.5 72.5 65.5 69.5 66.5 59 68 67 63 64.5 62 62 66 62 Page PAGE] 1 1 1 0 1 1 0 1 1 0 0 1 0 0 1 0 0 1 1 0 0 0 1 0 0 1 1 1 0 0 1 0 0 1 1 0 1 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 TAB] 23651 23652 23901 24201 24251 24501 24543 24601 24642 24701 24741 24801 25041 25051 25501 25551 25901 27441 27701 27751 27901 27951 28401 29952 29953 30042 30051 30052 30401 31042 31201 31242 31502 31901 32541 32701 32741 33001 33041 33502 33541 33701 34201 34243 35101 35901 13 10 10 11 13 10 11 10 13 11 10 11 11 14 11 13 11 11 10 13 10 13 10 12 10 14 12 10 11 14 12 10 10 10 10 12 13 11 12 11 12 11 11 12 12 13 2.599 1.458 3.795 2.491 3.06 2.545 2.993 3.305 4.756 3.774 2.855 2.988 2.498 3.169 2.887 2.704 3.515 3.425 2.287 2.434 2.365 3.086 2.696 2.868 2.813 4.309 3.255 3.413 4.593 4.111 1.916 1.858 2.975 3.35 2.901 2.241 4.225 3.223 5.224 4.073 4.08 2.606 3.169 4.411 3.791 3.089 62.5 57 68.5 59 61.5 65 66.5 65 68 67 64.5 70 60 64 62.5 61 64 65.5 61 65.4 63.5 67.5 66 62 61.5 69 66 66 69 71 60.5 58 63 69 59.5 64 74 64.5 70 67 64.5 65 62.5 68 68.5 67.5 Page PAGE] 0 0 1 0 0 1 1 0 1 0 1 1 1 0 1 0 0 1 0 0 0 0 1 0 0 1 0 0 1 1 1 1 0 1 1 1 1 0 1 1 1 0 0 1 1 1 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 TAB] 35941 36001 36041 36101 37241 37351 37401 37701 37702 37951 38001 38201 39041 39052 39601 39701 40051 40301 41601 42151 42251 42301 42502 42551 43002 43241 43251 43301 43351 43601 43641 44242 44302 44351 44601 44742 45201 45601 45651 45652 46301 46353 46601 46651 46901 46951 11 12 10 12 13 10 12 10 12 10 11 10 12 14 10 10 12 10 10 13 12 12 11 13 12 10 11 11 13 12 13 13 10 12 12 14 11 10 13 11 11 13 12 10 10 12 2.465 3.343 3.2 2.913 4.877 2.358 3.279 2.581 2.347 2.691 2.827 1.873 3.751 2.538 2.758 3.05 3.079 2.201 1.858 2.216 3.403 3.501 2.578 3.078 3.186 1.665 2.081 2.974 3.297 4.073 4.448 3.984 2.25 2.752 2.304 3.68 3.102 2.862 2.677 3.023 3.681 3.255 3.692 2.356 4.591 3.082 60 68 65 64 73 59 70.5 66 61.5 67 62.5 52.5 72 71 65.5 60 60 60.5 59 68 62 64.5 63 66 67 57 63 62 65 68.5 69 71 58 63.5 66.5 67 64 61 67 67.5 68 66.5 67 60.5 70 63.5 Page PAGE] 1 1 1 1 1 0 1 1 0 0 0 1 1 0 1 0 0 1 1 0 0 0 0 0 0 1 0 0 0 1 1 1 0 0 1 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 1 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 TAB] 47051 47052 47801 47841 48001 48142 48951 49201 49341 49342 49451 49541 50301 50551 50702 50901 51101 51201 51302 51541 51601 51641 52401 52452 52801 53101 53151 53301 54251 54901 54951 55601 55901 55941 56601 56651 56901 57001 57042 57053 57601 58301 58603 59901 59941 60001 13 11 10 11 11 11 11 11 14 12 13 13 10 12 10 10 12 11 12 11 11 12 12 14 11 10 11 12 13 12 11 11 11 14 11 13 12 10 12 13 10 10 10 10 14 12 3.297 3.258 2.216 3.247 4.324 2.362 2.563 3.206 3.585 4.72 3.331 5.083 3.498 2.417 2.364 2.341 2.759 2.953 3.231 3.078 3.369 3.529 2.866 2.891 3.022 3.127 2.866 2.605 3.056 2.569 2.501 3.32 2.123 3.78 3.847 3.785 3.924 2.132 2.752 2.449 3.456 3.073 2.688 3.329 4.271 3.53 65 63 61 65.5 67.5 61 63 63.5 70 71.5 65.5 74 68 61 61 61 61.5 67 63 67.5 70.5 70.5 62 62 61.5 62 60.5 62.5 63 63 62 65.5 65 70 66 63 68 59 68.5 63 63 66 62 68 72.5 64 Page PAGE] 0 0 1 1 1 0 0 1 1 1 0 1 1 0 1 1 0 0 1 1 1 1 0 0 0 1 0 0 0 0 0 1 1 1 1 0 1 1 1 0 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 TAB] 60201 60851 61301 61351 61941 62601 62701 62801 62802 63101 63252 63901 64241 70051 70052 70201 70441 70442 71151 71201 71443 71801 72552 72901 73101 73301 73341 73701 74651 74701 74751 74752 74901 75801 76601 76701 77101 77152 77501 77601 80051 80641 80642 80651 81201 81541 11 11 12 14 14 10 11 11 10 10 12 12 11 12 10 12 13 10 12 10 13 12 10 12 10 11 12 11 12 10 13 12 11 11 11 11 12 14 11 11 12 14 11 13 11 10 2.928 2.689 2.332 2.934 2.276 3.11 2.894 4.637 2.435 2.838 3.035 4.831 2.812 2.714 3.086 3.519 4.232 2.77 3.341 3.09 2.531 2.822 3.038 2.935 2.568 2.387 2.499 4.13 3.001 3.132 3.577 3.222 3.28 2.659 2.822 2.14 4.203 2.997 3.12 2.562 3.082 3.806 3.339 3.152 2.458 2.391 65.5 61.5 57 64 66 64.5 67 72 65 63 62 71 61 65.5 62 65.5 70.5 62 65.5 65 61 69.5 65 65.5 63.5 60.5 65 67 63.5 59.5 63.5 61 66 64 62 60.5 71 64.5 61 62.5 64.5 68 68.5 62 60 59.5 Page PAGE] 1 0 1 0 1 1 1 1 0 0 0 1 1 0 0 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 0 1 1 0 0 1 0 0 0 0 1 1 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 0 0 TAB] 81551 81552 81701 81741 82743 82744 83951 90001 441 4041 4051 6144 6252 6441 7142 8841 10941 15351 15752 20151 21351 22251 22252 24541 24552 24553 25941 30041 30441 30442 33741 34241 37251 37252 37441 37451 39051 40351 44241 47241 48141 48152 48441 52841 52842 55951 13 12 11 13 14 10 11 11 15 15 18 19 19 16 17 15 15 15 15 15 19 18 16 17 16 15 15 15 18 17 15 17 17 16 17 15 15 16 16 15 18 15 16 17 16 16 3.141 2.579 3.104 4.045 4.763 2.1 3.069 2.785 4.284 4.506 2.906 5.102 3.519 3.688 4.429 4.279 4.5 2.635 2.679 2.198 3.345 3.082 3.387 3.082 2.903 3.004 5.793 3.985 4.22 4.724 3.731 3.406 3.5 3.674 5.633 3.122 3.33 2.608 3.645 3.799 4.086 2.887 4.07 3.96 4.299 2.981 61 63 67.5 69 68 58 65 69 70 71 66 72 66 68 70 67.5 70 64 66 62 65.5 64.5 66.5 67 63 64 69 71 68 70.5 67 69 62 67.5 73 64 68.5 62 73.5 66.5 67 63 69.5 70 66 66 Page PAGE] 0 0 0 1 1 1 0 1 1 1 0 1 0 1 1 1 1 0 0 0 0 0 0 1 0 0 1 1 1 1 1 1 0 0 1 0 0 0 1 1 1 0 1 1 1 0 0 0 1 1 1 0 1 0 0 1 0 0 1 1 0 0 0 0 1 1 1 0 0 1 1 1 0 0 0 0 0 1 0 0 0 1 1 1 0 1 1 0 1 0 0 0 TAB] 57052 59944 61951 63241 71141 71142 73041 73042 73751 75852 77151 15 18 15 16 17 16 16 15 18 16 15 2.264 4.404 2.278 4.504 5.638 4.872 4.27 3.727 2.853 2.795 3.211 63 70.5 60 72 70 72 67 68 60 63 66.5 Page PAGE] 0 1 0 1 1 1 1 1 0 0 0 1 1 1 0 0 1 1 1 0 1 0 Use Stata to help you with the problems. Use complete sentences in your summaries and be complete enough that the summaries make sense on their own (e.g., don't just write \"Reject H0\" as your summary). From Pagano text Chapter 17 Problem 5, all parts. For parts d and e, also let us know the value of the test statistic and corresponding degrees of freedom. You might need to calculate the test statistic manually using formulas shown in the slides or in the text. In a study conducted in Italy, 10 patients with hypertriglyceridemia were placed on a low-fat, high carbohydrate diet. Before the start of the diet, cholesterol and triglycerides measurements were recorded for each subject. Patient 1 2 3 4 5 6 7 8 9 10 Cholesterol Level (mmol/l) 5.12 6.18 6.77 6.65 6.36 5.9 5.48 6.02 10.34 8.51 Triglyceride Level (mmol/l) 2.3 2.54 2.95 3.77 4.18 5.31 5.53 8.83 8.48 14.2 (a) Construct a two-way scatter plot for these data. (b) Does there appear to be any evidence of a linear relationship between cholesterol and triglyceride levels prior to the diet? (c) Compute r; the Pearson correlation coefficient. (d) At the 0.05 level of significance, test the null hypothesis that the population correlation p is equal to 0. What do you conclude? (e) Calculate rs the Spearman rank correlation coefficient. (f) How does the value of rs compare to that of r? (g) Using rs, again test the null hypothesis that the population correlation is equal to 0. What do you conclude? Problem 7, all parts. Pay attention to the fact that apgar5 is ordinal in nature ...it's not continuous and the problem even goes so far as to spell this out for you. So you should use this knowledge to decide for yourself whether it's more appropriate to use Pearson's or Spearman's correlation. The dataset lowbwt contains information collected for a sample of 100 low birth weight infants born in two teaching hospitals in Boston, Massachusetts. Measurement of systolic blood pressure are saved in the variable named sbp, and values of the Apgar score recorded five minutes after birth - am index of neonatal asphyxia or oxygen deprivation -- are saved under the name apgar5. The Apgar score is an ordinal random variable that takes values between 0 and 10. (a) Estimate the correlation of the random variables systolic blood pressure and fiveminute Apgar score for this population of low birth weight infants. (b) Does Apgar score tend to increase or decrease as systolic blood pressure increases? (c) Test the null Hypothesis H0: p = 0 Problem 8, all parts. The data file water.dta is on Sakai. Units for fluoride are in ppm (parts per million); caries is a count of the number of decayed, missing, or filled teeth (DMFT) per 100 children. (You have to realize that a given child can have multiple DMFT, which is why these counts can exceed the number of \"trials\" = children.) Supposed you are interested in determining whether a relationship exists between the fluoride content in public water supply and the dental caries experience of children using this water. The file water. Contains data from a study examining 7,257 children in 21 cities from the Flanders region in Belgium The fluoride content of the public water supply in each city, measured in parts per millions (ppm) is saved under the variable name fluoride; the number of dental caries per 100 children examined is saved under the name caries. The total dental caries experience is obtained by summing the number of filled teeth, teeth with untreated dental caries, teeth requiring extraction, and missing teeth. (a) Construct a two-way scatterplot for these data, with fluoride as the x-variable and caries as the y-variable. (b) What is the correlation between the number of dental caries per 100 children and the fluoride content of the water? (c) Calculate the least-squares regression line for these data, with fluoride as the xvariable and caries as the y-variable. Add the line to the scatterplot. Based on the plot, do you think that a straight line is a good fit to this data? (d) Regardless of your answer to part c), use the linear model to test the null hypothesis that fluoride content is not associated with dental caries against a two-sided alternative. Remember to clearly specify the steps of hypothesis testing. (e) For the 21 cities in the study, the highest fluoride content in a given water supply is 2.6 ppm. From this dataset, can you conclude that if the fluoride content were to increase to 4 ppm, that the number of dental caries per 100 children would decrease? Checking in In your very first problem set, you were given some Stata output concerning FEV (in liters), split out according to sex. At that time, the most that was asked of you was to write a solid descriptive paragraph about the characteristics you observed in the sample data, commenting on things like the mean, median, various percentiles, scale/spread, and perhaps the general shape of the distribution of the sample data, taking note of any outliers. That was pretty good, but now your skills have hopefully grown. Please go back and retrieve the fev.xls data file and maybe your original summary, just to benchmark your progress. See if you can answer the following questions, written out and summarized in a few sentences. You've seen examples of these sorts of summary statements though out the class (in lecture slides and in homework solutions) and you've been writing some yourself. At the end, try to string your summary sentences together into one paragraph, as you would for a 'results' section of a manuscript. If a graph (like a scatter plot, dotplot, or boxplot) would help you make your case, then please include it. 1. What sort of association is there (if any) between age and FEV? What about between height and FEV? Please provide some numerical summary measure that quantifies the strength of the association, a test statistic, and p-value to determine statistical significance of the association. Do these associations appear linear? 2. Does average FEV differ significantly between males and females? (Your arsenal of statistical tools includes both parametric and non-parametric ways to answer this question . ..choose the one you feel most appropriate, but explain why you chose that method.) A test statistic, p-value and confidence interval for the difference would be greatly appreciated (if your method of analysis is capable of providing one). 3. Does the proportion of smokers differ between men and women? Also estimate the proportion of boys that smoke and the proportion of girls that smoke, each with separate 95% confidence intervals. Consider estimating a difference between the proportions, or perhaps an odds ratio; include a CI for whichever effect you choose to report. 4. Does average age differ between smokers and non-smokers? (Your arsenal of statistical tools includes both parametric and non-parametric ways to answer this question. ..Choose the one you feel most appropriate, but explain why you chose that method.) Include a test statistic, p-value and confidence interval for the effect (if your method of analysis is capable of providing one). 5. Does average FEV differ significantly between those who smoke and those who don't? Which group is higher, and by how much. Again, you've got some room to choose between parametric and non-parametric methods, but defend your choice, whichever you choose. Are you concerned by your answer to the last part? In particular, does the data suggest that smoking is associated with greater FEV (lung capacity)? Do any of your answers to some earlier parts suggest an alternate explanation for what you observed concerning the smoking / FEV association? r##############| #########w##################w ##4A~########29 May 2013 10:00#fluoride#########################caries################################# %9.2f############################################ %8.0g########################################################################### ###################################Fluoride concentration (ppm)# #! ###}Z#######@#######@################?##Number of DMFT per 100 children#! ###}Z#######@#######@################? ###########*###########=#=7#=#=##L>#L>#>#>,####? ##?#fff?W#?##?/#?##ff?C#ff?#33?#ff&@# r#####d#####0########p####0c`#####~##############F########### ######24 Apr 2013 08:59#sbp#0001#########################sex#toxemia######################tox #em1hemorrhage################grmhem###########################gestage########## ################apgar5###################################0#0 %8.0g############################################ %8.0g############################################ %8.0g############################################ %8.0g############################################ %8.0g############################################ %8.0g########################################################################### ##GENDER###########################YESNO############################YESNO####### ################################################################################ #######Systolic blood pressure (mm Hg)##################################################Gender#c blood pressure (mm Hg)##################################################Toxemia diagnosis for mother#g)##################################################Germinal matrix hemorrhage#r#g)##################################################Gestational age (wks)#hage#r#g)##################################################Apgar score at 5 minutes#e#r#g)#########################################################,B#####A ##@##LB#####A###A##(B######B#######B#####A###A##@B#####A##@##A#####A##### #A#####A##@## B#####A###A##dB#####A##@##B#####A###A##8B#####A##@##

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Robert F Blitzer

7th Edition

013449492X, 9780134453262

More Books

Students also viewed these Mathematics questions