Digital map paper

Xiaoyu Xu

Lab 7: Working with Spatial Data, Part 2

Question 1: What is the mean of the MINUTES variable (to the nearest whole minute)?

Mean＝ 18

Question 2? What is the standard deviation of the MINUTES variable (to the nearest whole minute)?

Standard deviation= 17

2. Calculate the mean and standard deviation of MINUTES for each value of WEALTH.

Here you will create a table that reports the mean and standard deviation (to the nearest whole number) of MINUTES for each value of WEALTH. Select all and then under the sort & filter tab select “custom sort.” Add a level, then select first to sort by WEALTH, then MINUTES. Complete the table below:

Wealth Variable	Average for each wealth category for Minutes	Standard Deviation for each wealth category for Minutes
1	31	18
2	16	15
3	13	17
4	19	17
5	17	14

Question 3:

According to the data in Excel, I don’t think there is any connections between the importance of wealth question and the amount of minutes it takes for folks to get to work. Because when choosing the same minutes, there will be different numbers showing on the wealth question.

3. Investigate another relationship between variables in the data set

Question 4: Investigate whether a nominal or ordinal variable of your choosing in the data set has a relationship with MILES. To do this, use the same approach you used to investigate whether the mean and standard deviation of MINUTES differed for different values of WEALTH. In your answer, be sure to include a table that expresses the mean and standard deviation of MILES for different values of the nominal or ordinal variable you choose. Then, explain in a paragraph if you think there is a relationship between MILES and the other variable, the evidence for this relationship relating to the differences in mean and/or standard deviation, and why you think the relationship exists (or doesn’t exist).

Wealth Variable	Average for each wealth category for Miles	Standard Deviation for each wealth category for Miles
1	47	49
2	72	107
3	85	160
(4) Use only for ordinal	119	226
(5) Use only for ordinal	72	160

Explain the relationship between the variables here…

Personally, I think there exist relationship between wealth variable and miles. Because when the wealth variable goes up the miles is increased as well. Maybe is because when you have a long distance get to work, you will be more eager to be wealth.