Excel Chart

Uncategorized

USING EXCEL AND CREATING a 2D CHART

Attachments

Sheet1

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

KC 2007-4 2008-1 2008-2 2008-3 2008-4 -0.44 -0.64 -1.79 -3.27 -3.44 Spring 2007-4 2008-1 2008-2 2008-3 2008-4 1.55 0.51 -0.65 -2.1800000000000002 -2.2200000000000002 St Louis 2007-4 2008-1 2008-2 2008-3 2008-4 0.59 0.2 -1.42 -2.56 -2.95 2007-4 2008-1 2008-2 2008-3 2008-4

Sheet2

Sheet3



PLACE THIS ORDER OR A SIMILAR ORDER WITH NURSING PAPERS MARKET TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

About Author

mugambi

×
Open chat
You can now contact our live agent via Whatsapp! via +1 518 291-4128

Get plagiarism-free custom-written paper ready for submission to your Blackboard.

Enjoy crazy discounts by chatting with our live support team.