Excel Pie Charts Directions-1

.pdf

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

123

Subject

Economics

Date

Feb 20, 2024

Type

pdf

Pages

2

Uploaded by MajorTitanium606

Report
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