Digital map paper
x825358746
lab6XiaoyuXu1.docx
1. Please list the questions asked in this survey.
If you toggle in between the data and dictionary tabs you will see that the column names and values in data correspond to questions in the dictionary.
For example, for the Phillies question, it tells us that we can expect values to range from 1 through 5. This is called an ordinal variable because we can rank values but we can’t tell the magnitude of size difference between variables.
2. What is nominal data?
a. How are the answers to the question “Where are you from (did you grow up)?” an example of nominal data?
Nominal data is a type of data that is used to label variables without providing any quantitative value. Because “where are you from” is a variable question will having variable answers which cannot be measured.
3. What is ratio data?
a. How are the answers “How many minutes does it typically take you to get to work” an example of ratio data?
Ratio Data is defined as a quantitative data. Because the answers in this question are all numbers which is a quantitative data.
4. Create a question to add to the survey. Once you have formulated a question for the survey – please tell us what type of data it is (nominal, ordinal, or ratio) Explain why you chose the data type – what was your decision making process like. What about the answers to this question told that it would be nominal, ordinal, or ratio?
How many years have you been in the USA? The answer of this question is ratio data, because the answer of this question are all numbers which is quantitative.
Step 3 Basic Data Analysis (Back to the Excel table)
Back to the data tab in ‘ Digital Mapping Lab #6 Excel Data’
5. How many people were interviewed?
297 people.
Hint: Starting with row 2 (row 1 is just titles), highlight the lon column by left clicking, holding the click, and dragging down to the end of the data on the sheet. In the bottom right hand corner In Excel you should see something like this
. This is not the answer of course, but this count tool will tell you how many cases you have highlighted – you will use this tool later in this lab when you calculate a frequency table.
Draw your attention to the commute variable
6. How many survey respondents commute to work by public transportation?
3
Draw your attention to the minutes variable
7. What percentage of the survey respondents take 10 minutes or less to get to work?
91.6%
Hint: To calculate a percentage divide the total number of people who take less than 10 minutes to commute to work by the total number of people who were interviewed/surveyed – then multiply by 100.
Locate information based on Lat Lon coordinates
8. According to the survey, where did the person at the location 39.9230,
-75.161567 grow up?
Grow up in city of Philadelphia.
9. According to the survey, how big of a Phillies fan is the person interviewed at the location 39.9854, 75.16007
In this location is 5.
10. Recall how we measured Latitude and Longitude in Lab 5. Covert the lat/lon from question 9 to degrees minutes seconds.
39° 59' 7.44", 75° 9' 36.25"
Calculate Frequencies and Create Histograms for a Nominal Variable
Here, you will calculate frequencies for the COMMUTE variable.
11. Sort the COMMUTE column and then count the frequency of each value (below)
|
Variable |
Value |
Code |
Frequency |
|
COMMUTE |
Walk/Bike |
1 |
121 out of 297 |
|
|
Drive |
2 |
91 out of 297 |
|
|
Public Trans |
3 |
85 out of 297 |
Count how many #1’s there are under the Commute Variables and enter it next to code 1 under the frequency table.
Do the same thing for 2 and 3.
You can count using a technique I taught you earlier in the lab.
12. Based on your frequency table what is the most common mode of transportation for folks trying to get to work?
Bike is the most common mode of transportation for folks trying to get to work.
13. What is the least common mode of transportation for folks trying to get to work?
Least common mode of transportation is taking public trans.
Histograms
14. Here, you will create a histogram that graphically displays the frequencies of the COMMUTE values.
Copy and paste your completed frequency table into excel
In Excel, select the three frequency values (ONLY THE FREQUENCY VALUES) for COMMUTE that you calculated on the frequency table above, go to the Insert menu tab, choose “Column,” and under “2-D Column,” choose “Clustered Column.”
Copy and paste the histogram here:
It should look something like this (with different values obviously)
Map the Data!
Open the Spreadsheet in Canvas – Map these Data
You can see that this is a simplified version of our data.
Go to the application
Delete these data
Copy and Paste the Data from Map these Data into this box on the application
Paste them into the area where you deleted data (Above)
Click Map!
15. Zoom into Philadelphia and take a snip of your map
16. What part(s) of the city contain the most markers? Please use the map below to pick one or two neighborhoods that answer this question.
The south part contain the most markers.
The last legend column is the miles category from the first excel document.
17. There is marker right to the West of Broad Street on Cecil B. Moore – How far is it from this location to where the person indiciated by the marker grew up?
It is 50 miles from the this location.
18. Finally – I used the sample data from the website to influence the color and marker type. Please take a snip of a map that has the same data but has atleast 5 different markers and colors – for example…
Hint: The application tells you how to do this!
Walk/Bike Drive Public Trans COMMUTE 1 2 3 Walk/Bike Drive Public Trans COMMUTE 121 91 85
45 67 87
COMMUTE -75.16007 39.9854 2 GROWUP -75.16007 39.9854 1 WEALTH -75.16007 39.9854 5 PHILLIES -75.16007 39.9854 3 MINUTES -75.16007 39.9854 10 MILES -75.16007 39.9854 33
6
