2 pages ppt

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)

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

Mean of the minutes is 17.81 which is 18 minutes (nearest to 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)?

Standard Deviation of minutes = 16.54 =17 (nearest to 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.

From the mean value of minutes above, it shows that on average it takes the people interviewed about 18 minutes to get to work from where they are staying. The standard deviation is 17. This means that there is no big difference between the minutes that most people take to get to work since the standard deviation is very close to the mean. The small standard deviation implies low variance among the minutes that takes most of the intervened people to get to work.

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	30	18
2	16	15
3	13	17
4	19	17
5	17	14

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.

I think there is no consistent relationship between importance of wealth and the amount of minutes that it takes folks to get to work. Generally, however, as the importance of wealth goes up the time it takes to get to work reduces. As for one w see the average number of minutes to be 30, while it is 17 minutes for those that are classified at point 5 with regards to importance of wealth. There is also a small standard deviation or all the wealth categories showing that people in every wealth category generally take almost the same average time to get to the job.

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	74	162

Explain the relationship between the variables here…

According to the data presented in the table above people in the wealth category 1 are currently at an average of 47 miles from where they grew up. People in this wealth category are the ones that are closest to where they grew up. People in wealth category 4, on the other hand, are the ones that are the ones that are currently further away from where they grew up by an average of 119 miles. This data also shows that there is no linear relationship between where someone group and they currently stay.