Digital map paper

Lab #8

Xiaoyu Xu

The data below are summarized from the Excel spreadsheet we have been using for the previous 2 labs.

1. Personally, count variable stands for how many people has been interviewed in this research.

2. The sum column represent the overall miles add together.

3. Because in the summary table we could easily know how many people has been involved in this research, the average of time they take to work and the overall miles they took. Can be more easy to figure out they relationship between each columns.

4. Answer the following the questions about the data table below

a) When the person is a very fan of Philly, they are more close to the location they were bore. The most interesting is when the how much fan of Philly question is answered in the middle, the sum of the miles they away from their home are the highest number.

b) 3

c) When people are choosing this category, they are more likely to move from their original home, because they are not eager to live there.

d) 1062

5. Answer the following questions about the data table below?

a) According to the data above, I don’t think there is any relationship between wealth and the average minutes. When the wealth increases the time they take not decrease.

b) 1

c) Five category is enough to cover all persons.

d) 13.5588

Part II - Create Your Own Summary Tables in Excel

1. Find two variables (from our Excel database) and copy and paste them next to each other in Excel.

I choose the Commute and Minutes.

2. Please sort the data by the variable on the left (the categorical/ordinal) data type

3. Highlight both columns and choose the Data Ribbon/Menu at the top of Excel.

Choose ‘subtotal’

Deliverable - Create a table that has each category (in this case 1,2,3) and the average number of (minutes in this case). (Submit a table like the one below)

It should look like this:

Deliverable - Finally – create a chart or graph that shows your averages for each category. Think about the histogram we created a couple of labs ago. (Submit a chart, graph, or histogram)

Part III - Visualize Points in Map Shaper

Navigate here

Deliverable: Take a screenshot of your map and paste it here. (Screenshot of the map you created by importing files into mapshaper)

Answer this question –

Most of the interviews are located at South part of Philadelphia.

Answer this question –

I think is the longitudes and latitudes information.

Part IV – Experimenting with Density and Creating a Choropleth Map

Deliverable (using blank map below) - Based on the map you made in map shaper choose a light color for areas in which there aren’t many interviews, a medium color for areas that have some neighborhoods, and a dark color for areas that are highly concentrated. These three colors should fill the map AND THEY SHOULD BE IN THE SAME COLOR SCHEME (blue or green or red etc). You can be pretty broad/general with your assessment, you don’t have to keep switch back and forth between colors. This isn’t correct – but it might look something like this:

Visit this website

Last Question:

Fairmount, University City

Average

11.809917355371901 22.514285714285716 21.329411764705881