A Math Graph Project

Anonymous
timer Asked: Feb 27th, 2015

Question Description

Serious Inquiries Only! Please note budget range

If you can't complete this assignment my the time frame..Please do not bid..

First question:
For a vertical column/bar graph, the vertical scale will be the average value of the variable you are graphing. That means the height of the bar is the average for the variable you are given for men and the average for that variable for women for each age bracket that you break your data down into.
  The horizontal axis lists the age categories that you use to classify the data. In other words, you put your data into a grouped frequency distribution and the age groups are your classes. However, instead of frequency for each class you have an average for men and an average for women in that class.

  Your final graph should be two bars for each class. One bar represents the average of the variable for women in that age group and the second bar represents the average of the variable for men in that age group.
  Your overall graph should allow you to see trends for men and women separately for your category as age increases. Your graph should also allow you to compare men and women for your variable for each age group you broke your data into. You should not have a single bar for every data point.

Second question:
  Forget about men and women, this is a new problem. Take the data for your variable and put all men and women together in a single set of data for that variable. Now, build a frequency distribution for that variable and then build a pie chart to represent the number of data points in each class that you broke the data into. 
  Your final pie chart should clearly show that the larger slices represent the most common group within your data set and the smaller slices represent the more rare values in your data set. You should not have a single slice for each data point.
  *hint – If you are not familiar with Excel, you might Google something such as “How do I build a pie chart in excel?”

Third question:
You should have a list of all of the central tendency values for women and all the central tendency values for men as well as all the dispersion values for women and all the dispersion values for men. Then, you should have a sentence, paragraph, page… whatever it takes to compare the two groups using the values you came up with. For example, are men higher/lower/same as women? Use your results to support this conclusion.

Data set 1 men-1.xlsx 

Data set 1 women.xlsx 

