Task: Please assist with the following questions and add solutions to the attached Excel spreadsheets:
1.a) Construct a column chart to visually represent these data (see below).
1.b) Construct a stacked bar chart to display the sub-categories where relevant. (Note that you will have to compute additional subcategories, for instance, under Family households, this will have to be done for the number of families without children under 18, so that the total of the subcategories equals the major category total. The sum of all categories does not equal the total.)
1.c) Construct a pie chart showing the proportion of households in each category.
2) Compute the relative frequency and cumulative relative frequency of the age groups (see attachment 2). Also, estimate the average age of the sample of respondents. What assumptions do you have to make to do this?
Total Households 4,445,773
Family households (families) 2,993,023
With own children under 18 years 1,409,912
Married-couple family 2,285,798
With own children under 18 years 996,042
Female householder, no husband present 536,878
With own children under 18 years 323,095
Nonfamily households 1,452,750
Householder living alone 1,215,614
Householder 65 years and over 446,396
Age Frequency
18-29 297
30-45 661
46-64 634
65+ 369