Data from the 2000 U.S. Census show the following distribution of ages for resid

Data from the 2000 U.S. Census show the following distribution of ages for residents of Ohio:Total Households 4445773Family households (families) 2993023 With own children under 18 years 1409912Married-couple family 2285798 With own children under 18 years 996042Female households no husband present 536878With own children under 18 years 323095Nonfamily households 1452750Householder living alone 1215614Householder 65 years and over 446396a. Construct a column chart to visually represent these data.b. Construct a stacked bar chart to display the sub categories where relevant. (Note that you will have to complete additional subcategories for instance under Family households 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.)c. Construct a pie chart showing the proportion of households in each category.Ch2-prob 1 p54A community health status survey obtained the following demographic information from the respondents:Age Frequency18-29 29730-45 66146-64 63465+ 369Compute the relative frequency and cumulative relative frequency of the age groups. Also estimate the average age of the sample of respondents. What assumptions do you have to make to do this