Assignment: Take Home Lab
Part I - Excel - SEE THE ATTACHED EXCEL FILE TO ANSWER THESE QUESTIONS
1. Calculate a Frequency Table based on the "room_type" variable.
Variable Value Code Frequency
Room Type Shared Room 1
Private Room 2
Entire Home/Apt 3
2. Make a histogram using the frequency table above - snip and paste it below. Make sure that your histogram looks aesthetically pleasing and only communicates relevant information about Room Type.
3. For the "Price" variable what percentage of listings cost more than 100 dollars to rent?
4. What is the latitude and longitude of the property with the highest and lowest price? You should have 2 sets of coordinates for this question.
5. How many total Air BnB listings are there in this data set?
6. Now summarize each room type and calculate the mean and standard deviation for the number of reviews variable.
Room Type Average for each room type category for number of reviews Standard Deviation for each room
type category for number of reviews
Shared Room(1)
Private Room(2)
Entire Home/Apt(3)
7. In your own words summarize/describe the relationship you observe between room type and number of reviews.
8. Who is the host with the most listings?
Part II - Mapping with Copypastemap website
Use the ‘MAPTHESEDATA' Excel Files included with the exam to create a map from this Website
Copypastemap website
Answer the following questions based on the map you create:
9. What part of the city are most Air BnB properties located in? (North, South, East, West, Central)?
10. Take a Snip (or command + control + 4 on Mac) of the map you created. Paste it below this question.
11. When we created a similar map in Lab 6 we had a legend category (Something appeared/popped up when the user clicked on one of the points). If you could add a popup to each point (Something that would appear about each property when the user clicked on it) what variable from our Air BnB data set would you include? Explain why this information would be useful to include on a map.
Part III - Social Explorer
12. Instruction for Social Explorer:
Create four maps in Social Explorer based on the area you conducted Air BnB analysis on. Tell a story about these maps and explain how you used principles of visual hierarchy to create them.
a) Create the following maps. You are trying to locate new folks to rent/host properties on Air BnB.
Use 2017 data.
Areas in Your City Where 50 percent of folks have a Bachelor's Degree or Higher
Area in your City that have over 40 percent owner occupied housing
Areas where income is greater than 50,000 dollars
Areas where the age variable is less than 45
Use color, cut points, and classification methods to create maps that highlight the areas that meet the criteria above in your city. Each map should have an appropriate title as well.
b) Tell a 1-2 page long story analyzing your maps. Based on your maps, which areas of the city match our criteria best? Where would be a good place to recruit more Air BnB hosts? Talk about some of the classification and color decisions you made on the maps. How did you use principles of visual hierarchy in your map?
Part IV - The standard deviation curve (8 points)
The diagram below is the normal distribution. Answer the following question based on the diagram.
17. Explain in one or two sentences what this normal curve tells us about a data set? (2 points)
If the average price of a hypothetical Air BnB data set is 156 and the standard deviation 34: answer the following questions...
20. 68.2 percent of air BnB properties are expected to fall in-between which prices? (2 points)
21. What is a price that falls in between +1 and +2 standard deviations? (2 points)
22. Provide a score that would be an outlier in this data set? (2 points)
Part IV: Miscellaneous
23. Which diagram below best explains the relationships between how hot it is outside and thirst?
24. Examine the following two data sets:
a) 1,1,1,1,5,9,9,9,9
b) 4,4,4,4,5,6,6,6,6
Which has a higher Standard Deviation? (A or B)
25. What does Gerrymandering have to do with the Modifyable Areal Unit Problem? You should define both (As we talked about them in class - you will lose points for simply doing an Internet search) and explain how they are interrelated. Research and summarize a real life example of Gerrymandering. 2-3 paragraphs.
26. Explain how these maps demonstrate the principle of ecological fallacy. They are both electoral college maps from the presidential election in 2016. Democrat Hilary Clinton won Blue state and Republican Donald Trump won red states. The map on top shows the electoral college at the scale of the state and the map on the bottom shows the electoral college at the level of the county. The electoral college is a winner take all system. If a candidate wins a state they get all the votes/points for that state. 1 paragraph.
27. What are the principles of spatial analysis we discussed in class? Use them to make sense of one of the maps from question 26. Focus your analysis on the location of the Air BnB data you were given. 1-2 paragraphs.
28. Choose a data visualization from fivethirtyeight.com or the New York Times Graphics Twitter and explain what story it tells. Also explain how visual hierarchy is used on this visualization. You can copy and paste from your Packback assignment on this topic. 1-2 paragraphs.
29. Copy and Paste examples of two cartograms - one should be a standard Cartogram (where shapes are somewhat preserved) and one should be a Dorling Cartogram. Summarize what each data visualization communicates. 2 paragraphs.
30. Include a picture/song/YouTube Video that describes each of the following kinds of space (3 in total): Absolute Space, Relative Space, and Emotional Space. They can be personal examples - just explain why you chose them and how they are related to the definitions we discussed in class.
31. You wrote a love letter to Location Services in the last class. What would happen to us without them? Name at least one positive and one negative impact. 2-3 paragraphs.
32. Throughout the semester I explained that maps are representations of space. How is a map a representation of space? Use our discussions of choropleth map classification and projections to make your point.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Lab.rar