Serious Inquiries Only! Please note budget range
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
0 comments