Please help with this, attachement will specify.

Calculate the median hip circumference of all subjects:

Calculate the range of waist circumference (cm) in female subjects(2):

Calculate the median body mass(kg) of female participants(2):

Calculate the variance in stature (cm^2) among male subjects(2):

id sex age (years) Stature (cm) Body mass (kg) waist circumference (cm) 3 female 18.9 170.0 58.7 76.5 4 female 17.8 158.5 50.1 64.7 5 female 17.9 174.5 60.9 83.2 9 female 20.7 163.5 102.5 108.4 10 female 20.9 163.0 63.1 75.8 12 female 20.4 155.0 56.5 75.2 13 female 18.7 158.5 64.4 80.8 14 female 22.3 160.0 69.4 79.3 17 female 21.1 168.5 62.6 76.2 18 female 19.5 165.0 58.5 78.7 19 male 18.2 174.0 83.5 97.8 21 female 19.0 167.5 91.2 109.8 22 female 20.8 155.0 48.1 75.2 27 male 18.8 179.1 75.1 80.7 32 male 18.5 184.0 133.8 125.8 33 male 19.2 180.0 80.1 91.3 34 female 21.5 155.5 64.9 88.8 35 male 18.0 177.5 104.8 107.3 36 female 19.0 164.5 68.1 82.5 38 male 18.6 174.0 111.1 121.2 45 female 18.3 161.0 60.8 75.5 46 male 20.2 164.0 81.0 87.2 49 male 24.0 186.5 93.4 86.3 50 female 28.1 174.0 108.6 94.5 56 male 23.5 189.5 129.3 117.8 57 female 23.3 168.0 98.0 101.3 59 female 17.9 174.0 91.7 98.1 61 female 23.2 162.5 60.7 72.4 62 male 21.7 177.5 68.9 79.6 64 female 22.9 177.5 67.3 73.7 65 female 28.2 172.5 111.7 108.7 66 male 29.1 168.0 67.9 81.4 68 male 29.0 172.0 72.1 85.5 69 female 22.5 169.0 70.3 84.7 72 female 22.7 157.4 55.5 72.1 73 female 23.5 163.5 88.2 105.1 74 male 30.7 173.0 94.2 94.2 75 female 21.7 166.5 103.3 101.5 77 male 21.9 178.0 109.8 114.7 81 female 21.6 168.0 96.6 107.2 82 female 20.3 167.5 62.3 68.7 85 female 22.3 166.2 94.3 105.4 86 female 21.4 176.0 66.4 73.3 89 female 20.3 170.0 62.4 81.2 90 male 21.8 177.5 76.7 86.5 91 female 29.3 174.0 76.7 87.6 95 female 24.5 164.5 76.2 88.8 102 male 103 female 110 male 111 female 112 female 118 female 119 male 123 female 127 female 136 female 140 female 144 female 145 female 149 male 157 female 164 female 166 female 172 female 175 female 177 female 181 male 183 male 184 female 185 male 186 female 187 male 188 female 190 female 192 female 193 female 194 female 195 female 198 male 200 male 202 female 205 female 206 male 207 female 208 female 209 female 210 female 214 female 215 female 219 female 222 female 223 female 224 female 226 male 32.9 32.1 19.6 22.8 19.6 28.1 33.2 21.7 28.5 24.0 18.6 28.0 23.7 23.1 29.7 22.2 23.1 26.2 21.6 25.1 24.0 29.6 18.4 24.6 25.7 25.3 20.1 18.7 23.9 23.1 18.3 18.9 18.0 21.5 19.8 21.1 19.2 18.6 18.8 18.9 20.9 20.8 21.4 18.3 21.8 24.7 22.6 21.5 176.0 165.5 173.5 169.0 160.0 158.0 178.5 171.5 163.5 156.0 177.0 159.2 159.0 167.0 162.5 154.0 157.5 166.5 165.5 164.0 171.0 192.0 158.2 168.5 166.0 176.0 158.0 168.5 163.0 160.0 172.0 160.0 177.5 180.0 161.5 165.0 166.2 167.0 163.0 163.0 162.0 161.0 160.0 162.0 154.5 170.5 164.0 181.5 92.1 85.6 62.4 125.4 60.4 59.4 90.6 69.8 90.3 55.7 73.9 81.3 73.8 57.8 79.4 59.9 59.6 93.9 73.9 128.4 92.6 122.7 59.4 90.2 73.1 58.5 50.7 74.4 64.4 75.7 96.7 73.7 100.9 165.7 57.7 79.7 89.1 65.1 56.4 65.8 53.7 58.6 97.2 76.9 56.7 79.0 94.4 89.1 109.0 91.1 75.8 119.0 75.8 82.2 88.3 81.0 101.2 78.4 94.5 99.5 92.5 70.3 94.7 78.2 82.7 87.3 80.3 136.0 108.4 110.1 68.7 100.7 77.6 68.5 65.3 82.9 73.5 91.5 85.4 86.0 95.9 138.7 68.2 81.1 101.5 75.5 66.8 74.0 64.4 70.6 102.2 81.7 72.0 83.5 87.4 92.7 228 male 229 female 233 female 234 female 235 female 239 female 240 female 242 female 243 female 244 male 245 male 247 female 253 male 254 male 259 female 260 male 261 female 262 female 263 female 266 female 270 male 272 male 273 female 275 male 278 male 279 male 280 female 282 female 283 male 285 male 288 female 289 female 290 female 292 male 294 female 295 female 296 female 299 male 302 male 303 male 308 female 309 male 310 female 312 female 315 female 317 female 321 female 323 male 20.8 18.6 24.8 25.2 28.6 18.3 19.2 18.2 19.0 25.1 23.2 22.0 23.2 24.1 21.3 21.4 18.9 19.2 18.5 19.2 19.1 20.3 19.5 26.0 23.8 28.8 20.6 18.6 24.2 22.1 22.2 21.7 20.5 22.6 26.3 19.0 28.2 18.3 24.3 23.5 21.9 21.5 21.3 20.1 21.2 20.8 23.9 19.4 192.0 173.0 165.5 170.0 167.0 180.5 154.6 171.0 157.0 182.0 183.0 163.0 185.0 176.0 174.0 180.5 170.6 163.0 171.0 158.0 196.0 183.0 154.0 177.0 179.0 172.1 166.5 158.0 174.0 182.0 160.0 166.5 169.0 184.0 167.2 161.0 163.5 161.9 183.9 174.0 154.0 167.0 150.0 151.2 180.0 164.0 161.5 178.0 100.5 94.6 88.5 94.2 120.2 75.3 69.9 56.7 103.3 95.1 99.1 59.4 105.6 89.2 59.6 95.0 79.0 70.5 81.2 70.7 140.0 89.1 61.4 84.7 87.9 98.4 58.7 63.1 77.8 95.5 75.9 80.5 56.7 71.5 79.0 86.0 58.5 57.4 106.5 63.0 73.2 88.5 57.4 48.9 69.4 87.5 70.7 87.9 88.1 86.3 89.2 90.4 123.1 74.7 86.5 72.4 103.2 97.0 100.0 67.4 108.1 97.1 74.5 94.1 84.7 77.7 82.7 79.5 132.7 79.5 78.6 93.8 94.0 108.1 70.5 73.0 92.2 90.5 80.9 80.7 66.7 69.4 84.1 81.0 69.3 70.1 106.3 70.7 83.5 95.7 76.9 62.5 70.8 93.5 80.5 89.9 324 female 326 male 327 male 329 female 331 male 333 female 334 female 335 male 338 female 340 male 342 male 343 female 344 male 345 female 347 female 348 female 350 female 351 female 352 male 354 male 359 female 362 female 363 female 365 female 366 female 367 female 370 male 372 male 374 female 377 female 382 female 384 female 388 female 389 female 390 male 392 female 393 female 394 female 396 female 397 male 403 female 406 male 409 male 410 female 411 female 412 male 414 female 417 female 18.2 19.0 28.1 21.6 26.8 21.4 19.0 24.6 21.1 21.2 22.7 20.5 20.2 19.0 22.2 18.5 21.7 19.9 20.6 20.9 25.4 18.3 18.2 18.6 21.1 20.6 23.1 21.9 21.0 18.6 20.4 18.7 18.3 17.9 20.6 18.1 18.8 18.3 21.1 20.2 18.8 18.9 22.1 18.6 23.5 19.8 18.7 18.2 158.3 164.8 175.6 160.0 170.2 159.0 159.0 184.1 181.2 160.8 174.5 164.5 181.5 160.0 169.5 160.0 172.0 160.0 176.0 171.5 156.0 157.5 162.5 174.0 157.5 176.0 179.5 182.0 168.0 163.5 163.5 163.0 162.0 162.0 189.5 159.0 150.0 174.0 179.0 174.0 154.0 165.0 175.2 164.5 169.5 186.0 166.0 163.5 61.7 57.9 85.4 78.9 79.2 56.2 49.0 81.3 85.0 55.0 90.9 84.1 86.6 57.6 73.9 62.1 66.4 55.3 74.1 111.4 62.8 61.2 59.3 72.4 60.1 74.2 77.2 105.8 60.6 56.6 101.0 76.4 53.8 59.3 79.1 62.6 43.9 69.9 70.2 85.1 58.3 62.3 89.8 57.9 93.4 96.4 65.9 53.1 74.2 66.7 97.2 91.2 88.3 69.8 61.3 83.9 78.4 67.2 80.6 102.3 87.5 71.8 75.6 73.1 70.1 65.2 77.8 113.5 79.6 68.5 71.5 72.6 69.8 74.4 79.7 105.0 68.2 70.3 97.4 79.3 66.5 71.9 76.2 68.3 63.7 71.1 73.2 91.2 70.2 69.7 88.0 65.4 101.7 100.3 72.0 59.7 422 male 423 female 425 female 427 female 430 female 431 female 432 female 433 female 434 male 435 male 436 female 437 female 438 male 439 male 440 female 443 female 444 male 445 male 446 female 447 male 449 male 450 male 451 female 454 male 455 female 457 female 458 male 464 female 468 female 469 female 471 male 482 male 486 female 491 male 494 female 497 female 498 male 500 female 510 male 511 female 515 female 517 female 519 female 521 female 523 female 526 female 527 female 529 female 26.0 18.3 19.6 21.9 20.3 22.5 25.2 19.6 18.3 19.3 21.5 24.5 19.8 18.0 19.9 22.3 20.1 19.3 20.3 23.8 23.4 23.6 30.7 28.6 21.4 19.4 26.5 18.6 30.3 21.8 21.1 28.9 33.3 19.8 29.1 23.8 22.9 22.6 23.3 18.9 20.1 21.5 22.9 21.3 30.4 20.5 20.9 20.9 170.0 156.0 165.0 174.1 161.2 164.5 163.0 159.0 170.2 179.5 165.0 173.0 179.0 180.2 164.5 169.0 176.5 180.5 165.0 178.9 177.0 183.0 163.5 181.0 157.5 162.0 185.5 169.8 164.9 168.3 164.5 161.1 170.5 173.6 162.3 174.3 177.2 167.2 196.1 160.3 164.1 166.5 156.7 159.6 163.0 161.5 162.2 157.3 118.9 63.6 59.8 75.8 63.1 66.4 67.6 51.7 95.8 80.2 67.8 58.5 72.5 66.5 76.6 64.9 93.8 108.2 66.6 74.7 81.0 110.3 63.0 96.6 70.2 62.7 103.2 75.2 131.7 62.1 78.8 76.4 72.7 76.9 110.5 69.1 76.7 82.6 96.1 52.9 62.7 56.6 57.3 101.9 102.8 113.2 59.2 57.5 114.9 70.0 71.8 79.0 69.2 84.1 71.4 64.5 90.6 78.2 73.8 67.9 74.5 67.9 76.2 71.6 94.1 87.6 79.3 88.0 90.4 106.5 75.8 97.4 81.8 66.3 98.9 79.3 121.3 66.1 79.5 91.3 71.5 81.8 108.1 69.3 84.1 77.5 88.2 65.6 65.7 69.9 70.2 97.8 97.5 107.2 73.0 73.2 530 female 531 female 532 female 533 female 534 female 536 female 537 female 538 male 541 female 543 male 545 female 550 male 551 male 552 male 553 female 555 female 556 male 558 male 561 female 562 female 565 female 566 female 568 female 569 female 571 female 573 female 575 male 578 male 582 male 583 female 585 female 587 female 588 female 596 female 597 female 599 female 601 male 602 female 605 female 607 female 612 male 613 female 615 female 618 female 620 female 621 female 622 male 623 male 20.0 19.8 19.5 22.2 22.3 20.3 23.5 26.7 18.2 21.9 18.5 19.8 19.7 18.7 18.0 20.9 20.1 20.2 19.9 25.9 18.3 19.5 20.9 19.2 26.7 23.9 19.3 20.1 21.8 21.8 19.1 20.3 19.4 19.0 26.6 18.5 18.2 24.6 21.5 20.0 18.2 20.3 18.1 19.9 18.1 21.8 21.5 20.1 163.7 166.0 156.4 165.2 155.0 166.5 148.8 176.3 164.5 170.6 154.7 178.6 166.8 173.6 157.6 162.1 179.5 186.1 159.7 155.4 163.3 154.7 159.4 164.8 153.3 156.3 173.1 174.7 171.5 161.1 157.1 163.7 167.2 177.6 156.8 170.4 175.5 155.1 172.3 163.5 184.0 156.6 158.7 165.9 164.4 165.5 185.4 180.9 52.0 91.2 63.6 75.6 55.7 105.7 56.5 73.4 49.3 96.4 50.9 86.3 71.3 69.8 56.0 85.3 62.9 149.9 64.0 40.1 61.0 57.5 80.7 93.3 67.6 61.0 66.2 83.8 134.2 64.6 64.7 56.7 57.3 71.9 96.0 81.3 72.7 59.6 62.1 63.8 75.4 57.4 57.2 67.5 50.9 60.6 90.0 67.9 59.1 88.6 73.2 87.2 67.7 105.1 75.9 82.7 61.6 108.2 69.7 81.3 85.9 81.0 71.2 86.5 70.2 136.2 67.7 58.0 71.5 69.5 91.1 85.0 87.5 78.1 75.5 88.2 117.6 73.5 72.6 69.0 63.8 74.5 101.1 87.3 79.3 77.6 73.0 74.4 76.5 72.2 68.3 76.3 62.5 67.9 94.2 81.8 624 female 625 female 626 male 628 male 630 female 631 female 632 male 633 female 634 female 635 female 637 male 638 male 639 female 641 male 642 female 645 male 651 male 652 male 654 female 655 female 657 female 659 male 660 female 661 female 662 female 667 male 669 female 670 female 677 female 678 male 679 female 680 female 681 male 683 female 686 male 687 male 689 female 690 female 698 female 699 male 702 male 703 female 705 female 708 female 709 male 710 female 712 female 714 female 25.9 22.9 21.2 20.8 18.6 18.9 23.9 24.1 19.8 18.8 22.0 21.9 21.3 19.9 19.3 21.5 19.8 20.4 22.1 22.4 21.3 19.3 18.9 21.9 20.6 26.2 19.9 25.8 18.2 19.7 19.2 18.9 19.4 19.9 21.7 23.0 19.0 19.9 19.6 20.9 18.5 22.0 20.9 26.1 21.1 21.1 22.6 22.7 165.5 168.7 166.6 184.4 155.4 163.3 171.6 158.6 158.0 156.3 179.8 177.0 157.4 179.4 160.7 173.7 192.4 183.0 156.4 169.5 163.5 183.9 165.5 168.1 164.2 174.1 168.4 168.8 154.5 184.3 161.3 161.8 172.7 170.4 190.4 170.0 174.1 165.7 166.6 179.6 168.9 154.5 159.4 164.3 176.5 156.6 161.8 164.5 56.0 70.9 94.3 95.3 54.3 88.5 68.2 74.9 52.6 53.2 75.5 117.0 57.9 79.6 43.4 128.7 84.4 88.4 54.1 63.5 62.2 78.3 108.8 57.8 80.9 73.0 103.3 81.0 76.4 79.2 60.9 113.7 108.6 101.7 103.8 69.6 82.6 57.9 49.9 63.4 87.9 99.5 76.5 78.0 57.6 62.8 109.1 74.9 66.5 73.3 104.2 85.2 72.0 84.4 77.0 81.1 65.9 64.2 74.6 113.6 74.5 87.5 61.1 118.8 92.6 79.8 69.3 71.6 69.4 74.6 104.0 69.0 78.0 81.9 100.2 84.1 87.5 82.0 67.6 98.2 117.5 90.7 93.2 76.1 86.1 65.3 60.3 74.5 93.7 102.4 76.8 84.7 66.2 71.7 102.4 78.3 715 male 719 female 720 female 721 female 722 female 723 female 724 male 725 male 728 female 730 female 731 female 732 male 736 female 737 female 738 female 739 female 741 female 743 male 747 male 748 male 749 female 750 female 751 male 754 male 760 female 762 female 764 female 766 female 767 male 771 male 773 female 774 female 775 female 778 female 781 female 782 female 784 male 786 female 788 female 790 male 792 male 798 female 799 male 802 male 804 female 806 male 807 male 808 female 25.0 21.8 21.5 18.5 21.8 20.5 18.4 18.4 21.0 28.0 20.1 20.9 20.7 21.2 35.0 21.0 19.8 24.3 20.6 23.6 22.1 21.0 20.8 19.4 23.7 19.7 19.5 19.4 21.3 20.9 21.5 19.4 19.5 19.6 18.9 20.4 21.1 21.2 18.7 20.0 19.2 18.2 19.1 18.2 18.7 19.2 19.8 18.7 178.6 164.4 164.7 167.0 157.3 172.0 182.5 187.6 165.0 170.5 152.5 180.5 162.3 159.6 179.5 159.8 160.4 179.2 163.1 173.3 165.9 156.1 165.7 167.2 167.3 159.4 150.0 162.3 177.7 177.7 164.6 162.5 155.3 166.6 163.2 168.4 179.4 173.0 160.5 165.7 179.1 155.6 180.8 177.2 159.0 174.5 185.3 153.6 116.9 78.5 62.6 136.5 46.5 71.3 88.1 89.2 63.7 129.0 52.3 70.6 104.1 52.8 77.7 65.7 52.4 107.8 73.8 95.7 114.7 47.7 63.3 94.8 64.4 68.5 48.1 62.2 88.0 120.7 67.7 58.4 66.3 61.3 77.8 65.5 96.5 60.4 88.3 84.3 72.6 70.6 61.1 68.9 44.9 109.9 79.2 54.0 103.7 74.5 70.5 114.7 57.5 72.4 89.9 87.5 70.9 119.6 70.3 73.6 93.1 66.6 78.8 70.5 59.9 105.5 88.8 103.0 111.5 66.4 76.3 105.8 80.1 83.6 66.5 69.5 95.7 106.0 79.0 66.6 77.8 68.4 74.3 73.8 102.0 62.4 95.9 93.5 74.5 82.5 69.4 79.0 57.3 104.0 85.4 66.3 812 female 815 male 816 male 819 male 821 female 822 female 823 male 825 male 826 female 827 male 829 male 830 female 831 female 832 female 837 male 840 male 842 male 843 female 844 female 846 female 847 male 851 male 852 male 856 male 858 female 862 male 865 female 867 female 868 male 870 male 871 male 873 female 874 female 877 male 878 female 879 male 880 male 885 female 886 female 889 female 891 female 892 female 896 male 901 male 902 male 903 male 904 female 906 male 21.9 18.7 18.7 21.5 17.8 17.9 23.0 24.2 19.8 26.0 21.1 19.1 18.4 24.5 29.6 22.3 20.2 18.8 20.1 22.6 18.3 26.4 20.4 19.9 20.1 21.5 19.2 29.9 20.4 20.8 20.3 22.5 22.2 19.7 21.4 22.1 18.5 24.5 34.7 19.1 31.2 18.2 22.0 23.3 27.3 23.0 19.5 26.9 152.0 182.7 182.6 169.4 157.8 174.0 173.5 171.2 163.7 180.4 171.3 154.1 161.8 160.3 173.4 173.0 171.8 163.5 164.4 155.8 169.4 175.0 178.5 168.2 171.7 178.0 162.8 159.5 176.2 176.7 167.5 176.4 152.0 177.8 170.5 169.8 188.9 160.5 166.1 167.6 165.9 157.4 168.5 170.6 164.1 162.4 165.0 178.5 55.9 66.0 87.6 52.5 58.7 60.9 82.0 138.3 95.0 129.1 80.9 78.2 51.4 104.0 77.7 71.5 63.0 59.1 72.9 73.5 86.8 72.2 109.9 65.1 70.3 110.1 63.2 88.5 70.4 92.9 59.4 121.8 49.7 68.8 67.9 75.6 72.5 76.0 83.9 62.9 82.0 47.8 65.0 88.3 85.8 71.4 61.7 93.2 70.8 69.6 84.5 67.3 68.0 72.1 94.6 140.7 97.2 117.7 79.2 76.9 63.1 114.4 85.8 77.5 72.4 63.4 77.4 84.8 91.8 76.7 104.3 74.4 78.1 105.5 73.3 94.5 74.7 94.0 74.7 104.1 69.1 75.3 65.9 84.3 68.4 89.5 89.8 69.7 78.4 58.1 80.8 101.9 96.6 92.1 71.4 100.7 908 male 913 female 916 female 917 female 918 female 919 female 923 female 924 female 928 female 930 male 932 female 933 female 934 male 935 female 936 male 937 female 938 female 939 female 942 male 944 male 945 male 947 female 950 male 952 female 953 female 956 female 958 female 960 female 964 male 965 female 967 female 969 female 970 male 973 male 976 male 978 male 979 female 980 female 984 male 985 male 986 female 987 male 988 female 989 male 992 female 993 female 994 male 996 male 22.8 24.1 20.1 20.0 26.2 18.5 18.4 20.0 18.8 22.7 29.7 22.2 18.2 19.7 22.3 18.8 23.4 24.9 22.7 20.1 29.9 18.0 18.9 21.9 18.6 23.1 18.2 18.8 24.1 18.4 17.8 18.1 18.7 20.9 28.8 20.8 21.8 20.5 19.1 23.7 25.2 20.4 19.6 21.1 21.4 21.1 19.8 18.9 170.5 168.9 150.0 158.5 154.8 154.7 170.6 165.8 161.5 182.3 159.3 158.3 172.0 156.2 171.4 171.6 160.5 162.3 178.4 158.3 177.5 157.0 178.4 164.7 167.5 156.0 171.0 155.0 180.5 161.8 165.0 167.4 180.5 170.2 166.9 168.8 178.5 168.6 171.4 177.0 160.3 165.8 165.8 178.9 156.6 160.5 181.0 174.8 66.8 101.3 56.5 60.7 114.7 53.1 65.1 81.9 78.7 86.4 87.9 101.8 73.0 58.7 72.5 70.4 107.6 82.6 110.0 73.7 130.1 72.3 86.4 80.5 90.3 74.3 54.4 62.5 113.8 61.7 58.6 68.5 91.6 68.5 77.1 70.0 76.4 60.9 82.1 76.9 57.6 55.7 67.1 88.7 45.5 64.8 91.1 77.4 82.0 100.3 76.7 70.0 100.5 71.1 69.1 80.7 88.9 89.2 94.3 105.9 84.5 71.5 80.5 71.8 117.3 79.9 111.0 91.9 130.8 83.0 80.7 78.0 83.7 83.8 63.9 73.4 111.2 75.3 68.7 77.4 86.8 80.1 94.7 82.9 76.7 70.7 81.5 78.6 67.6 66.7 71.7 90.5 63.3 71.5 95.3 76.3 1000 male 1003 female 1004 male 1008 male 1009 female 1010 female 1014 male 1017 female 1021 male 1022 female 1026 male 1027 male 1030 female 1038 male 1040 male 1041 male 1044 female 1045 female 1046 male 1049 male 1050 female 1051 female 1053 female 1054 female 1055 male 1056 male 1057 male 1061 male 1062 male 1065 female 1069 male 1071 male 1075 female 1078 female 1079 male 1081 male 1082 female 1083 female 1084 female 1086 female 1088 female 1091 female 1094 female 1096 female 1100 male 1101 male 1103 female 1105 male 19.9 22.0 19.2 18.3 19.8 19.0 23.1 28.3 21.6 20.3 21.2 26.0 19.5 20.0 25.1 21.9 19.6 27.4 19.0 27.5 24.0 26.1 21.3 20.9 21.2 21.0 23.5 17.9 20.2 21.2 20.9 21.9 19.4 21.2 21.1 19.7 24.9 19.1 21.0 28.3 30.5 18.1 24.9 19.3 20.8 19.7 20.4 25.7 182.3 156.8 170.5 167.5 162.9 172.5 168.5 170.5 180.5 168.0 183.5 170.8 166.5 157.5 181.4 167.5 154.2 154.0 173.0 173.0 149.5 147.0 167.5 171.5 171.7 173.4 166.0 181.4 175.1 168.5 174.4 179.0 161.5 158.1 172.8 178.8 161.0 174.9 171.0 157.5 173.5 156.7 155.0 172.5 176.5 183.5 164.5 169.3 89.4 72.3 55.1 63.2 62.4 83.5 78.0 76.8 120.5 93.8 89.7 87.3 146.1 57.4 86.5 63.7 56.9 76.6 102.3 79.4 41.1 42.9 64.4 58.3 72.7 62.8 85.0 95.4 62.9 99.2 76.3 82.4 53.3 83.7 85.4 81.1 74.8 78.9 76.3 63.0 63.9 55.9 70.3 87.7 115.8 79.8 51.5 73.8 95.4 82.2 63.5 74.4 72.8 80.7 84.7 72.3 111.0 91.1 85.0 84.7 119.7 80.1 97.2 77.9 69.0 82.5 93.2 84.6 61.3 58.6 72.6 63.8 75.2 75.0 88.0 94.3 81.8 100.5 76.5 90.0 62.5 86.2 92.6 85.5 79.0 71.8 85.5 71.6 71.8 71.7 79.8 82.3 117.2 86.2 64.5 85.0 1108 female 1109 male 1112 female 1113 female 1119 male 1120 female 1123 male 1126 male 1127 male 1128 female 1130 female 1135 female 1136 male 1137 female 1141 female 1142 female 1148 female 1152 male 1153 female 1154 female 1159 female 1162 male 1163 male 1164 male 1165 female 1167 female 1168 male 1174 male 1175 female 1176 female 1180 male 1181 female 1183 male 1184 male 1186 female 1187 female 1189 female 1191 male 1193 male 1195 male 1196 female 1197 female 1200 female 1201 female 1208 male 1211 female 1214 female 1218 female 18.2 22.4 22.0 21.0 21.0 19.4 19.0 18.8 18.1 20.3 19.3 21.4 20.2 18.9 20.0 19.1 21.6 18.5 18.0 18.0 20.7 24.9 29.7 18.5 19.8 18.6 18.4 19.3 18.0 19.3 20.0 21.5 25.1 19.9 18.8 19.5 23.2 25.7 18.0 20.1 18.7 19.8 23.8 18.2 18.0 20.0 21.8 20.8 163.0 168.6 157.2 173.0 179.0 159.1 167.5 182.5 176.0 159.4 157.6 161.5 174.0 157.8 162.5 176.5 155.5 188.5 167.0 158.5 161.0 173.0 170.3 175.5 162.5 168.0 177.0 179.0 155.5 162.6 181.0 158.4 169.8 173.1 173.2 162.6 158.5 182.5 172.5 180.6 149.3 153.0 176.0 149.6 163.7 157.3 161.5 168.9 86.3 68.9 68.8 48.1 79.0 81.7 67.1 91.9 83.0 62.8 79.9 52.6 58.6 57.7 65.4 77.8 49.8 153.3 49.5 47.2 61.6 104.0 94.0 68.9 63.7 63.3 75.7 62.0 63.1 56.6 71.8 50.0 74.5 73.0 57.2 62.2 56.7 76.8 75.7 81.3 62.9 56.1 107.7 42.0 65.8 49.9 49.7 73.6 90.8 74.0 83.8 59.8 80.7 81.2 78.8 97.7 80.5 72.9 91.5 67.5 73.5 72.7 73.3 77.2 65.9 129.4 60.6 64.5 71.4 111.5 98.6 73.6 73.6 72.8 82.3 65.0 72.3 66.9 69.0 63.1 84.0 75.8 67.2 74.2 68.4 77.0 79.6 88.1 76.8 66.3 112.2 60.8 77.7 60.7 60.0 82.6 1220 female 1221 male 1223 male 1225 male 1226 male 1228 female 1229 female 1230 female 1233 female 1235 male 1236 female 1239 female 1240 female 1241 male 1242 female 1246 male 1250 male 1253 female 1255 male 1256 male 1257 male 1264 female 1265 female 1266 female 1268 female 1272 male 1274 male 1280 female 1281 male 1284 male 1289 male 1292 female 1293 male 1294 female 1295 female 1297 female 1299 female 1300 female 1302 male 1310 female 1312 female 1314 male 1315 female 1316 female 1321 male 1325 female 1326 male 1327 male 23.2 20.8 19.6 29.0 25.3 19.9 18.1 18.0 18.7 21.4 20.2 19.5 19.3 19.9 18.3 18.9 24.2 18.6 18.4 22.6 27.8 19.0 20.7 20.0 19.1 22.5 22.7 21.6 18.4 18.9 22.6 21.1 21.5 19.4 23.6 23.5 20.0 20.2 19.8 23.7 21.7 19.3 18.7 23.7 21.7 21.6 19.3 25.0 164.2 178.5 181.7 177.0 175.4 165.3 165.0 160.0 164.0 185.0 173.4 161.0 165.7 176.5 160.5 172.4 173.5 144.7 161.8 172.4 173.4 159.2 172.3 156.9 167.5 178.6 177.5 152.0 171.1 174.0 171.9 175.4 175.4 160.5 154.0 164.2 155.9 164.1 174.1 167.2 155.4 178.6 146.1 157.2 176.0 168.9 181.0 162.3 56.6 152.9 93.2 94.0 84.0 106.4 68.0 123.3 83.8 95.9 85.0 81.1 61.2 91.2 62.2 69.5 86.5 47.1 60.4 74.8 109.7 61.4 146.4 69.0 101.8 110.1 60.3 53.8 56.9 69.8 65.5 61.2 84.6 58.2 52.3 80.2 66.7 55.2 65.5 105.8 67.5 86.0 60.6 71.2 90.1 92.0 96.4 52.7 60.5 129.8 83.5 102.6 80.2 100.1 72.8 105.3 87.6 83.9 80.3 80.0 72.7 92.6 67.3 76.6 83.5 67.2 68.7 80.3 114.7 73.5 123.0 82.1 108.0 104.2 72.0 64.5 69.9 80.0 75.5 68.4 84.2 68.1 63.4 86.7 75.8 66.5 73.1 111.9 79.3 82.1 74.4 77.2 84.2 93.9 87.7 67.5 1328 female 1329 male 1335 male 1339 female 1340 male 1343 male 1344 female 1345 female 1347 female 1349 male 1351 male 1354 male 1355 male 1360 female 1361 female 1364 female 1367 male 1369 male 1371 male 1374 female 1377 male 1378 female 1380 male 1384 female 1385 female 1390 female 1391 female 1394 male 1400 male 1402 female 1405 female 1406 female 1407 female 1408 female 1410 male 1411 female 1412 female 1413 female 1414 female 1415 male 1418 female 1420 male 1421 female 1423 female 1425 female 1426 female 1427 male 1428 male 20.8 28.3 18.4 19.8 20.6 18.3 19.4 33.0 19.4 20.2 21.9 26.1 35.6 20.9 18.8 20.7 19.1 20.5 20.7 18.3 19.7 18.0 18.7 18.8 20.8 17.8 32.8 21.5 24.3 19.0 19.4 19.6 18.0 19.9 18.6 24.7 21.3 21.8 22.6 22.9 19.0 18.2 21.0 18.5 18.7 18.6 19.3 18.7 168.7 182.4 175.0 159.6 177.2 174.0 156.4 158.0 172.5 177.0 186.9 184.5 165.7 167.4 166.8 155.4 166.6 172.0 175.2 163.4 172.7 155.2 179.5 164.9 169.9 161.2 158.7 183.0 174.0 164.8 171.5 165.1 164.3 155.1 175.2 161.7 160.1 171.3 154.4 181.1 167.9 172.8 155.0 165.9 160.1 173.5 168.4 168.0 57.8 100.4 74.2 49.9 70.9 81.9 66.5 68.4 70.8 80.3 96.3 155.7 84.1 60.6 69.4 52.8 64.0 65.0 73.7 64.1 53.1 92.0 69.3 61.4 71.8 79.0 120.6 84.7 78.9 80.2 59.8 56.1 65.3 54.2 75.9 62.6 47.4 58.4 52.9 86.7 89.5 98.9 77.4 56.2 62.7 81.4 57.7 65.7 65.6 101.2 77.3 66.6 71.8 78.8 76.8 82.4 72.3 75.8 93.7 125.9 95.1 67.9 76.3 64.5 78.7 68.9 78.3 69.5 69.5 96.1 73.6 65.5 68.8 85.3 125.4 80.7 87.4 79.2 66.0 63.4 74.2 65.3 80.7 74.9 57.5 67.5 62.9 79.2 98.5 98.8 82.7 65.2 78.4 86.2 69.6 71.1 1429 male 1433 male 1435 female 1436 male 1438 female 1440 male 1441 female 1443 female 1444 female 1446 male 1449 male 1454 female 1457 female 1460 female 1462 female 1463 female 1465 female 1467 female 1468 female 1469 male 1470 male 1472 female 1476 male 1478 male 1479 male 1483 male 1485 male 1486 male 1499 male 1501 female 1502 female 1504 female 1505 female 1508 female 1509 female 1510 female 1512 male 1513 male 1514 female 1515 female 1516 female 1520 female 1524 female 1525 female 1527 female 1528 female 1530 male 1535 male 23.5 19.6 22.4 23.1 21.8 20.1 20.3 23.1 20.5 20.5 20.3 19.1 20.4 21.7 18.9 25.9 18.7 30.9 19.9 18.7 30.7 21.2 21.0 18.9 25.5 23.8 23.6 25.0 21.1 22.5 18.8 21.8 20.8 32.3 19.8 21.3 22.7 24.7 22.3 19.0 19.7 34.7 18.1 21.4 18.3 18.4 20.9 17.9 171.0 180.8 162.1 170.2 161.2 171.7 169.7 166.1 166.0 183.7 179.4 164.0 160.0 165.4 159.4 155.7 172.1 170.0 165.0 182.8 171.3 169.2 181.3 176.0 183.6 180.3 188.0 163.6 175.3 164.2 157.5 161.6 153.0 158.5 159.9 151.7 174.6 184.8 162.7 164.7 179.9 164.9 168.0 161.6 161.5 155.7 176.6 174.2 102.2 93.5 76.9 92.2 63.0 85.3 93.8 65.1 48.6 89.6 82.9 56.4 50.2 62.8 90.4 67.7 57.3 54.7 58.3 74.1 93.1 76.8 65.0 77.7 106.3 112.8 117.5 70.5 92.7 65.7 62.0 57.7 69.4 54.3 56.2 44.2 103.4 97.7 53.4 55.7 102.2 61.1 58.9 86.2 105.7 51.2 68.8 66.7 100.0 90.6 87.3 96.0 70.5 84.6 91.6 74.8 59.1 82.4 91.5 74.1 68.8 73.8 91.0 84.7 69.1 64.2 70.0 71.9 95.4 83.5 74.9 78.8 96.4 101.7 108.2 86.6 89.8 77.9 71.8 71.2 76.6 79.0 63.1 61.2 108.7 92.9 67.4 66.0 96.7 77.0 66.8 91.4 101.8 64.2 72.5 72.5 1538 male 1539 female 1540 female 1541 female 1542 female 1547 male 1548 female 1549 male 1558 female 1560 male 1561 female 1562 female 1563 female 1565 male 1567 female 1569 female 1570 male 1572 male 1575 female 1576 female 1579 male 1580 female 1588 female 1593 male 1594 female 1596 male 1598 female 1600 female 1603 female 1604 female 1605 female 1609 female 1611 male 1612 male 1613 female 1614 male 1616 male 1617 female 1619 male 1621 female 1623 female 1626 male 1627 female 1629 male 1630 female 1632 female 1633 female 1635 male 22.7 20.1 20.8 18.2 18.8 20.0 22.6 20.6 18.1 20.6 19.1 19.4 21.5 23.0 19.8 19.9 19.5 18.6 19.9 19.5 18.7 19.6 18.0 19.6 22.1 19.8 29.3 18.6 20.2 17.7 24.9 19.7 25.4 29.9 18.7 18.2 18.2 18.6 35.1 19.0 28.5 20.9 21.0 25.7 19.1 19.8 17.9 19.2 177.2 157.7 163.4 156.9 172.0 189.7 158.6 174.4 163.1 168.5 158.5 168.4 144.7 177.8 170.0 159.0 178.1 171.5 157.5 150.7 167.6 160.3 163.0 166.6 162.9 192.6 170.1 165.6 151.9 166.2 168.7 154.8 172.3 176.7 170.7 166.7 167.8 149.4 175.6 167.5 163.5 183.5 170.0 177.0 161.8 162.5 167.7 174.5 115.4 55.3 91.4 50.8 60.8 84.6 59.1 79.4 55.2 81.6 63.5 65.3 59.7 84.0 113.0 103.0 76.9 69.5 54.2 78.5 81.0 69.8 67.4 74.8 82.6 100.6 79.2 81.1 49.8 76.5 87.2 74.8 80.4 83.4 128.7 69.1 75.4 57.7 89.3 50.2 74.8 82.7 67.7 62.4 55.0 62.0 70.8 88.6 115.8 68.3 98.8 62.4 70.7 81.5 78.8 78.8 71.9 91.0 72.2 71.8 73.3 92.7 113.6 113.4 75.8 77.3 67.5 101.3 89.3 73.8 75.7 77.6 81.8 87.1 72.1 85.7 68.2 84.5 83.9 86.6 90.9 88.9 111.9 82.5 82.8 72.7 92.2 66.9 84.6 76.7 71.6 75.2 65.9 69.3 75.7 87.3 1637 male 1638 female 1642 male 1645 female 1647 female 1648 female 1649 male 29.3 22.6 18.6 21.5 26.6 24.0 20.5 182.1 165.7 166.8 166.9 168.5 149.2 168.2 97.0 75.9 54.6 54.9 103.7 48.3 70.8 94.5 77.5 66.1 66.7 100.0 63.4 85.6 hip circumference (cm) 95.5 91.8 97.0 124.4 106.7 97.5 100.3 102.7 99.8 98.2 111.3 112.7 87.8 98.7 130.2 101.2 102.4 120.3 99.1 126.0 97.9 101.5 105.5 136.2 123.0 130.3 115.2 100.5 99.1 94.5 151.2 92.9 98.5 98.9 97.0 114.0 106.5 123.3 118.7 146.3 91.5 118.2 99.8 105.3 102.4 108.9 108.9 111.7 117.7 91.8 133.7 99.8 94.3 102.9 104.5 119.1 95.7 101.8 114.4 112.2 89.8 109.2 97.2 98.2 126.2 109.0 138.0 110.8 115.9 97.1 111.1 106.1 88.3 89.7 104.1 100.3 107.5 117.4 106.8 105.8 135.4 90.4 116.4 103.7 98.7 88.8 99.1 93.9 95.3 124.6 111.4 95.3 114.0 123.5 103.6 114.1 111.2 118.7 127.6 141.3 102.0 107.9 95.0 134.3 108.4 114.8 96.5 118.6 108.3 95.5 108.6 104.1 106.5 111.6 109.4 124.3 105.2 100.1 104.5 107.8 118.5 93.1 102.7 101.3 110.5 114.8 109.6 98.0 92.5 103.3 119.1 102.1 91.1 117.4 93.4 108.0 107.3 98.2 89.6 97.7 116.4 105.3 102.8 102.7 86.7 106.3 112.3 95.0 95.7 89.8 102.7 107.4 82.3 106.9 114.9 105.5 95.2 100.9 99.3 101.7 94.2 97.3 117.7 102.3 98.8 94.3 104.4 102.5 103.4 95.4 115.3 96.8 95.3 119.1 106.7 92.6 93.2 96.5 93.9 81.3 100.1 101.2 107.1 97.0 87.4 105.2 95.2 119.2 109.4 101.1 93.4 130.6 96.2 96.2 103.5 98.9 98.8 107.1 84.1 107.7 101.8 99.3 91.4 98.0 93.5 103.9 94.3 109.2 124.6 99.6 99.8 99.7 116.0 102.1 107.9 103.2 97.9 114.7 107.8 135.8 96.1 102.6 101.9 110.4 99.3 136.8 99.2 97.6 109.0 106.2 88.2 100.8 89.3 97.5 128.0 126.2 130.7 98.7 91.9 88.5 118.8 100.7 108.4 95.2 128.1 98.3 104.1 86.7 114.2 90.5 103.5 93.8 99.6 98.0 116.9 90.4 134.8 97.4 81.2 96.7 97.5 112.1 123.7 103.8 98.2 90.7 109.3 134.6 102.0 102.3 92.7 90.8 103.6 124.0 110.5 93.4 95.3 98.4 96.7 94.1 94.0 97.3 98.2 89.4 98.1 107.8 92.8 88.1 105.5 116.9 109.2 94.5 123.5 91.2 107.9 90.1 91.5 91.5 115.6 93.8 108.8 83.2 127.7 105.9 100.1 93.9 103.0 93.4 94.5 128.5 96.4 111.0 98.6 118.8 103.6 111.5 102.6 101.4 133.1 116.6 122.3 115.3 87.2 107.6 95.8 88.9 88.6 110.5 132.2 115.7 108.3 85.5 96.8 124.0 102.0 118.2 116.5 97.5 144.8 88.0 106.8 113.1 108.6 97.9 141.9 91.1 90.8 129.6 91.7 101.7 102.7 88.1 120.7 97.4 111.3 128.7 92.2 95.0 112.3 100.6 105.8 90.7 98.8 110.9 123.2 100.8 96.7 103.3 92.6 117.8 97.1 112.5 94.1 112.5 101.8 97.1 101.9 86.3 92.3 80.4 109.2 103.6 96.4 94.1 91.9 100.3 85.9 94.3 95.4 103.3 149.4 116.7 129.5 98.9 117.9 88.5 127.9 101.0 97.5 89.5 94.5 107.4 110.0 106.6 90.2 120.5 92.5 104.7 113.2 95.5 117.3 91.8 109.9 92.4 133.4 86.6 89.9 106.2 106.6 95.5 107.3 109.7 95.0 116.9 88.4 98.3 106.3 104.5 97.4 97.1 112.6 95.2 124.2 92.9 93.3 146.4 93.3 98.0 111.0 108.8 106.8 115.6 126.0 94.9 98.4 90.7 102.2 129.9 114.4 124.3 97.3 127.9 99.9 101.5 103.5 112.5 107.8 90.7 99.4 114.8 96.2 95.5 101.7 106.1 90.1 99.4 95.0 101.6 100.6 102.4 93.9 96.8 85.1 89.9 105.5 85.3 98.1 103.6 93.3 106.6 101.1 84.8 89.5 95.0 105.2 96.7 106.8 116.5 114.2 102.4 102.7 146.8 90.3 105.6 91.7 96.4 111.7 109.3 99.3 83.4 78.8 96.2 92.1 97.1 90.0 100.7 105.6 95.8 122.8 96.8 99.7 90.3 120.6 102.6 99.8 102.6 109.5 99.7 94.6 97.2 93.2 103.5 99.7 116.8 96.3 88.0 97.3 110.4 97.1 99.6 83.2 97.5 107.8 92.6 113.6 93.7 101.7 111.5 88.0 87.7 100.9 98.1 103.6 90.2 134.2 84.9 87.9 98.9 116.2 107.3 90.0 99.7 74.1 93.5 88.7 92.5 95.2 91.2 88.6 95.7 94.7 94.6 98.8 95.5 96.3 99.4 99.9 100.7 93.3 118.5 84.9 93.0 91.4 86.6 103.9 92.5 135.3 97.5 112.5 99.5 127.9 99.5 135.2 113.5 99.4 106.1 102.6 92.3 107.0 89.0 92.4 99.6 88.5 86.5 95.3 113.4 94.8 142.5 104.0 123.0 113.9 86.0 95.5 87.2 96.8 94.8 91.3 100.0 91.1 94.6 112.7 96.3 92.6 94.3 122.7 99.5 99.8 102.0 109.0 102.0 117.5 105.0 80.5 90.5 109.9 93.2 85.0 91.4 96.5 101.4 106.8 106.0 100.9 110.9 138.8 104.3 96.6 107.5 96.0 91.3 89.1 93.4 101.4 89.9 119.5 92.0 94.2 103.2 111.2 141.8 102.9 99.6 113.1 94.3 87.2 93.8 93.7 98.8 97.1 84.5 94.0 88.6 103.2 121.1 118.6 113.0 96.4 95.3 108.3 86.8 87.9 117.4 104.0 101.5 108.4 95.0 106.2 111.6 101.1 89.8 104.9 103.5 90.4 88.2 96.4 117.2 104.8 93.2 90.3 96.6 92.1 105.2 108.3 95.1 95.3 114.3 121.2 118.2 99.3 100.0 103.8 96.0 93.3 109.3 91.4 98.5 84.4 117.4 109.0 89.5 92.7 115.3 96.1 97.5 110.5 129.2 91.9 89.7 92.8 119.2 95.7 113.7 88.5 95.7 102.9 97.9 96.2 93.0 102.4 99.2 102.1 100.4 104.2 125.6 121.6 96.3 93.6 97.6 113.0 102.6 103.9 103.3 101.4 109.7 113.9 108.2 109.0 94.9 100.7 112.1 112.2 104.3 100.6 135.1 97.5 102.5 97.5 103.1 88.6 107.8 100.2 103.8 92.6 96.0 102.1 101.6 98.0 111.1 113.2 84.4 93.2 128.1 92.6 96.5 llDIMIESTIILII'I 5 Download the Excel spreadsheet AnthropometrLKlNAlS'i D.xlsx and determine the following statistics. Provide the number cf significant digits shown in parentheses. For example. {2] indicates two digits after the decimalI e.g., ll-JD. lGal culete the median hip circumference {cm} of all subjects {2} ll'JIMESTIliiIlI 6 Download the Excel spreadsheet AnthropometrLKINAlS'i Ilidsx and determine the following statistics. Provide the number of significant digits shown in parentheses. For example. {2] indicates two digits after the decimal, e.g., 34.10. Gal culete the range of waist circumference {cm} in female subjects l2] Download the Excel spreadsheet AnthropometrLKI N431 D.xisx and determine the feliewing statistics. Provide the number of significant digits shown in parentheses. For example. {2} indicates two digits atter the decimal, e.g., 84.1 D. lIiiait'mlate the median headyr mass {kg} of fern aie participants {2] Download the Excel spreadsheet AnthropometrLKlmsmxisx and determine the following statistics. Prrwide the number of sig'iificant digits shown in parentheses. For example. {2} indicates two digits alter the decimal, e.g.. MAD. Calculate the variance in stature [cm2] among male subjects [2} : QUESTION 9 Generate the frequency distribution for FEMALE STATUFlE measurements in AnthropometrLKlM-mxlsx using the class limits below. a to 15cc: |:| 150.1 to 1501}: :l 15m to was: |:| 1?0.1 to 130.0: |:| 1QD.'1 and up: \f