Excel Pie Charts Directions-1
.pdf
keyboard_arrow_up
School
Ivy Tech Community College, Indianapolis *
*We aren’t endorsed by this school
Course
123
Subject
Economics
Date
Feb 20, 2024
Type
Pages
2
Uploaded by MajorTitanium606
Excel: Pie Charts 1 Pie Chart Assignment The Economic Policy Institute lists the following monthly expenses for an average two-parent, two-child family in the Fort Wayne metro area: Housing $784 Food $721 Childcare $1,509 Transportation $1,174 Health Care $1,324 Taxes $727 Other Necessities $545 Part 1: Enter the information into Excel. Insert a Pie Chart •
Format the pie chart so both the dollar amount and percentage are visible. •
Add a title to your pie chart. Answer these questions in a Word document: 1)
What percentage of monthly household expenses are housing and transportation? 2)
What percentage of monthly household expenses are not housing and transportation? 3)
Make some observations. Do you think this is an accurate depiction of a two-parent, two-
child household in Fort Wayne?
Excel: Pie Charts 2 Part 2: Make a copy of your Excel spreadsheet: •
Right click on “Sheet 1” at the bottom of the Excel spreadsheet •
Choose “Move or Copy”, “(move to end)”, “Create a Copy”, then “OK”
Using Excel makes it easy to change the pie chart. You just made a copy of your original spreadsheet and pie chart, so enter these values for a 1-person household in Fort Wayne: Housing $526 Food $249 Childcare $0 Transportation $823 Health Care $431 Taxes $403 Other Necessities $281 Answer this question in the Word document: 4)
Other than the lack of childcare expenses, what are some similarities and differences in the two pie charts?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
interpret the data in the graph
arrow_forward
Only typed answer
arrow_forward
Year 2018
Year 2019
Year 2017
[Tahun 2017]
Price
Product
[Tahun 2018]
Quantity
[Kuantiti]
[Tahum 20191
Quantity
[Kuantiti]
[Produk]
Price
Price
Quantity
[Kuantiti]
(RM)
[Harga
(RM)]
(RM)
[Harga
(RM)]
1
(RM)
[Harga
(RM)]
1.25
A
180
200
200
90
75
90
100
100
120
0.6
675
0.5
600
0.5
630
Compute the values of nominal GDP in 2017, 2018 and 2019.
[Kirakan nilai-nilai KDNK nominal pada 2017, 2018 dan 2019]
(i)
arrow_forward
Store
Travel Time Each Way
Price of a Suit
(Minutes)
(Dollars per suit)
Local Department Store
15
102
Across Town
30
88
Neighboring City
60
65
Juanita makes $42 an hour at work. She has to take time off work to purchase her suit, so each hour away from work costs her $42 in lost income. Assume that returning to work takes Juanita the same amount of time as getting to a store and that it takes her 30 minutes to shop. As you answer the following questions, ignore the cost of gasoline and depreciation of her car when traveling.
Complete the following table by computing the opportunity cost of Juanita's time and the total cost of shopping at each location.
Store
Opportunity Cost of Time
Price of a Suit
Total Cost
(Dollars)
(Dollars per suit)
(Dollars)
Local Department Store
102
Across Town
88
Neighboring City
65
arrow_forward
Isocost line graph and tables
arrow_forward
question part c should contain a graph
arrow_forward
The table below is extracted from Goodland Republic Bureau of Statistics records for
2016 -2017. Use the information to answer the questions that follow.
Goodland Economy 2013 and 2018
I tem
Price 2017 (Base year) Price 2018
Price per
Price per
Unit ($) | Production
55,000
98,000
45,000 2,450.00
110,000
6.000 7,000.00
Unit ($)
Production
50,000
100,000
50,000 23,000.00
120,000
5,000
Rice ( tons)
Wheat (tons)
Tractors mid-size (units)
Cotton (tons)
Used cars
Manufacture garments
( tons)
Eggs (Trays)
Соса Cola (litres)
Pepsi Cola (litres)
Beef (tons)
Second hand cloths (tons)
Alcoholic Beverages (litres)
Milk (litres)
1.50
2.00
2.00
2.50
100.00
120.00
5,000.00
50.00
150,000
2,000
6,000
700
145,000
2,300
6,500
70.00
2.50
3.50
0.80
1.20
1.50
1.10
850
5,000
500
500
4,800
450
600
6.50
8.50
15.00
25.00
3.25
3.75
7,000
2.30
7,500
2.50
Examine the status of the economic welfare in Goodland Republic in 2018 based on
your GDP deflator, nominal GDP and Real GDP. Also, explain the reasons why it is…
arrow_forward
please help with #4
arrow_forward
Supply
Price of Computers ($)
Sdomestic
Demand
Tariff Amount
1,000
New Domestic Equilibrium
CALCULATIONS
800
World Price
Domestic Quantity Supplied
110
Imports
Domestic Quantity Demanded
190
domestic
Level of Imports
80
190
110
Tariff Amount
$0
arrow_forward
Only typed answer
Barney decides to quit his job as a corporate accountant, which pays $11,000 a month, and goes into business for himself as a certified public accountant.
He runs his business from his converted garage apartment, which he could rent out for $305 a month if he wasn’t using it as a home office. He must purchase office supplies worth $70 a month, and his monthly electricity bill has increased by $50 now that he is working out of his home office.
After six months of working from home, Barney has earned an average of $19,000 per month.
Instructions: Enter your answers as a whole number.
a. What are Barney’s monthly explicit costs?
$
b. What are Barney’s monthly implicit costs?
$
c. What are Barney’s monthly economic costs?
$
arrow_forward
Table 3 below shows a data set comprising the total revenue generated by a different department in an
organization over one year.
A- Describe how a set of data can be represented in graphical form as frequency polygon.
Table 3
Department
Particle board
Plywood
Furnishing
Paints
Revenue
1000
1500
2000
5500
arrow_forward
In the 1980s land prices in Japan surged upward in a “speculative bubble.” Land prices then fell for 11 straight years between 1990 and 2001. What can we safely assume happened to land rent in Japan over those 11 years? Use graphical analysis to illustrate your answer.
arrow_forward
Part I The headline about Russian wheat suggests the market is broken. Illustrate the supply and demand
for Russian wheat indicating the price in relation to equilibrium. Explain why the market is "broken," and
what needs to occur to fix the market. Russian wheat trade falls silent as price floor leaves market 'broken'
HIGHLIGHTS Russian wheat not offered below $275/mt since late March Government believed to have
intervened to support prices, farmers Traders assess pricing power of Russian state in global market Part II
Derive the demand and supply functions using the numbers in the table and calculate equilibrium price and
quantity. Graph supply and demand and indicate equilibrium price and quantity. The government wants to
help sugar consumers by setting the price at $2.50. Explain the outcome (in terms of Q and D) and your
advice in this situation. Illustrate the effect on the same graph and be sure to indicate price and quantities.
Price/bag Quantity demanded (bags of sugar)…
arrow_forward
Please help me graph this
arrow_forward
What is the Excel method?
arrow_forward
urgnt
arrow_forward
You and Karen are attorneys at a civil law firm.
Your client, Silvia, manufactures custom furniture
pieces. Her company is called Via Designs and
she owns it as a sole proprietor. She has recently
been sued for negligence after an incident that
occurred in her shop.
Observe new image on the right
30
arrow_forward
A certain beverage company provides a complete line of beer, wine, and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2011 and 2014 and quantities sold in cases for 2011 follow. Use 2011 as the base period.
Unit Price ($)
Item
2011 Quantity(cases)
2011
2014
Beer
35,000
17.50
20.15
Wine
5,000
100.00
117.00
Soft drink
70,000
8.00
8.80
Compute the price relatives for this company's products. (Round your answers to two decimal places.)
Item
Price Relative
Beer
Wine
117.00
Soft drink
110.00
Use a weighted average of price relatives to show that this method provides the same index as the weighted aggregate method. (Round your answers to the nearest integer.)
weighted average of price relatives index: ____ weighted aggregate price index :______
arrow_forward
listen to this The Economist, Adam ruins everything video, and a few other articles about using a market to help animal conservation using trophy hunting. Please write a 1 to 2-page paper about how the program alters how people look at different animals.
Paper requirements:
Size: 11
Font: Calibri
Spacing: Double
Length: 1-2
Paper Questions:
Adam ruins everything: https://youtu.be/cQh-f1rBjx4
The Economist: https://youtu.be/9y7YFjisSTg
Vice article: Link
Questions you must answer, you may write a standard paper, or you can answer the following questions in bullet point form. You must write it in an easy-to-read form regardless of how you choose to do it.
What is trophy hunting? Is trophy hunting the main reason animals are being killed off?
Why is there demand for exotic animal parts? How does this impact animal deaths?
https://www.vice.com/en/article/akgb3a/rare-rhino-horns-worth-78-million-burnt
Please describe how the program works. Walk me through all the steps.
What issues do…
arrow_forward
Use the following table to find percentage changes in the cost of living (COL) from 2020 to
2021:
Year Housing ($) Transportation ($)
2020 10,000
2021 10,500
2022 11,000
0.71%
7.09%
79%
O 70.9%
1,200
1,350
1,400
Food ($)
1,500
1,750
1,800
COL ($)
Change(%)
N/A
arrow_forward
The supply equation for a given product is
y = 10x + 50, while the demand equation for the
same product is given by y = 5x + 350, where x
is the price per unit and y is the number of units sold.
Find the break-even point, the price and quantity at
which supply equals demand. First graph each line,
then place a dot indicating the solution to the system.
+500 +
-450
400
350
300
250
200
150
100
10
50
-50
-100
-150
-200
-250
-300
10 20 30 40 50
60 70 80 90 1
arrow_forward
Table 1 data for household consumption and income
Consumption per week (US $) (Y)
55, 60, 65, 70, 75
65, 70, 74, 80, 85, 88,
79, 84, 90, 94, 98
80, 93, 95, 103, 108, 113, 115
102, 107, 110, 116, 118, 125
110, 115, 120, 130, 135, 140
Income per week (US $) (X)
80
100
120
140
160
180
200
120, 136, 140, 144, 145
220
135, 137, 140, 152, 157, 160, 162
240
137, 145, 155, 165, 175, 189
260
150, 152, 175, 178, 180, 185, 191
1. Regarding the data in table 1, suppose for each Xi, we take a Yi
randomly, and get the sample data in the table 2.
Table 2 sample data
Y
70
65
90
95
110
115
120
140
155
150
X
80
100
120
140
160
180
200
220
240
260
a. Drawn a picture with income being X-axis, and consumption being Y-
axis with sample data in the table 2.
b. Drawn the SRF and PRF in the same picture (with data in both table
1 and 2).
c. Are SRF and PRF different? Why?
arrow_forward
Pls help ASAP
arrow_forward
Jadual 1 menurnfukkan beberapa data harga dan kuantiti untuk sebuah ekonomi zederhana
jang menghasilkan darang dan perkhidmatan derikut.)
Table 1: Price and quantity for three types of product
[Jadual I: Harga dan kuantiti sontuk tiga jenis produk)
Product
[Produk)
Year 2019
[Tahun 20191
Price
(RM)
[Harga
(RM)
1.25
Year 2017
Year 2018
[Tahun 20181
Price
(RM) Kuanti) (RM) Kuanttij
[Harga
(RAM))
1
[Tahun 2017)
Quantity
Quantity
Kuantitij
Price
Quantity
[Harga
(RM))
A
180
200
200
B
90
75
90
100
100
120
0.6
675
0.5
600
0.5
630
(1)
Compute the values of nominal GDP in 2017, 2018 and 2019.
[Kirakan nilai-nilai KDNK nominal pada 2017, 2016 dan 2019)
(6 Marks/ Markah)
Compute the values of real GDP and GDP deflator in 2018 and 2019
(using 2017 as the base year).
[Kirakan nilai-nilat KDNK zebenar dan KDNK pendeflari pada 2018 dan 2019
(menggunakan tahun azas 2017))
(5 Marks/ Markak)
(iii) Compute the percentage change in the real GDP in 2018 and 2019
from the preceding year.
(Kinatan nerat…
arrow_forward
Refer to the accompanying table to answer the next six questions.
Quantity of
Quantity of
Monthly Rent Apartment Demanded Apartments Supplied
$1,500
$1,550
$1,600
$1,650
136,500
78,100
112,750
83,760
107,000
100,100
98,450
87,900
94,250
$1,700
98,450
$1,750
$1,800
95,000
92,800
118,500
125,600
arrow_forward
Illustrate using a supply and demand graph what happened to gasoline prices in the World View, and then identify the effect on
equilibrium price and quantity.
WORLD VIEW
Gas Prices Jump in Wake of Saudi Attack
The Saudi Arabian oil processing plants in Abqaiq were hit by
drone strikes, shutting down about half of the Kingdom's
production capacity. Early estimates put the damage at about
5.7 million barrels of oil per day, roughly half of Saudi output.
Crude oil prices jumped as much as $8 per barrel and U.S.
gasoline prices jumped by 9 cents a gallon, according to the
U.S. Energy Information Agency.
Source: News reports, September-December 2019.
a, b. Which curve shifted? Which direction did that curve shift?
Instructions: Drag the supply or demand curve to its new position.
Price of Gasoline ($ per gallon)
Gasoline
Supply
x
Demand
Quantity of Gasoline (gallons per day)
c. Price (Click to select) V
d. Quantity (Click to select) V
arrow_forward
The answer choices for the fill in the blank is local department store, store in the neighboring city, and store across town
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
Related Questions
- interpret the data in the grapharrow_forwardOnly typed answerarrow_forwardYear 2018 Year 2019 Year 2017 [Tahun 2017] Price Product [Tahun 2018] Quantity [Kuantiti] [Tahum 20191 Quantity [Kuantiti] [Produk] Price Price Quantity [Kuantiti] (RM) [Harga (RM)] (RM) [Harga (RM)] 1 (RM) [Harga (RM)] 1.25 A 180 200 200 90 75 90 100 100 120 0.6 675 0.5 600 0.5 630 Compute the values of nominal GDP in 2017, 2018 and 2019. [Kirakan nilai-nilai KDNK nominal pada 2017, 2018 dan 2019] (i)arrow_forward
- Store Travel Time Each Way Price of a Suit (Minutes) (Dollars per suit) Local Department Store 15 102 Across Town 30 88 Neighboring City 60 65 Juanita makes $42 an hour at work. She has to take time off work to purchase her suit, so each hour away from work costs her $42 in lost income. Assume that returning to work takes Juanita the same amount of time as getting to a store and that it takes her 30 minutes to shop. As you answer the following questions, ignore the cost of gasoline and depreciation of her car when traveling. Complete the following table by computing the opportunity cost of Juanita's time and the total cost of shopping at each location. Store Opportunity Cost of Time Price of a Suit Total Cost (Dollars) (Dollars per suit) (Dollars) Local Department Store 102 Across Town 88 Neighboring City 65arrow_forwardIsocost line graph and tablesarrow_forwardquestion part c should contain a grapharrow_forward
- The table below is extracted from Goodland Republic Bureau of Statistics records for 2016 -2017. Use the information to answer the questions that follow. Goodland Economy 2013 and 2018 I tem Price 2017 (Base year) Price 2018 Price per Price per Unit ($) | Production 55,000 98,000 45,000 2,450.00 110,000 6.000 7,000.00 Unit ($) Production 50,000 100,000 50,000 23,000.00 120,000 5,000 Rice ( tons) Wheat (tons) Tractors mid-size (units) Cotton (tons) Used cars Manufacture garments ( tons) Eggs (Trays) Соса Cola (litres) Pepsi Cola (litres) Beef (tons) Second hand cloths (tons) Alcoholic Beverages (litres) Milk (litres) 1.50 2.00 2.00 2.50 100.00 120.00 5,000.00 50.00 150,000 2,000 6,000 700 145,000 2,300 6,500 70.00 2.50 3.50 0.80 1.20 1.50 1.10 850 5,000 500 500 4,800 450 600 6.50 8.50 15.00 25.00 3.25 3.75 7,000 2.30 7,500 2.50 Examine the status of the economic welfare in Goodland Republic in 2018 based on your GDP deflator, nominal GDP and Real GDP. Also, explain the reasons why it is…arrow_forwardplease help with #4arrow_forwardSupply Price of Computers ($) Sdomestic Demand Tariff Amount 1,000 New Domestic Equilibrium CALCULATIONS 800 World Price Domestic Quantity Supplied 110 Imports Domestic Quantity Demanded 190 domestic Level of Imports 80 190 110 Tariff Amount $0arrow_forward
- Only typed answer Barney decides to quit his job as a corporate accountant, which pays $11,000 a month, and goes into business for himself as a certified public accountant. He runs his business from his converted garage apartment, which he could rent out for $305 a month if he wasn’t using it as a home office. He must purchase office supplies worth $70 a month, and his monthly electricity bill has increased by $50 now that he is working out of his home office. After six months of working from home, Barney has earned an average of $19,000 per month. Instructions: Enter your answers as a whole number. a. What are Barney’s monthly explicit costs? $ b. What are Barney’s monthly implicit costs? $ c. What are Barney’s monthly economic costs? $arrow_forwardTable 3 below shows a data set comprising the total revenue generated by a different department in an organization over one year. A- Describe how a set of data can be represented in graphical form as frequency polygon. Table 3 Department Particle board Plywood Furnishing Paints Revenue 1000 1500 2000 5500arrow_forwardIn the 1980s land prices in Japan surged upward in a “speculative bubble.” Land prices then fell for 11 straight years between 1990 and 2001. What can we safely assume happened to land rent in Japan over those 11 years? Use graphical analysis to illustrate your answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Economics Today and Tomorrow, Student EditionEconomicsISBN:9780078747663Author:McGraw-HillPublisher:Glencoe/McGraw-Hill School Pub Co
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co