7. In this exercise you will create sub-datasets using the neighborhood variable. Create a new sub-sample with the urban observations and a new sub-sample with the suburban observations for each of the following variables: (a) How often for Science/Environmental Studies? (b)How often for Health/Nutrition? (c) How often for Art? (d) How often for English/Language Arts/Reading? (e) How often for Social Studies? (f) How often for Math? (g) How often for Special Education? You should create two sub-datasets per subject; that is, a total of 14 sub-datasets. Hint: Consider using the Filter feature of Microsoft Excel to separate the urban observations from the suburban observations. That is, select the names of the variables where you want the filter to appear, then click on the Data tab in the menu bar at the top of the window, then click on the Filter button, then filter the observations and copy and paste the relevant data in a new worksheet within the same Excel document.

a. Make sure you submit all your newly created sub-datasets appropriately labeled. Delete the rows where there are missing responses in each of the newly created sub-datasets. (Points: 24.50)

b. Use the Data Analysis ToolPak from Microsoft Excel to test the hypotheses whether the mean of the urban neighborhood is different from the mean of the suburban neighborhood for each of the subject variables. Assume unequal population variances. Make sure you submit all new worksheet plies containing the Microsoft Excel results from the hypothesis testing appropriately labeled. Hint: Make sure you have the urban and the suburban observations for each of the subject variables in different columns but in the same worksheet. If the urban and suburban observations are in two different worksheets, then you will not be able to run the test using the Data Analysis ToolPak. (Points: 7)

c. Summarize the sample size, mean, and the p-values from part (b) from each of those subject variables in the following table. (Points: 10.50)

Table 6. Summary of Respondents' Perceptions Related to Frequency Use for Areas of Instruction by Type of Neighborhood (Urban or Suburban)

	Urban			Suburban				Two-sample t-test
Subject	n1	x1		n2	x2		P-value
Sci/Env Studies	?	?		?	?		?
Health/Nutrition	?	?		?	?		?
Art	?	?		?	?		?
Eng/Language	?	?		?	?		?
Social Studies	?	?		?	?		?
Math	?	?		?	?		?
Special Education	?	?		?	?		?

Scale: 0=never, 1=occasionally, 2=weekly, 3=daily