Chapter 7
Module 2Manipulating data
7.3Select cases
Imagine Femke and Jery want to do some of calculations for just a part of their sample. In this example we select two of the schools that were visited by the researchers, school 1 and school 2. Also, say we just want to compare responses of the female participants between 15 and 18 year old. To do this, you need to use the SELECT CASES procedure described in section 7.5.3 of Chapter 7. Using these criteria, calculate the average scores for the two schools on the new variable you made under Assignment 7.2. To do this for the two schools separately, go to ANALYZE, COMPARE MEANS, MEANS, enter the variable “total” in DEPENDENT LIST, and “schools” in INDEPENDENT LIST. Include the results in your report (that is: mean and standard deviation for the two school separately).
This will be a procedure that will reveal its use in practice, too. Imagine you want to do calculations for just a part of the sample. In this example we select two of the schools that were visited by the researchers, school 1 and 2. Also, say you just want to compare responses of the female participants between 15 and 18 year old. To do this, you need to use the SELECT CASES procedure described in section 7.3. Using these three criteria, calculate the average scores for the two schools on the new variable you made under assignment 2. To do this for the two schools separately, go to ANALYZE, COMPARE MEANS, MEANS, enter the variable “total” in DEPENDENT LIST, and “school” in INDEPENDENT LIST. Include the result in your report (that is mean and standard deviation for the two schools separately).
Solution
| Report | |||
|---|---|---|---|
| arthous1 | |||
| school | Mean | N | Std. Deviation |
| 1.00 | 1.9333 | 30 | 1.11211 |
| 2.00 | 1.3667 | 30 | .61495 |
| Total | 1.6500 | 60 | .93564 |
If this table is the result of your steps, this is probably what you did; you opened the following dialog box, and selected “If condition is satisfied”.
Next you entered the following formula: