Explanation Given: Payroll taxes are used for Social Security and Medicare, two of the biggest items in the federal budget. The following facts regarding the people in the United States who pay taxes were reported in Money magazine in March 2012 : Taxpaying and Non-Taxpaying Groups Percent Pay income tax 53.6 Pay no income tax but do pay payroll taxes 28.3 Pay no income tax but are elderly 10.3 Pay no income tax but earn less than $ 20 , 000 6.9 Others 0.9 Table ( 1 ) Approach: The pie chart for the given table can be easily constructed with the help of excel, first step is write the given table in excel and the then go to insert and select pie chart. The pie chart is obtained on the same screen for the given table. Calculation: Step 1: Enter the given table in excel and highlight the data in cell A2:A6 and B2:B6 as show in the figure ( 1 ) . Figure ( 1 ) Step 2: Click on the Insert ribbon tab and then select Pie from the charts group

12th Edition

ISBN: 8220103649001

Author: Tan

Publisher: CENGAGE L

See similar textbooks

Concept explainers

Bar Graphs

A bar graph is a chart or graphical representation of data. A bar chart, also known as a bar graph, is a graph or chart that displays categorical data using rectangular bars with heights or lengths equal to the values they represent. Typically, bar graph…

Videos

Question

Chapter 8.1, Problem 5TE

To determine

To construct:

The pie chart for the given table with the help of excel only.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 8.1, Problem 4TE

Chapter 8.1, Problem 6TE

Students have asked these similar questions

MODELING REAL LIFE Your checking account has a constant balance of $500. Let the function $m$ represent the balance of your savings account after $t$ years. The table shows the total balance of the accounts over time. Year, $t$ Total balance 0 1 2 3 4 5 $2500 $2540 $2580.80 $2622.42 $2664.86 $2708.16 a. Write a function $B$ that represents the total balance after $t$ years. Round values to the nearest hundredth, if necessary. $B\left(t\right)=$ Question 2 b. Find $B\left(8\right)$ . About $ a Question 3 Interpret $B\left(8\right)$ . b represents the total balance checking and saving accounts after 8 years the balance would be 16 / 10000 Word Limit16 words written of 10000 allowed Question 4 c. Compare the savings account to the account, You deposit $9000 in a savings account that earns 3.6% annual interest compounded monthly. A = 11998.70 SINCE 9000 is the principal ( 1+0.036/12)12 times 8 gives me aproxtimately 1997 14 / 10000 Word Limit14 words written of 10000 allowed Skip to…

Listen MODELING REAL LIFE Your checking account has a constant balance of $500. Let the function m represent the balance of your savings account after t years. The table shows the total balance of the accounts over time. Year, t Total balance 0 $2500 1 $2540 2 $2580.80 3 $2622.42 4 $2664.86 5 $2708.16 a. Write a function B that represents the total balance after t years. Round values to the nearest hundredth, if necessary. B(t) = 500 + 2000(1.02)* b. Find B(8). About $2843.32 Interpret B(8). B I U E T² T₂ c. Compare the savings account to the account, You deposit $9000 in a savings account that earns 3.6% annual interest compounded monthly. B I U E E T² T₂ A = 11998.70 SINCE 9000 is the principal (1+0.036/12)12 times 8 gives me aproxtimately 1997

14. Show that if a, b, and c are integers such that (a, b) = 1 and c | (a+b), then (c, a) = (c, b) = 1.

Chapter 8 Solutions

EBK FINITE MATHEMATICS FOR THE MANAGERI

Ch. 8.1 - What is a random variable? Give an example.Ch. 8.1 - Prob. 2CQ Ch. 8.1 - Prob. 3CQ Ch. 8.1 - Three balls are selected at random without...Ch. 8.1 - 2.A coin is tossed four times. Let the random...Ch. 8.1 - A die is rolled repeatedly until a 6 falls...Ch. 8.1 - Cards are selected one at a time without...Ch. 8.1 - Prob. 5E Ch. 8.1 - Prob. 6E Ch. 8.1 - Prob. 7E

Knowledge Booster

Learn more about

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

To construct: The pie chart for the given table with the help of excel only.

Solution Summary: The author explains how the pie chart for the given table can be easily constructed with the help of excel.