SPSS PRACTICE: SETTING UP A DATA SET

profileloftonl007
cf_emotional_well-being_SF-36_corrected.xlsx

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