SPSS PRACTICE: SETTING UP A DATA SET
Sheet2
| Row Labels | Count of Gender (0=M, 1=F) |
| Female | 51.39% |
| Male | 48.61% |
| Grand Total | 100.00% |
Percentage Totals
Total Female Male 0.51388888888888884 0.4861111111111111
Sheet3
| Row Labels | Count of Gender (0=M, 1=F) |
| Female | 51.39% |
| Male | 48.61% |
| Grand Total | 100.00% |
Total Female Male 0.51388888888888884 0.4861111111111111
Sheet5
| Row Labels | Count of Age (yrs) |
| 19-28 | 15% |
| 29-38 | 10% |
| 39-48 | 13% |
| 49-58 | 15% |
| 59-68 | 19% |
| 69-78 | 19% |
| 79-88 | 8% |
| Grand Total | 100.00% |
Study population age groups
(percentage of total)
Total 19-28 29-38 39-48 49-58 59-68 69-78 79-88 0.15277777777777779 9.7222222222222224E-2 0.125 0.15277777777777779 0.19444444444444445 0.19444444444444445 8.3333333333333329E-2
Sheet1
| Patient No | Age (yrs) | Gender (0=M, 1=F) | Race (1=AA, 2=C, 3=H) | BMI | Dietary treatment (1=Std, 2=veg) | Basline SF-36 Well-Being Score | Post-Tx Well-Being |
| 1 | 45 | Male | 1 | 27 | Standard | 65 | 66 |
| 2 | 55 | Male | 3 | 36 | Vegetarian | 71 | 45 |
| 3 | 26 | Female | 2 | 35 | Standard | 58 | 87 |
| 4 | 39 | Female | 3 | 32 | Standard | 80 | 95 |
| 5 | 79 | Female | 1 | 43 | Vegetarian | 62 | 77 |
| 6 | 27 | Male | 3 | 24 | Vegetarian | 58 | 100 |
| 7 | 78 | Male | 1 | 24 | Vegetarian | 62 | 58 |
| 8 | 60 | Male | 3 | 43 | Standard | 28 | 40 |
| 9 | 66 | Female | 3 | 30 | Vegetarian | 13 | 83 |
| 10 | 75 | Female | 1 | 32 | Standard | 56 | 56 |
| 11 | 51 | Male | 3 | 33 | Vegetarian | 74 | 77 |
| 12 | 71 | Female | 1 | 22 | Standard | 96 | 99 |
| 13 | 57 | Female | 2 | 43 | Standard | 55 | 68 |
| 14 | 59 | Female | 3 | 29 | Vegetarian | 79 | 42 |
| 15 | 68 | Male | 1 | 27 | Vegetarian | 44 | 40 |
| 16 | 79 | Female | 1 | 36 | Vegetarian | 15 | 93 |
| 17 | 36 | Male | 1 | 31 | Standard | 79 | 82 |
| 18 | 21 | Female | 2 | 26 | Standard | 62 | 49 |
| 19 | 33 | Male | 1 | 29 | Standard | 68 | 98 |
| 20 | 78 | Male | 1 | 26 | Vegetarian | 82 | 79 |
| 21 | 43 | Female | 3 | 41 | Vegetarian | 44 | 71 |
| 22 | 65 | Female | 3 | 39 | Standard | 36 | 64 |
| 23 | 84 | Female | 3 | 37 | Standard | 52 | 66 |
| 24 | 37 | Female | 3 | 26 | Standard | 48 | 72 |
| 25 | 75 | Female | 3 | 43 | Standard | 74 | 65 |
| 26 | 51 | Male | 3 | 23 | Standard | 23 | 78 |
| 27 | 46 | Male | 3 | 40 | Vegetarian | 30 | 65 |
| 28 | 51 | Male | 2 | 26 | Vegetarian | 80 | 74 |
| 29 | 23 | Male | 1 | 41 | Vegetarian | 55 | 71 |
| 30 | 66 | Female | 2 | 39 | Vegetarian | 63 | 78 |
| 31 | 45 | Female | 2 | 26 | Standard | 12 | 88 |
| 32 | 70 | Male | 3 | 43 | Standard | 56 | 60 |
| 33 | 70 | Male | 3 | 26 | Standard | 61 | 75 |
| 34 | 40 | Male | 2 | 41 | Standard | 63 | 88 |
| 35 | 54 | Female | 3 | 26 | Vegetarian | 92 | 93 |
| 36 | 26 | Female | 2 | 41 | Standard | 64 | 60 |
| 37 | 68 | Female | 3 | 30 | Vegetarian | 35 | 80 |
| 38 | 46 | Male | 3 | 35 | Standard | 62 | 70 |
| 39 | 77 | Male | 1 | 42 | Standard | 43 | 43 |
| 40 | 84 | Female | 3 | 23 | Standard | 42 | 79 |
| 41 | 50 | Female | 3 | 41 | Standard | 64 | 50 |
| 42 | 77 | Male | 3 | 43 | Standard | 7 | 56 |
| 43 | 43 | Female | 2 | 36 | Standard | 31 | 74 |
| 44 | 27 | Female | 3 | 31 | Standard | 45 | 41 |
| 45 | 64 | Female | 3 | 27 | Vegetarian | 9 | 62 |
| 46 | 83 | Male | 3 | 33 | Standard | 11 | 45 |
| 47 | 29 | Male | 2 | 24 | Vegetarian | 28 | 41 |
| 48 | 75 | Female | 2 | 32 | Vegetarian | 35 | 56 |
| 49 | 77 | Male | 3 | 29 | Standard | 68 | 71 |
| 50 | 75 | Female | 1 | 38 | Vegetarian | 65 | 91 |
| 51 | 73 | Female | 1 | 37 | Vegetarian | 48 | 78 |
| 52 | 61 | Female | 2 | 26 | Standard | 85 | 87 |
| 53 | 64 | Male | 3 | 24 | Standard | 24 | 96 |
| 54 | 63 | Female | 3 | 40 | Vegetarian | 48 | 56 |
| 55 | 23 | Male | 3 | 39 | Standard | 43 | 80 |
| 56 | 77 | Male | 2 | 37 | Standard | 22 | 90 |
| 57 | 83 | Male | 2 | 42 | Standard | 46 | 85 |
| 58 | 55 | Male | 3 | 22 | Standard | 21 | 78 |
| 59 | 21 | Female | 2 | 37 | Standard | 49 | 42 |
| 60 | 19 | Male | 2 | 36 | Standard | 53 | 75 |
| 61 | 36 | Male | 2 | 32 | Standard | 42 | 100 |
| 62 | 52 | Male | 2 | 34 | Standard | 78 | 93 |
| 63 | 63 | Female | 3 | 40 | Vegetarian | 57 | 52 |
| 64 | 52 | Female | 1 | 25 | Standard | 46 | 95 |
| 65 | 34 | Male | 2 | 32 | Vegetarian | 43 | 91 |
| 66 | 26 | Female | 3 | 36 | Standard | 10 | 51 |
| 67 | 62 | Male | 1 | 37 | Standard | 21 | 52 |
| 68 | 39 | Male | 3 | 22 | Vegetarian | 22 | 99 |
| 69 | 27 | Female | 1 | 27 | Vegetarian | 75 | 96 |
| 70 | 60 | Male | 2 | 37 | Vegetarian | 28 | 71 |
| 71 | 37 | Female | 3 | 33 | Standard | 67 | 56 |
| 72 | 57 | Female | 2 | 36 | Standard | 40 | 93 |