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 attachment 1).
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?
Creating the column chart:
1. Column chart can be made by highlighting the entire data set.
2. Go to Insert --> Column.
3. Then select the column chart that you want.
Note: See the attached file entitled "Guide to Attachment 1. xlsx" for reference.
Creating the stacked bar chart:
Note: It would be impossible to plot an accurate stacked bar when subcategories do not add up to the total.
- In this case, only general categories of ...
The solution shows how to plot stacked bar chart, pie chart. It also shows how relative frequency, cumulative frequency, and average age are computed using Excel. Excel files are attached as guides.