Spatial Data and Quantitative Literacy Analysis

Spatial Data and Quantitative Literacy Analysis

Instructions/Descriptions

Spatial Data and Quantitative Literacy Analysis

Lab 7: Working with Spatial Data, Part 2

Learning Outcomes for Lab:

1. Summarize and analyze spatial data sets
2. Calculate mean in Excel
3. Calculate standard deviation in Excel
4. organize data for analysis
5. Explore functions in Excel
6. Explore/Explain the relationship between quantitative variables

Learning Outcomes for Quantitative Literacy:

• Understand quantitative models that describe real world phenomena and recognize limitations of those models;
• Perform simple mathematical computations associated with a quantitative model and make conclusions based on the results;
• Recognize, use, and appreciate mathematical thinking for solving problems that are part of everyday life;
• Understand the various sources of uncertainty and error in empirical data;
• Retrieve, organize, and analyze data associated with a quantitative model; and
• Communicate logical arguments and their conclusions.

1. Calculate the mean and standard deviation for the MINUTES variable.

Here, we will continue from last week’s lab to work with the survey data. If you haven’t already, download the Data for Lab Digital Mapping excel from lab #5. Open the file in Microsoft Excel. Recall that this file contains survey results.

Review the data table on the aata tab and the meanings and coding for the variables on the Dictionary tab.

Calculating Mean

To calculate the mean, go to the data table, and in the row underneath the last row containing data, in the cell under the MINUTES variable type the function

=AVERAGE(G2:G298)

[Order Now]

Note that the columns are labeled with letters, e.g. ‘G’ at the top of the table which serves as an identifier for that column/variable. The function ‘average’ indicates you are calculating the average and the text “G2:G298” indicates the range of cells for which to apply the average calculation.

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

To calculate the standard deviation, go to the data table, and in the row underneath the row containing the mean, under the MINUTES variable type the function

=stdev(G2:G298)

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

Question? Standard Deviation and Mean are summary statistics – they tell us something important about this complex array of numbers. Having calculated the mean and standard deviation please analyze the data set using SD and mean. Explain what they numbers tell us about the data set. Please recall our discussion from class to answer this question.

[Order Now]

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:

Question 3: Write a paragraph or two addressing the following questions: Is there a relationship between the importance of wealth question and the amount of minutes it takes for folks to get to work? Explain/analyze the relationship you showed in this table.

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).

Explain the relationship between the variables here…

Spatial Data and Quantitative Literacy Analysis

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!