Age 58 22 32 31 28 46 41 56 20 54 17 73 52 25 29 17 41 52 32 20 20 29 18 26 33 55 53 28 28 37 40 33 26 53 36 34 42 18 44 20 height weight waist pulse 70,8 169,1 90,6 66,2 144,2 78,1 71,7 179,3 96,5 68,7 175,8 87,7 67,6 152,6 87,1 69,2 166,8 92,4 66,5 135 78,8 67,2 201,5 103,3 68,3 175,2 89,1 65,6 139 82,5 63 156,3 86,7 68,3 186,6 103,3 73,1 191,1 91,8 67,6 151,3 75,6 68 209,4 105,5 71 237,1 108,7 61,3 176,7 104 76,2 220,6 103 66,3 166,1 91,3 69,7 137,4 75,2 65,4 164,2 87,7 70 162,4 77 62,9 151,8 85 68,5 144,1 79,6 68,3 204,6 103,8 69,4 193,8 103 69,2 172,9 97,1 68 161,9 86,9 71,9 174,8 88 66,1 169,8 91,5 72,4 213,3 102,9 73 198 93,1 68 173,3 98,9 68,7 214,5 107,5 70,3 137,1 81,6 63,7 119,5 75,7 71,1 189,1 95 65,6 164,7 91,1 68,3 170,1 94,9 66,3 151 79,9 68 64 88 72 64 72 60 88 76 60 96 72 56 64 60 64 84 76 84 88 72 56 68 64 60 68 60 60 56 84 72 84 88 56 64 56 56 60 64 72 systolic diastolic CholestoralBMI 125 78 522 23,8 107 54 127 23,2 126 81 740 24,6 110 68 49 26,2 110 66 230 23,5 107 83 316 24,5 113 71 590 21,5 126 72 466 31,4 137 85 121 26,4 110 71 578 22,7 109 65 78 27,8 153 87 265 28,1 112 77 250 25,2 119 81 265 23,3 113 82 273 31,9 125 76 272 33,1 131 80 972 33,2 121 75 75 26,7 132 81 138 26,6 112 44 139 19,9 121 65 638 27,1 116 64 613 23,4 95 58 762 27 110 70 303 21,6 110 66 690 30,9 125 82 31 28,3 124 79 189 25,5 131 69 957 24,6 109 64 339 23,8 112 79 416 27,4 127 72 120 28,7 132 74 702 26,2 116 81 1252 26,4 125 84 288 32,1 112 77 176 19,6 125 77 277 20,7 120 83 649 26,3 118 68 113 26,9 115 75 656 25,6 115 65 172 24,2 Leg elbow 42,5 40,2 44,4 42,8 40 47,3 43,4 40,1 42,1 36 44,2 36,7 48,4 41 39,8 45,2 40,2 46,2 39 44,8 40,9 43,1 38 41 46 41,4 42,7 40,5 44,2 41,8 47,2 48,2 42,9 42,8 40,8 42,6 44,9 41,1 44,5 44 wrist 7,7 7,6 7,3 7,5 7,1 7,1 6,5 7,5 7,5 6,9 7,1 8,1 8 7 6,9 8,3 6,7 7,9 7,5 6,9 7 7,5 7,4 6,8 7,4 7,2 6,6 7,3 7,8 7 7,5 7,8 6,7 8,2 7,1 6,6 7,4 7 7,3 7,1 arm 6,4 6,2 5,8 5,9 6 5,8 5,2 5,6 5,5 5,5 5,3 6,7 5,2 5,7 6 6,6 5,7 6 5,7 5,6 5,6 5,2 5,8 5,7 6,1 6 5,9 5,7 6 6,1 5,9 6 5,8 5,9 5,3 5,3 6 6,1 5,8 5,4 31,9 31 32,7 33,4 30,1 30,5 27,6 38 32 29,3 31,7 30,7 34,7 30,6 34,2 41,1 33,1 32,2 31,2 25,9 33,7 30,3 32,8 31 36,2 33,6 31,9 32,9 30,9 34 34,8 33,6 31,3 37,6 27,9 26,9 36,9 34,5 32,1 30,7
Age 17 32 25 55 27 29 25 12 41 32 31 19 19 23 40 23 27 45 41 56 22 57 24 37 59 40 45 52 31 32 23 23 47 36 34 37 18 29 48 16 height weight waist pulse systolic diastolic CholestoralBMI 64.3 114.8 67.2 76 104 61 264 19.6 66.4 149.3 82.5 72 99 64 181 23.8 62.3 107.8 66.7 88 102 65 267 19.6 62.3 160.1 93 60 114 76 384 29.1 59.6 127.1 82.6 72 94 58 98 25.2 63.6 123.1 75.4 68 101 66 62 21.4 59.8 111.7 73.6 80 108 61 126 22 63.3 156.3 81.4 64 104 41 89 27.5 67.9 218.8 99.4 68 123 72 531 33.5 61.4 110.2 67.7 68 93 61 130 20.6 66.7 188.3 100.7 80 89 56 175 29.9 64.8 105.4 72.9 76 112 62 44 17.7 63.1 136.1 85 68 107 48 8 24 66.7 182.4 85.7 72 116 62 112 28.9 66.8 238.4 126 96 181 102 462 37.7 64.7 108.8 74.5 72 98 61 62 18.3 65.1 119 74.5 68 100 53 98 19.8 61.9 161.9 94 72 127 74 447 29.8 64.3 174.1 92.8 64 107 67 125 29.7 63.4 181.2 105.5 80 116 71 318 31.7 60.7 124.3 75.5 64 97 64 325 23.8 63.4 255.9 126.5 80 155 85 600 44.9 62.6 106.7 70 76 106 59 237 19.2 60.6 149.9 98 76 110 70 173 28.7 63.5 163.1 104.7 76 105 69 309 28.5 58.6 94.3 67.8 80 118 82 94 19.3 60.2 159.7 99.3 104 133 83 280 31 67.6 162.8 91.1 88 113 75 254 25.1 63.4 130 74.5 60 113 66 123 22.8 64.1 179.9 95.5 76 107 67 596 30.9 62.7 147.8 79.5 72 95 59 301 26.5 61.3 112.9 69.1 72 108 72 223 21.2 58.2 195.6 105.5 88 114 79 293 40.6 63.2 124.2 78.8 80 104 73 146 21.9 60.5 135 85.7 60 125 73 149 26 65 141.4 92.8 72 124 85 149 23.5 61.8 123.9 72.7 88 92 46 920 22.8 68 135.5 75.9 88 119 81 271 20.7 67 130.4 68.6 124 93 64 207 20.5 57 100.7 68.7 64 106 64 2 21.9 Leg elbow 41.6 42.8 39 40.2 36.2 43.2 38.7 41 43.8 37.3 42.3 39.1 40.3 48.6 33.2 43.4 41.5 40 38.2 38.2 38.2 41 38.1 38 36 32.1 31.1 39.4 40.2 39.2 39 36.6 27 38.5 39.9 37.5 39.7 39 41.6 33.8 wrist 6 6.7 5.7 6.2 5.5 6 5.7 6.8 7.8 6.3 6.6 5.7 6.6 7.2 7 6.2 6.3 6.8 6.8 6.9 5.9 8 6.1 7 6.7 5.4 6.4 7.1 5.9 6.2 6.3 5.9 7.5 5.6 6.4 6.1 5.8 6.3 6 5.6 arm 4.6 5.5 4.6 5 4.8 4.9 5.1 5.5 5.8 5 5.2 4.8 5.1 5.6 5.4 5.2 5.3 5 4.7 5.4 5 5.6 5 5.1 5.1 4.2 5.2 5.3 5.1 5 4.9 4.7 5.5 4.7 5.2 4.8 5 4.9 5.3 4.6 23.6 26.3 26.3 32.6 29.2 26.4 27.9 33 38.6 26.5 34.4 23.7 28.4 34 35.2 24.7 27 35 33.1 39.6 27 43.8 23.6 34.3 34.4 23.3 35.6 31.8 27 32.8 31 27 41.2 25.5 30.9 27.9 26.5 27.8 23 26.4

This question has not been answered.

Create a free account to get help with this and any other question!

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors