Seattle Take-Home Final Exam: Four Different Versions

Seattle Take Home Final Exam there Are Four Different Versions Of This

Seattletake Home Final Examhthere Are Four Different Versions Of This

Seattle Take Home Final Exam h There are Four Different Versions of this Exam Even though this is a take home exam – you are not permitted to work together. If we find evidence of cheating/working together you will receive a zero for the exam. DO NOT PICK THE SAME MAPS OR EXAMPLES AS OTHER STUDENTS! WE WILL CATCH YOU. We will have a ‘drop-in’ during class time on Thursday the 25th.

We won’t give you answers but we can guide you in the right direction. Along with this file you should have access to 2 excel files – one will be used for Part I the other for Part II Good luck!

Paper For Above instruction

Part I – Excel (28 points)

Using the attached Excel files, perform the following analyses:

  1. Calculate a frequency table based on the “room_type” variable, showing the counts for shared room, private room, and entire home/apt.
  2. Create a histogram from the frequency table that visually communicates the distribution of room types. Ensure it is aesthetically pleasing and focused on relevant information.
  3. Determine what percentage of listings cost more than $100 to rent.
  4. Identify the latitude and longitude of the properties with the highest and lowest prices, respectively.
  5. Count the total number of Airbnb listings in the dataset.
  6. Summarize each room type by calculating the mean and standard deviation of the “number_of_reviews” variable for shared rooms, private rooms, and entire homes/apartments.
  7. Describe in your own words the observed relationship between room type and the number of reviews.
  8. Identify the host with the most listings in the dataset.

Part II – Mapping with Copypastemap.com (9 points)

Use the ‘MAPTHESEDATA’ Excel file to create a map at Copypastemap.com

  1. Assess which part of the city has the most Airbnb properties—North, South, East, West, or Central.
  2. Take a screenshot of your map and paste it below.
  3. If you could add a popup feature to each map point, which variable from the Airbnb data would you include, and why would it be useful?

Part III – Social Explorer (20 points)

Create four maps in Social Explorer for your city based on 2017 data. The maps should show:

  • Areas where 50% of residents have a Bachelor’s Degree or higher.
  • Areas with over 40% owner-occupied housing.
  • Areas with income greater than $50,000.
  • Areas where the median age is less than 45.

Use appropriate classification methods and color schemes to highlight these areas. After creating the maps, write a 1-2 page narrative discussing which areas best match our criteria, where to recruit potential Airbnb hosts, and how principles of visual hierarchy influenced your map design.

Part IV – The Standard Deviation Curve (8 points)

Interpret the provided normal distribution curve in a few sentences about what it indicates about a data set.

For a hypothetical dataset with an average price of 88 and a standard deviation of 19:

  1. Determine the price range covering approximately 68.2% of properties.
  2. Identify a value that lies between +1 and +2 standard deviations.
  3. Provide a price considered an outlier based on the standard deviation criteria.

Part V – Miscellaneous (35 points)

  1. Select the diagram that best explains the relationship between class length at Temple and days attended per week.
  2. Compare two datasets: list a higher standard deviation between the two and justify why.
  3. Define gerrymandering and the Modifiable Areal Unit Problem (MAUP), describe their interrelation, and provide a real-life example of gerrymandering in 2-3 paragraphs.
  4. Explain how the maps demonstrating the 2016 presidential electoral results illustrate ecological fallacy in one paragraph.
  5. Describe the principles of spatial analysis discussed in class and analyze how they relate to one map from question 26, focusing on the Airbnb data.
  6. Select a data visualization from a credible news website, explain its storyline, and discuss the use of visual hierarchy in the visualization—in 1-2 paragraphs.
  7. Present examples of a standard cartogram and a Dorling cartogram, summarizing what each communicates in two paragraphs.
  8. Include visual or personal examples of Absolute Space, Relative Space, and Emotional Space, explaining their relevance based on class discussions (each with a brief explanation).
  9. Discuss the importance of location services: benefits and negatives, in 2-3 paragraphs.
  10. Explain how maps represent space with reference to choropleth map classification and projections.

Use your knowledge and the provided datasets to complete these tasks thoroughly, supporting your responses with relevant academic and credible sources, and ensuring your submission demonstrates critical thinking and analysis in geographic and spatial contexts.

References

  • Anselin, L. (2010). Spatial data analysis with R. Springer.
  • Fotheringham, A. S., Brunsdon, C., & Charlton, M. (2000). Quantitative Geography: Perspectives on Spatial Data Analysis. Sage.
  • Goodchild, M. F. (2010). Toward a General Theory of Geographic Representation. Cartographica, 45(4), 199–209.
  • O'Sullivan, D., & Unwin, D. (2014). Geographic Information Analysis. Wiley.
  • Crampton, J. W., et al. (2013). Mapping: A Critical Introduction to Cartography and GIS. Wiley.
  • Kraak, M. J., & Brown, A. (2018). Web Cartography. Taylor & Francis.
  • Hess, D. B., et al. (2014). Spatial Analysis: A Guide for Ecologists. Springer.
  • Robinson, A. C., et al. (2014). Elements of Cartography. Wiley.
  • Klein, R. (2013). Machine Learning in Geographic Data Analysis. Springer.
  • Harley, J. B., & Woodward, D. (Eds.). (2014). The History of Cartography, Volume 2: Cartography in the European Renaissance. University of Chicago Press.

Related Assignments