Step 1: Go to this website: http://www.pewtrusts.org/en/multimedia/data-visualizations/2014/fiscal- 50#ind0
Step 2: Read the analysis tab to learn about these data on public spending in states.
Step 3: Choose three states to compare the change in tax revenue over this time period.
Step 4: Ceate one or more graphs in excel to show this change. Save the graph(s) you made by taking a screen shot.
Step 5: Do they all follow the same path before and after the Economic Recession of 2008? Did any state far better than the others? Better than the 50 state average? Upload the image and the answers to these questions, with an overall explanation of what you found,
SAMPLE SOLUTION
WE WRITE PAPERS FOR STUDENTS
Tell us about your assignment and we will find the best writer for your project.
Write My Essay For MeStep 5 questions
A close look at the graph shows that the trend before and after the depression is the same. Before the depression, the tax revenue for the three states is increasing but at a very low pace. After the 2008 depression, they all suddenly fall tremendously, indicating the impact of the recession. The decline extends all the way to early 2009 where they begin to rise again but at a slow pace. After 2010, all the states began to record good growth and though some of them experienced occasional declines, the growth had been steady up to 2016. In the year 2008 when the recession began, the results were not…