Assignment:
1. Create a bar graph using two different colors to represent the male and female categories. Use age to categorize and graph the average BMI. You only need to do a bar graph for BMI. This should be a histogram where the data is grouped by the category (age). So each bar should represent the average BMI value for a range of ages (such as 30 - 40). We should be able to see from this graph the relative ages that have the largest BMI.
2. Create a Pie chart to represent the age bracket of participants showing what percent of participants are within each age bracket. So each slice of the pie should graphically represent the percentage of the total sample lie within a specific age range (such as 20-30).
3. Compare males and females Diastolic blood pressure, only the blood pressure. Support your results by including all measures of central tendencies and measures of dispersion that we have covered in this course (6 different measures).
First question:
The first question is to make a histogram with bars for men and women (there are several examples of frequency distributions and histograms in section 12.1). The data for men and women should be on one graph. You should be using all the data points for the variable you were asked to graph.
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.
Section 12.1 of the text reviews how to create frequency distributions and histograms. There is a good tutorial on making histograms in excel here:
Second question:
The second question is to make a pie chart. The pieces of a pie chart, if represented in %'s, should add up to 100%. For reference, there is a fancy pie chart on Page 685, #35 (just for reference). For the pie chart, you should also be using all the data points for the variable you were asked to graph.
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?" Also, there is a tutorial on making pie charts in excel here:
Third question:
The third question is to determine the 6 statistics of central tendency and dispersion for your data, one set of men, one set for women, then compare these results.
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.
*hint - you can look at the PowerPoint slides for this chapter to see what the measures of central tendency and dispersion are. One of the first slides will say central tendency and list each measure and in the other slideshow it will say dispersion and list the measures.
If you have difficulty making graphs in excel, I would recommend ‘googling' how to make graphs, or pie charts, or histograms in excel. There are many sites that will walk you thru it.
Attachment:- Reference.rar