Using the above data set:

1. Calculate allappropriate summary statistics using Excel.

2. Plot a histogram of weight using Excel.

3. Explain how you arrived at each answer (formulas used, etc.), your interpretation of the results, and your conclusion based on the results.

shoulder.girth chest.girth weight height gender 106.2 89.5 65.6 174 male 110.5 97 71.8 175.3 male 115.1 97.5 80.7 193.5 male 104.5 97 72.6 186.5 male 107.5 97.5 78.8 187.2male 119.8 99.9 74.8 181.5 male 123.5 106.9 86.4 184 male 120.4 102.5 78.4 184.5 male 111 91 62 175 male 119.5 93.5 81.6 184 male 117.1 97.7 76.6 180 male 123.5 99.5 83.6 177.8male 116.5 103 90 192 male 113 99.6 74.6 176 male 107.5 101.5 71 174 male 112 104.1 79.6 184 male 112.2 100 93.8 192.7 male 120 93.8 70 171.5 male 109 98.5 72.4 173 male 118.5 104 85.9 176 male 116 100 78.8 176 male 111 100 77.8 180.5 male 117.7 99 66.2 172.7 male 123.9 101 86.4 176 male 120.6 101.6 81.8 173.5 male 129.5 108.8 89.6 178 male 115 100 82.8 180.3 male 116 88 76.4 180.3 male 107.8 88.7 63.2 164.5 male 100.2 84.5 60.9 173 male 113 93.6 74.8 183.5 male 117.9 105 70 175.5 male 112.5 90.9 72.4 188 male 110.5 91.2 84.1 189.2 male 112 98.4 69. 1 172.8 male 104 85 59.5 170 male 114.8 97.2 67.2 182 male 108 91.5 61.3 170 male 111.2 91.2 68.6 177.8male 118.3 101.1 80.1 184.2 male 115.2 104.3 87.8 186.7 male 129.9 110.8 84.7 171.4 male 112.9 96.3 73.4 172.7 male 112.2 102.7 72.1 175.3 male 117.1 103.9 82.6 180.3 male 118.7 105.6 88.7 182.9 male 109.2 95.8 84.1 188 male 128.1 111.2 94.1 177.2 male 113.3 100 74.9 172.1 male 108.4 91.6 59.1 167 male 118.7 108 75.6 169.5 male 126.3 109.6 86.2 174 male 124.2 105.7 75.3 172.7 male 126.7 109.1 87.1 182.2 male 103.3 88.8 55.2 164.1 male 101.2 86.1 57 163 male 104.3 91.3 61.4 171.5 male113.2 121.9 113.1 103.5 113.9 112.6 110.2 103.7 104 115.2 111.9 127 111.2 122 114.5 109.5 110.3 113.3 103 114.3 105.4 115 119.5 130 113.3 113.2 106.9 113.3 117.3 124.2 123 117.3 113.3 112 113 116 112.3 125 103.3 103.2 113 115 123 120.2 114 102.9 112.5 104.5 111.3 117.2 112.3 104.3 117.7 107.7 125.2 109.1 122.6 117.3 100.6 105.5 97.5 94.4 99.6 93.1 93.6 93.4 92 99.2 97.6 103.3 91.9 105.2 93.3 92.5 92.5 101.6 94.6 92.5 33.2 91 106 115 100 94.7 92.5 96.7 97.4 106.7 106.2 103.6 93.3 37.3 99.3 104.6 36.5 110 93.2 93.4 107.2' 103.3 105.7 33.5 79.3 90.9 90.2 91.6 105.2 97 35.3 99.6 94.3 111.3 94.3 106.1 102 76.3 36.3 72.2 71 .6 34.3 63.2 66.1 72 64.6 74.3 70 101 .6 63.2 79.1 73.9 67.7 63.2 63.9 72 56.3 74.5 90.9 93 30.9 72.7 70.9 72.5 72.5 33.4 75.5 73 70.2 73.4 70.5 63.9 102.3 63.4 65.9 75.7 37.7 36.4 73.2 53.9 72 55.5 53.4 33.2 72.7 64.1 72.3 36.4 33.6 34.1 134.2male 174 male 174 male 177 male 136 male 167 male 171.3male 132 male 167 male 177.3male 164.5male 192 male 175.5male 171 .2male 131 .6male 167.4male 131.1 male 177 male 174.5male 177.5male 170.5male 132.4male 197.1 male 130.1 male 175.5male 130.6male 134.4male 175.5male 130.6male 177 male 177.1 male 131.6male 176.5male 175 male 174 male 165.1 male 177 male 192 male 176.5male 169.4male 132.1 male 179.3male 175.3male 134.9male 177.3male 167.4male 173.1 male 163.9male 157.2male 130.3male 170.2male 177.3male 172.7male 165.1 male 136.7male 165.1 male 174 male 175.3male 109.1 116.7 124.9 113.6 103.3 121.9 117.3 115 134.3 113.3 119.4 117.9 127.3 113.3 122.4 111.5 113.2 115.3 122.5 114.4 112.3 112.2 119.4 103.4 122.4 123.3 113 116.5 120.4 123.1 117.2 113 109.4 105.7 119.7 113 104.3 114.1 119 113.3 113 116 103.3 129.2 109.2 124.3 122.6 122.4 114.9 111.1 126 115.5 124.7 125.3 113.2 124.3 113.3 122.3 94.3 102.9 115.3 105.4 37.1 104.1 95.3 93.6 113.7 100.9 93.5 96.9 110.7 103 109 104.2 100.5 105.7 112.4 96.2 97.5 90.9 103.4 94.3 109.1 115 104.4 100.1 103.4 107.3 101.3 94.5 91.7 95.9 110.5 104 36.3 106.7 102.5 103 95 39.7 111.5 94.1 113.3 106.5 110.4 102.3 93.5 111.6 106.7 110.4 114 101.3 109.6 100.7 104.3 66.3 75.5 93.2 32.7 53 79.5 73.6 71 .3 1 16.4 72.2 33.6 35.5 90.9 35.9 39. 1 75 77.7 36.4 90.9 73.6 76.4 69. 1 34.5 64.5 69. 1 103.6 36.4 30.9 37.7 94.5 30.2 72 71 .4 72.7 34. 1 76.3 63.6 30.9 30.9 35.5 63.6 67.7 66.4 102.3 70.5 95.9 34. 1 37.3 71 .3 65.9 95.9 91 .4 31 .3 96.3 69. 1 32.7 75.5 79.5 135.4male 177.3male 130.3male 130.3male 177.3male 177.3male 177.3male 177.3male 177.3male 163.3male 133 male 193.1 male 175.3male 166.4male 190.5male 166.4male 177.3male 179.7male 172.7male 190.5male 135.4male 163.9male 167.6male 175.3male 170.2male 190.5male 177.3male 190.5male 177.3male 134.2male 176.5male 177.3male 130.3male 171.4male 172.7male 172.7male 177.3male 177.3male 132.9male 170.2male 167.6male 175.3male 165.1 male 135.4male 131.6male 172.7male 190.5male 179.1 male 175.3male 170.2male 193 male 171.4male 177.3male 177.3male 167.6male 167.6male 130.3male 132.9male 116.5 123 117.6 117.5 117.3 114.5 122.9 115.5 116.1 121.6 131.6 124.5 115.6 117 103.6 120.2 116.2 115.4 120 110.3 119.7 123.5 107.3 113.7 120.7 113.7 113 105 110.6 123.1 121 111.7 111 112 115.9 121 123.6 120 123.7 124.5 112.4 112.2 127 115.3 111.5 113.3 113 127 124.4 112.4 125.3 131.7 117.3 107.6 122.4 117 119 123.5 104.2 107.4 101 103 107.2 99 100.3 100.2 99.3 107.5 110.1 107 105.6 103.6 97.1 109.3 103.3 103.7 103.5 97.3 112.7 111.4 95.1 100.2 106.3 109.5 106.3 91.5 104.9 109.6 102.5 101.2 93.7 96 104.2 103 107 101 112.1 103.4 100.3 95.7 103 101 93.6 101.6 99 116.7 105 95.1 106.7 116.6 103.5 90.4 107.5 100.3 104.2 104.9 73.6 91 .3 34.1 35.9 31 .3 32.5 30.5 70 31 .3 34.1 90.5 91 .4 39.1 69.1 73.6 30.5 32.7 36.4 67.7 92.7 93.6 70.9 75 93.2 93.2 " 77.7 61 .4 94.1 75 33.6 35.5 73.9 66.3 37.3 72.3 33.6 75.5 101 .4 91 .1 67.3 77.7 31 .3 75.5 34.5 76.6 102.5 77.3 71 .3 37.9 94.3 70.9 64.5 77.3 72.3 37.3 30 176.5male 136.7male 138 male 138 male 177.3male 174 male 177.3male 171.4male 135.4male 135.4male 138 male 138 male 132.9male 176.5male 175.3male 175.3male 138 male 138 male 175.3male 170.5male 179.1 male 177.3male 175.3male 132.9male 170.3male male 130.3male 177.3male 135.4male 163.9male 135.4male 130.3male 174 male 167.6male 132.9male 160 male 130.3male 167.6male 136.7male 175.3male 175.3male 175.9male 175.3male 179.1 male 131.6male 177.3male 132.9male 177.3male 134.2male 179.1 male 176.5male 138 male 174 male 167.6male 170.2male 167.6male 138 male 174 male 121.4 112.8 82.3 176.5 male 112.3 95.7 73.6 180.3 male 1 13.2 104.9 74.1 167.6male 121.7 109.1 85.9 188 male 1 16.6 105.4 73.2 180.3 male 1 17.8 104.3 76.3 167.6male 118 100.5 65.9 183 male 131.1 111.8 90.9 183 male 121.4 109.5 89.1 179.1 male 1 16.3 101.2 62.3 170.2male 121.8 103.3 82.7 177.8male 1 18.2 101.6 79.1 179.1 male 126.3 103.1 98.2 190.5 male 121 104.6 84.1 177.8male 123.1 104.3 83.2 180.3 male 1 14.9 95.9 83.2 180.3 male 95 83 51.6 161.2 female 99.5 78.5 59 167.5 female 88 75 49.2 159.5 female 97 86.5 63 157 female 103.3 91 53.6 155.8 female 93.5 79.5 59 170 female 93.3 77 47.6 159.1 female 94.5 88 69.8 166 female 98.6 85 66.8 176.2female 1 15.5 98.8 75.2 160.2female 97.9 79 55.2 172.5 female 97.7 77.6 54.2 170.9 female 100.5 85 62.5 172.9 female 88.7 76.7 42 153.4 female 96.6 76.7 50 160 female 92 82 49.8 147.2 female 90 79 49.2 168.2 female 104 89.5 73.2 175 female 90.1 73.5 47.8 157 female 104 90 68.8 167.6female 91 80 50.6 159.5 female 1 11.4 94.5 82.5 175 female 96.2 83.8 57.2 166.8 female 1 17.1 95.2 87.8 176.5 female 101.5 91 72.8 170.2 female 95.1 80 54.5 174 female 97.1 81.7* 173 female 101.4 89.6 67.3 179.9 female 103.7 90.9 67.8 170.5 female 89.2 78.5 47 160 female 86 78 46.2 154.4 female 98.1 80.2 55 1 62 female 114 99 83 176.5 female 95 80 54.4 160 female 87 75.5 45.8 152 female 100.8 82.6 53.6 162.1 female 112.2 94.5 73.2 170 female 98.7 83.9 52.1 160.2 female 100.1 92.8 67.9 161.3 female 100.3 85.3 56.6 166.4 female 100.5 84.4 62.3 168.9 female 101.2 87.6 58.5 163.8 female92.3 95.5 93.7 96.9 91 106.3 99.3 105 106.2 97.7 97.4 96.3 93 94. 5 101 .4 95.1 101.1 97.4 104. 3 94. 5 103. 2 110.3 94.6 96. 6 102.3 96. 9 95. 6 92.4 93. 7 96. 1 100. 1 93.3 92.2 97. 3 90. 5 110. 5 103 109 104.3 109.2 117 93.9 105. 5 99. 4 39. 5 93.5 94.9 96.3 96. 3 102. 5 95.2 103 99. 1 104. 1 99. 5 110. 2 107.1 31 34.1 33.2 33.1 34. 9 31. 2 91. 6 33. 4 37. 6 91.3 37.2 32.2 32.1 32.6 36.5 35.3 34.7 36.3 35. 2 93. 9 34.5 90. 7 97. 4 33. 3 32. 1 92. 2 33. 6 32. 6 79.3 34.3 35.6 79.1 79 96.2 39.3 34.5 33.2 99. 5 76. 1 35.3 32 77.5 35. 7 73. 3 30.2 35. 6 31. 3 34.6 32. 2 34.9 31. 5 39.9 39.3 54.5 50.2 60.3 53.3 56.2 50. 2 72. 9 59.3 61 69.1 55.9 46.5 54.3 54.3 60.7 62 60. 3 52. 7 74.3 62 73.1 54.7 53. 2 75. 7 61.1 55.7 43. 7 52. 3 59.3 62.5 55.7 54.3 45.9 70. 6 67.2 69.4 53.2 64.3 71 .6 52.3 59.3 49 69.2 55.9 63.4 53.2 53.6 45.7 52. 2 43. 6 57. 3 55.6 66. 3 59. 4 1 67.6female 160 fem ale 1 61 .3female 1 67.6female 165.1 female 160 fem ale 170 fem ale 1 57.5female 1 67.6female 1 60.7female 1 63.2female 1 52.4female 1 57.5female 1 63.3female 1 30.3female 1 65.5female 165 fem ale 1 64.5female 156 fem ale 160 fem ale 163 fem ale 1 65.7female 161 female 162 fem ale 166 fem ale 174 fem ale 1 72.7female 1 67.6female 151.1 female 1 64.5female 1 63.5female 152 fem ale 169 fem ale 164 fem ale 1 61 .2female 155 fem ale 170 fem ale 1 76.2female 170 fem ale 1 62.5female 1 70.3female 164.1 female 1 69.5female 1 63.2female 1 54.5female 1 59.3female 1 73.2female 170 fem ale 1 61 .4female 169 fem ale 1 66.2female 1 59.4female 1 62.5female 159 fem ale 1 62.3female 159 fem ale 1 79.3female 1 62.9female 95.7 103.4 94.6 104.5 97.7 96.4 103 103.4 109.5 110.7 102.2 129.5 99.2 104.7 93.9 93.5 102.2 100.2 35.9 99.3 93.3 107.3 90 101.5 105.1 101 91.9 112.1 93.2 102.5 93.4 96.3 103.9 92.7 105 94 101.5 92 103.5 93.3 99.3 100.3 101.5 94.7 103.1 94.5 97.1 93 102.4 109.1 94.7 93.2 101.5 96.6 106.1 100.1 105.3 99.3 30.3 33.4 30.2 39.5 33.7 32.5 35.5 33.3 91 .5 92.2 30.5 103 39.5 34.9 30.3 31 33.7 74.5 31 .9 75.3 72.6 35.5 30.4 93.1 32 39 35.3 35.9 32.5 74.5 39.4 30.3 35.6 33.2 35.5 30.6 31 33.6 79.4 32.9 33.2 73.1 32.4 92.4 36.7 34.5 91.2 31.1 37.6 33.2 53.6 73.2 53.4 69 53.4 56.2 70.6 59.3 72 65.2 56.6 105.2 51 .3 63.4 59 47.6 63 55.2 45 54 50.2 60.2 44.3 53.3 56.4 62 49.2 67.2 53.3 54.4 53 59.3 54.3 43.2 60.5 46.4 64.4 43.3 62.2 55.5 57.3 54.6 59.2 52.7 53.2 64.5 51 .3 56 63.6 63.2 59.5 56.3 " 64.1 50 72.3 55 55.9 60.4 1 61 fem ale 1 51 . 1 fem ale 1 632me ale 1 639me ale 1 732me ale 1 71 .3fem ale 1 73 fem ale 1 643me ale 1 63 fem ale 1 635me ale 1 663me ale 1 727me ale 1 635me ale 1 694me ale 1 673me ale 1 595me ale 1 676me ale 1 61 .2fem ale 1 60 fem ale 1 632me ale 1 622me ale 1 61 3me ale 1 495me ale 1 575me ale 1 632me ale 1 727me ale 1 55 fem ale 1 565me ale 1 64 fem ale 1 609me ale 1 623me ale 1 67 fem ale 1 60 fem ale 1 60 fem ale 1 639me ale 1 532me ale 1 56 fem ale 1 60 fem ale 1 67. 1 fem ale 1 53 fem ale 1 676me ale 1 56 fem ale 1 62. 1 fem ale 1 734me ale 1 593me ale 1 705me ale 1 592me ale 1 575me ale 1 61 3me ale 1 626me ale 1 60 fem ale fem ale 1 65. 1 fem ale 1 626me ale 1 65. 1 fem ale 1 664me ale 1 60 fem ale 1 524me ale 103.9 111 99 102.5 105.6 99.5 106.5 104.1 99.7 106.6 97.2 100.3 100.7 99.1 103.9 109.3 99.5 100.5 97.4 105 102.9 93.9 114.2 95.9 93.7 91.2 105.1 102.3 93.1 101.7 105 96.4 103.5 99.3 37 105.2 102.1 101.3 99.6 99.4 99.4 99 103.2 96.4 101.4 93.2 100.6 103.4 100.3 94.3 103.2 110.7 102.6 93.1 92 93.6 96.1 107.7 33.2 104.2 34.3 34.3 91 90.5 39.6 39.3 33.2 33.5 91 33.2 32.2 93.9 97.9 31 .7 36.1 37.1 76.3 37.9 31 .6 92.3 31 .3 32.2 73.6 94.3 39.5 31 35.4 36.2 35.3 36.1 34.5 72.6 95.3 35.5 35.7 35.4 79.1 34.4 32.9 37.3 35.3 37.3 93.2 34.7 73 90.7 95 33.7 36.6 32.5 31 .4 79.9 91.1 69.1 34.5 55.9 55.5 69.5 76.4 61 .4 65.9 53.6 66.3 56.6 53.6 55.9 59.1 31 .3 70.7 56.3 60 53.2 72.7 54.1 49.1 75.9 55 57.3 55 65.5 65.5 43.6 53.6 63.6 55.2 62.7 56.6 53.9 63.2 73.6 62 63.6 53.2 53.4 55 70.5 54.5 54.5 55.9 59 63.6 54.5 47.3 67.7 30.9 70.5 60.9 63.6 54.5 59.1 70.5 170.2female 162.6female 170.2female 153.3female 172.7female 167.6female 162.6female 167.6female 156.2female 175.2female 172.1 female 162.6female 160 female 165.1 female 132.9female 166.4female 165.1 female 177.3female 165.1 female 175.3female 154.9female 153.3female 172.7female 163.9female 161.3female 167.6female 165.1 female 175.3female 157.5female 163.3female 167.6female 165.1 female 165.1 female 163.9female 162.6female 164.5female 176.5female 163.9female 175.3female 159.4female 160 female 170.2female 162.6female 167.6female 162.6female 160.7female 160 female 157.5female 162.6female 152.4female 170.2female 165.1 female 172.7female 165.1 female 170.2female 170.2female 170.2female 161.3female 95.4 99.3 115.2 96.7 109 95.1 103.4 93.2 99.7 94.4 127.1 94.9 93.9 106.4 102.2 110.3 107.3 95 115.6 99.3 93.1 94.9 100 93.6 107.2 93.3 92.4 93 99.5 92.3 95.9 96.1 93.5 103.3 105 100.2 99.1 107.6 104 103.4 99.3 91.9 107.1 100.5 30. 1 36.4 105.2 91 .1 96.7 30.5 90.4 34. 1 34.2 32.5 106.9 79.9 93 96.3 36.3 95.3 93 36.4 1 09 36.2 35.3 34.2 33.7 36.5 93.2 30.4 36.4 37.6 30.9 32.1 39.3 35.3 39 94.1 90.3 97 95.4 91 .3 37.3 73.1 90.9 97.1 52.7 62.7 36.3 66.4 67.3 63 73.6 62.3 57.7 55.4 1 04.1 55.5 77.3 30.5 64.5 72.3 61 .4 53.2 31 .3 63.6 53.4 54.5 53.6 60 73.6 61 .4 55.5 63.6 60.9 60 46.3 57.3 64.1 63.6 67.3 75.5 63.2 61 .4 76.3 71 .3 55.5 43.6 66.4 67.3 1 67.6 female 1 67.6 female 1 65.1 female 1 62.6 female 1 52.4 female 1 63.9 female 1 70.2 female 1 75.2 female 1 75.2 female 1 60 female 1 65.1 female 1 74 female 1 70.2 female 1 60 female 1 67.6 female 1 67.6 female 1 67.6 female 1 54.9 female 1 62.6 female 1 75.3 female 1 71 .4 female 1 57.5 female 1 65.1 female 1 60 female 1 74 female 1 62.6 female 1 74 female 1 62.6 female 1 61 .3 female 1 56.2 female 1 49.9 female 1 69.5 female 1 60 female 1 75.3 female 1 69.5 female 1 60 female 1 72.7 female 1 62.6 female 1 57.5 female 1 76.5 female 1 64.4 female 1 60.7 female 1 74 female 1 63.3 female Datasets for Statistical Analysis Home Techniques Index Application Index Datasets for Statistical Analysis Back to Datasets home Body dimensions Access data file Keywords: body Categories: biology; multivariate data Description: The data give somebody dimension measurements as well as age, weight, height, and gender on 507 individuals. The 247 men and 260 women were primarily individuals in their twenties and thirties, with a scattering of older men and women, all exercising several hours aweek. There are 507 observations on 15 variables (25 variables in the originoldotoset}. Variables: For a full description, seethe original source. weight Weight (in kg} height H eight (in cm} gender Gender; 1 for males and 0 for females Data Quality: Source: Grete H einz, Louis J. Peterson, Roger W. Johnson, and Carter J. Kerk. Exploring relationships in body dimensions. Journal of Statistics Education, Volume 11, Number 2. Notes: References