[10 points] Question 1: (2 points each) – Some Election Results [15 points] Question 2: Interpreting the Red and Blue Maps [30 points] Question 3: Associating Election Results and Poverty [20 points] Question 4: Big City Effects Make visible the ‘USCities’ layer in the ArcMap document, ‘11.220_testout04_start_Z.mxd’ and restrict the cities so that only those larger cities in the continental US (i.e., the 48 contiguous states without Hawaii and Alaska) with 1990 population greater than 200,000 are shown.11.220: Quantitative Reasoning and Statistical Methods for Planning I Test-out exam: January 2005 (Computer Lab Portion) Name: MIT E-mail address: @mit.edu Academic advisor’s name: Did you attend the brush-up? _____ All ______ Some ______ None Instructions: 1. Relax. Breathe. We recommend that you look through the exam and start with those problems you feel most comfortable answerin 2. You are allowed to use up to two textbooks of your choice, your own notes, plus any online 11.220 notes and online software manuals during the exam. Please note that you may not share these materials with other students. 3. For each problem, show your work wherever possible. Partial credit will be given if we have evidence that you framed the problem correctly and/or were headed in the right direction to obtain the correct answer. Points will be deducted if you are asked to show your work for a problem and fail to do so. You may use the back of any page to complete your work. In all cases, indicate clearly what your (single) final answer is for each question and make sure that your name is readable on any printouts and answer sheets that you turn in. 4. Your answers should be submitted to the staff as hard-copy at the end of the exam. You are welcome to assemble your answers in the online editor of your choice. You can also print out the PDF version of the exam and write your textual answers on the printed test. However, you will also need to submit printed graphics and maps. Make sure your name is written on each page of work that you submit. In addition to the textual answers, you are asked to submit 1 boxplot (#3A), 1 histogram (#3B), 1 scattergram (#3D), and 1 map (#4C). 5. Remember to keep your writing clear, tight, and to the point. Think before you write. You do not need more than a few well-written sentences to answer any of the questions on the exam. (This will save you time!) 6. Point values for each question are included in [brackets] next to each question on the exam: there are 100 total possible points. 7. During the exam, please let us know if you find unclear printing, typing, or errors on the exam. We will not give any hints about how to answer a question. If you think a question is unclear, clearly state your assumptions on the exam and complete the question to the best of your ability. 8. The exams will be scored and returned to your mailboxes in the student common room. You will be notified via email whether you have placed out of 11.220. Please read this statement and sign your name below. I certify that I have neither given to nor received assistance from another person on this exam, and that I have used only simple arithmetic functions on my calculator. Signature: 11.220 computing testout Spring 2005 [v4=final] 1Name: MIT E-mail address: @mit.edu 11.220: Quantitative Reasoning and Statistical Methods for Planning Testout – January 28, 2005 – Computing Portion This part of the 11.220 testout uses data about the 2004 US Presidential Election.1 The data include vote counts for Bush, Kerry, and Nader broken down by County and stored as attributes of a shapefile that can be viewed using ArcMap. The data also include a spreadsheet with county-level demographic, socio-economic, and environmental counts and factors. You will be asked to examine, create, and interpret descriptive statistics and thematic maps of the election results. You will also compute and interpret several measures of association between the election results and other county characteristics. Finally, you will use another dataset of major US cities to identify which counties contain major cities and compare their election results with those of the other counties. The GIS files and datasets needed for this testout exam are available in the 11.220 class locker. They include: election04_county.shp - a ‘shapefile’ of US Counties and Election 2004 vote counts election04_data_220s05.xls - a spreadsheet with additional county-level data election04_data_220s05.mdb - an MS-access database with the same data as the spreadsheet UScities.shp - the ESRI sample ‘shapefile’ of major US cities 11.220_testout04_start_Z.mxd - an ArcMap document that maps some of the election04 data These data are accessible from any WinAthena PC in the class AFS locker. The shapefiles, spreadsheet, and access database are in Z:\athena.mit.edu\course\11\11.220\data\testout05\testout05_data and the ArcMap document is in Z:\athena.mit.edu\course\11\11.220\data\testout05. (We put the ‘_Z’ at the end of the name of this ArcMap document to remind you that it accesses the two shapefiles from drive Z. Since the basemaps are read-only, you can leave it that way.) First, copy the whole ‘Z:\athena.mit.edu\course\11\11.220\data\testout05’ directory into C:\temp or some other scratch space on your local PC. Do your analyses using these locally stored datasets. By using the local copies you will speed up processing and avoid file sharing conflicts with your colleagues. In order to answer the following questions, the WinAthena machines in the computing lab have available for your use the following software packages: Excel, ArcMap, MS-Access, and SPSS. When you open the ArcMap document, you will see, in the Data Frame, three thematic maps using UScities.shp and the election04_county.shp shapefile. The top layer identifies major US cities (in the 48 contiguous states). The second layer is a thematic map shading the number of votes Bush received in each county (in the 48 contiguous states) using a red-to-blue color scale with 5 categories and 'natural break' classification. The bottom thematic map shades the same attribute field (Bush votes) using quantile classification. All the map layers are projected using a North_America_Albers_Equal_Area_Conic projection. [10 points] Question 1: