Purchase Solution

Plotting Charts and Other Computations using Excel

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

Solution Summary

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.

Solution Preview

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 ...

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Introduction to Finance

This quiz test introductory finance topics.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.