Under DocSharing on our COURSE WEBPAGE are two Excel spreadsheets. Open and print these two spreadsheets labeled:
Individual Project Female Data Set
Individual Project Male Data Set
You will need these two files ABOVE to do your Individual Project assignment. (Hint: Excel allows you to SORT. Use this feature on the above Data Sets to help categorize by teens, 20’s, 30’s, 40’s, 50’s, 60’s, and 70’s ONLY for questions 1. and 2.below.)
1. Create a bar graph using two different colors to represent the male and female categories. Use age (on the x-axis) to categorize and graph the average BMI on the y-axis. Categorize the data points by age groups as indicated above. Do a grouping of teens and determine their average BMI, average BMI for ages 20 – 29, average BMI for ages 30 – 39, etc. You will end up with fewer bars and a more useful graph.
2. Create a pie chart to represent the systolic blood pressure for participants. Categorize the data points by age groups as indicated above. Do a grouping of teens and determine their average systolic blood pressure, average systolic for ages 20 – 29, average systolic for ages 30 – 39, etc. You will end up with fewer partitions and a more useful pie graph.
3. Compare ALL males (not by age group) as a WHOLE and ALL females (not by age groups) Diastolic blood pressure. Support your results by including the following Measures of Central Tendencies and Measures of Dispersion that we have covered in this course. These require you to find the Mean, Median, Mode, Midrange, Range, and Standard Deviation. You need to do these separately for Males and separately for Females.
FURTHER CLARIFICATION and HELPFUL REFERENCES for answering the above three questions!
These data sets are for Male and Female and are in the Doc Sharing tab at the top of our course webpage.
QUESTIONS 1. AND 2. ABOVE: BAR GRAPH (aka Histograms) and PIE CHARTS (aka Circle graphs)
Your very first assignment for this course was to read certain sections in Chapter 1. Well, that is where you will find the basics necessary to create these graphs.
Examples of how to do these are in Section 1.2, starting on page 19. Look specifically at Examples 5, 6, 7, and 8
Section 12.1 on page 771 and 772 also shows Bar Graphs (Histograms). Look at Example 4 and also Figure 12.1.
After reading these sections for comprehension, then create a Bar Graph and a separate Pie Chart for the MALE data set and do the same for the FEMALE data set.
To do the bar graph, just use the AGE and BMI columns from the data set. Do it for males and females. No means, median, mode, range, midrange, or standard deviation need to be calculated for this graph.
To do the pie chart, just use the AGE and SYSTOLIC BLOOD columns from the data set. Do it for males and females. No means, median, mode, range, midrange, or standard deviation need to be calculated for the pie chart.
QUESTION 3 ABOVE – MEASURES OF CENTRAL TENDENCY and DISPERSION with Textbook Reference Pages
1. MEAN REFERENCES – Page 782 – Example 2
2. MEDIAN REFERENCES – Page 783 – Examples 3 – 6 with Bar Graph
3. MODE REFERENCES – Page 788 – Example 8
4. MIDRANGE REFERENCES – Page 789 – Example 9
COMBINED REFERENCES – For the preceding four measures of central tendency, go to Page 790 and review Example 10
5. RANGE REFERENCES – Page 795 – Example 1
6. STANDARD DEVIATION REFERENCES – Page 795 – Examples 2 thru 4
To do the measures of Central Tendency and Dispersion, just use the Diastolic Blood column from the data set. Do it for males. Then do these calculations again for females. This is where you do the calculations for means, median, mode, range, midrange, and standard deviation.