| | | | | 2007-4 | 2008-1 | 2008-2 | 2008-3 | 2008-4 |
| | | | KC | -0.44 | -0.64 | -1.79 | -3.27 | -3.44 |
| | | | Spring | 1.55 | 0.51 | -0.65 | -2.18 | -2.22 |
| | | | St Louis | 0.59 | 0.2 | -1.42 | -2.56 | -2.95 |
| | | | USING EXCEL AND CREATING a 2D CHART |
| | | | 1-----Follow the method above to create the data tables. Notice that you keep adding 2009-1, 2009-2, 2009, 2009-4, etc |
| | | | 2-----Highlight the entire table once you are done. You can see the three Missouri metropolitan areas (Kansas City, Springfield, St Louis) |
| | | | 3-----Once you have highlighted the table you put together then go to INSERT at the top where you see the tabs, go to LINE and choose 2D |
| | | | 4-----The graph was created from the table you put together |
| | | | 5-----Use this graph to develop your analysis of changing house prices in the three Missouri metropolitan areas. Based on that you can develop some analysis regarding property taxes and their impact on, say, school districts. One of the data pages that is included in this assignment shows you what property taxes are as a percentage of local finances. |
| | | | 6-----This may appear technical, but it really is not. You are using data, creating tables and then turning that into a chart and from that developing some basic observations about an aspect of policy planning. Part of policy analysis is try to anticipate problems on the horizon |
vennamason
CopyofExcelGuidelinesforThirdAssignmentinMPAPublicFinanceandTaxation1.xlsx
