Problem Set #1
Graphing and Summarizing Data
Due in SmartSite by 10 p.m. on Monday, April 12
Department of Economics
Please submit a Word document in SmartSite containing all of your written
answers and graphs to the questions below.
Also, submit an Excel document containing the
background calculations and graphs used in Word.
California Voters and Balancing the State Budget
Consider the data below regarding the final California budget for 2009-2010:
California General Fund Expenditures by Agency, 2009-2010
(Millions of Dollars)
Health and Human Services
Corrections and Rehabilitation
Business, Transportation, and
California Budget 2010-2011
, Governor’s Proposed Budget,
Note that “Natural Resources” includes state parks and
“Other” includes the legislative, judicial, and executive
branches of government as well as environmental protection, and employment
Construct a well-formatted and labeled pie chart in Excel displaying the data
Be sure to include the percentages in your pie chart.
Copy and paste the
completed chart into Word.
A recent public opinion poll (Field Poll, March 2, 2010,
) showed that the
majority of California voters prefer spending cuts, and not increases in taxes, to
eliminate the projected $20 billion deficit in California’s budget for next year