Serious Inquiries Only! Please note budget range
If you can't complete this assignment my the time frame..Please do not bid..
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.Data set 1 men-1.xlsx
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.
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?”
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 women.xlsx