a. Explanation From figure 2.5 and 2.6, the data about the percentage of retirement funds in various categories of risk levels can be obtained as follows: Risk Levels Percentage Low 31 % Average 47 % High 22 % Exploded Pie Chart: Software procedure: The steps to draw the exploded pie chart using Excel software is given below: Enter the above given data in Excel sheet and select the whole data. Go to Insert > Charts > Insert Pie or Doughnut chart . Select the 3-D pie and click Pie. Click on parts of pie and go to series option . Enter pie explosion as 10 % . Click on Design in menu bar and select Add chart element to edit the chart title. The exploded pie chart is given below: Doughnut chart: Software procedure: Step by step procedure to draw the doughnut chart by using Excel software is given below: Enter the above given data in Excel sheet and select the whole data. Go to Insert. Under charts section, select Insert Pie or Doughnut Chart . Then select Doughnut b. To determine Determine which graph would be preferred among figure 2.5 and 2.6 and charts obtained in part (a).

14th Edition

ISBN: 9780135285923

Author: MARK BERENSON

Publisher: PEARSON

See similar textbooks

Videos

Question

Chapter 2, Problem 76PS

To determine

Construct an exploded pie chart, doughnut chart, a cone chart and a pyramid chart.

To determine

Determine which graph would be preferred among figure 2.5 and 2.6 and charts obtained in part (a).

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 2, Problem 75PS

Chapter 2, Problem 77PS

Students have asked these similar questions

help me with ab please. please handwrite if possible. please don't use AI tools to answer

help me with abcd please. please handwrite if possible. please don't use AI tools to answer

Chapter 2 Solutions

BASIC BUSINESS STATISTICS

Ch. 2 - A categorical variable has three categories, with...Ch. 2 - The following data represent the responses to two...Ch. 2 - The following table, stored in Smartphones Sales,...Ch. 2 - The Consumer Financial Protection Bureau reports...Ch. 2 - In addition to the impact of Big Data, what...Ch. 2 - This table represents the summer power-generating...Ch. 2 - Timetricâ€™s 2016 survey of insurance...Ch. 2 - A survey of 1,520 Americans adults asked â€œDo you...Ch. 2 - A study of selected Kickstarter projects showed...Ch. 2 - Do special recommendations increase ad...

Knowledge Booster

$Statistics$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Construct an exploded pie chart, doughnut chart, a cone chart and a pyramid chart.

Solution Summary: The author explains how to draw an exploded pie chart, doughnut chart and a pyramid chart using Excel software.

Videos

Construct an exploded pie chart, doughnut chart, a cone chart and a pyramid chart.

Determine which graph would be preferred among figure 2.5 and 2.6 and charts obtained in part (a).

Want to see the full answer?

Chapter 2 Solutions