121 ass 2

PatientID Group
1 Diabetic
2 Diabetic
3 Diabetic
4 Diabetic
5 Diabetic
6 Diabetic
7 Diabetic
8 Diabetic
9 Diabetic
10 Diabetic
11 Diabetic
12 Diabetic
13 Diabetic
14 Diabetic
15 Diabetic
16 Diabetic
17 Diabetic
18 Diabetic
19 Diabetic
20 Diabetic
21 Diabetic
22 Diabetic
23 Diabetic
24 Diabetic
25 Diabetic
26 Diabetic
27 Diabetic
28 Diabetic
29 Diabetic
30 Diabetic
31 Diabetic
32 Diabetic
33 Diabetic
34 Diabetic
35 Diabetic
36 Diabetic
37 Diabetic
38 Diabetic
39 Diabetic
40 Diabetic
41 Diabetic
42 Diabetic
43 Diabetic
44 Diabetic
45 Diabetic
46 Diabetic

Sex
Male
Female
Female
Female
Male
Male
Male
Female
Female
Female
Male
Female
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Female
Male
Male
Female
Male
Female
Male
Male
Female
Female
Female
Male
Male
Female
Male
Male
Male
Male
Female
Male
Female

Age_year
49
52
52
43
57
57
55
53
44
52
52
49
54
58
70
56
57
54
40
55
55
75
53
57
55
46
64
61
61
48
66
44
60
73
47
50
56
51
43
56
47
59
48
67
49
52

BMI_kg/m²
32.3
31.3
27.9
31.7
26.3
28.2
27.3
29.3
37.1
22.5
31.4
23.4
27.3
32.8
29.2
25.2
26.5
31.4
26.4
29.8
29.2
26.7
36.5
31.2
21.9
29.7
26.7
32
26.2
28.6
30.8
32
24.8
27.8
27.3
26.7
35.2
30.4
24.6
32.2
36.4
32.6
23.7
27.3
33.4
26.5

47 Diabetic Male
48 Diabetic Male
49 Diabetic Male
50 Diabetic Male
51 Diabetic Female
52 Diabetic Female
53 Diabetic Female
54 Diabetic Female
55 Diabetic Female
56 Diabetic Female
57 Diabetic Male
58 Diabetic Male
59 Diabetic Male
60 Diabetic Male
61 Non-Diabetic
Male
62 Non-Diabetic
Male
63 Non-Diabetic
Female
64 Non-Diabetic
Male
65 Non-Diabetic
Male
66 Non-Diabetic
Male
67 Non-Diabetic
Male
68 Non-Diabetic
Female
69 Non-Diabetic
Male
70 Non-Diabetic
Female
71 Non-Diabetic
Female
72 Non-Diabetic
Male
73 Non-Diabetic
Male
74 Non-Diabetic
Female
75 Non-Diabetic
Female
76 Non-Diabetic
Female
77 Non-Diabetic
Female
78 Non-Diabetic
Male
79 Non-Diabetic
Male
80 Non-Diabetic
Male
81 Non-Diabetic
Female
82 Non-Diabetic
Female
83 Non-Diabetic
Male
84 Non-Diabetic
Male
85 Non-Diabetic
Male
86 Non-Diabetic
Male
87 Non-Diabetic
Female
88 Non-Diabetic
Female
89 Non-Diabetic
Female
90 Non-Diabetic
Male
91 Non-Diabetic
Male
92 Non-Diabetic
Female
93 Non-Diabetic
Female

62
45
57
65
42
56
57
61
45
44
59
57
57
58
40
47
47
40
58
48
37
50
38
51
53
39
52
48
51
58
43
40
39
39
44
47
47
51
45
55
43
64
49
39
38
48
43

30.6
31.7
25.8
28.8
17.7
25.4
28.1
24.6
34.7
24
27.5
29.5
34
24
28.5
25
22.1
26.4
25.6
23.2
25.2
23.8
25.3
27
29.8
21.3
31.4
19.1
24.5
26.8
25.8
23.1
24.4
23.5
23.2
27.5
26.1
22.9
27.7
25.9
27.4
26.9
22.5
23.3
27.2
26.8
24.9

94 Non-Diabetic
Female
95 Non-Diabetic
Female
96 Non-Diabetic
Male
97 Non-Diabetic
Male
98 Non-Diabetic
Male
99 Non-Diabetic
Male
100 Non-Diabetic
Male
101 Non-Diabetic
Male
102 Non-Diabetic
Female
103 Non-Diabetic
Male
104 Non-Diabetic
Male
105 Non-Diabetic
Female
106 Non-Diabetic
Male
107 Non-Diabetic
Male
108 Non-Diabetic
Female
109 Non-Diabetic
Male
110 Non-Diabetic
Male
111 Non-Diabetic
Male
112 Non-Diabetic
Male
113 Non-Diabetic
Female
114 Non-Diabetic
Female
115 Non-Diabetic
Female
116 Non-Diabetic
Female
117 Non-Diabetic
Female
118 Non-Diabetic
Male
119 Non-Diabetic
Female
120 Non-Diabetic
Male

50
48
44
39
34
42
51
46
36
46
48
39
46
45
37
48
49
53
52
35
38
49
49
49
72
49
53

25.4
28.8
23.2
26.6
24.4
24.3
28.3
27.5
27.4
28.9
25.1
27
24.1
26
24.6
25.3
26.8
22.5
31.3
22
21.4
28.5
27.4
26.9
26.9
25
22.3

FastingGlucose_mg/dL
151.9
133.1
174.4
146.3
129.4
142
160.3
135.9
129.4
156.1
156.1
137.3
138.2
155.8
113.8
114.8
132
144.7
157.8
186.9
171.4
146
149.5
124.9
149.5
142.8
158.1
129.3
163
188.3
147.3
160
167.3
140
155.6
150.3
152.4
130.7
150.6
162.4
186.3
174
203.8
130.8
171.8
154.6

204.7
129.8
129
135
96.9
136.9
131
153.8
158.5
196.9
173.8
135.6
127.5
162.3
75.2
122.5
112.7
88
69.3
115.3
93.3
113.6
71.1
86
95.1
95.7
88.2
104.3
79
92.9
96.8
102.7
105.7
78.1
72
114.2
100
83.8
118.3
96.7
112.7
96
125.9
121.3
91.3
109.6
104.7

115.5
80.5
105.3
110.9
68.6
77.3
64.4
91
105.8
117.5
96.1
119.4
74.3
69.4
94.2
100.8
94.5
64
93.7
75.4
105
100.5
80.9
87.3
79.1
94.1
109.3

College of Health Sciences
Department of Public Health

ASSIGNMENT
COVER SHEET
Course name

Applied Biostatistics

Course number

PHC 321

CRN

10785

Fasting Blood Glucose Levels in Diabetic and Non-Diabetic Adults:
A hypothetical dataset of sample size 120 has been generated to explore
differences in fasting blood glucose levels between diabetic and non-diabetic
adult patients (>30 years). Additional demographic and clinical variables such as
age, BMI, and sex are included for statistical illustration and analysis purposes.
Using the attached dataset, perform the following tasks in SPSS and answer
each question in a Word document: (2 points for each correct answer)

Assignment title or
task:
( write and questions)

1. Descriptive Statistics: Compute descriptive summary statistics (Mean,
Standard Deviation, Minimum, Maximum) for Age, BMI, and
FastingGlucose by Group.
2. Normality Test: Perform a normality test for fasting glucose in both
groups and determine whether the data follow a normal distribution.
3. Group Comparison: Define hypotheses and test for a significant
difference in mean fasting glucose between the two groups using the
appropriate statistical test (e.g., Independent Samples t-test or Mann–
Whitney U test).
4. Correlation Analysis: Test the correlation between Age and
FastingGlucose across all participants.
5. Interpretation and Reporting: Report and interpret your results for each
finding (3–4 lines), including summary staistics, test type, p-value, and
conclusion at a 5% significance level.

Student name:

XXXXX

Student ID #

XXXXX

Submission date:

XXXXX

Instructor name:
Grade:

Restricted – ‫مقيد‬

Dr. Shakir Saleem
out of 10

SPSS Guidelines:
• Enter the attached data into an SPSS spreadsheet and save the file as
“fasting_glucose_data.sav” and submit this file with the Word document.
• Submit your SPSS output tables/figure/screenshots.
• Ensure all variables are labeled correctly in SPSS.
Submission Guidelines:
•
•
•
•
•
•
•

The assignment must be submitted with properly filled cover sheet (Name, ID, Submission
date) in Word document, PDF is not accepted.
Avoid plagiarism. Any form of plagiarism will not be tolerated.
Font should be 12 Time New Roman and font color should be black.
Line spacing should be 1.5.
Word length should be 300, give or take 100 words..
References should be written in APA style; at least two up to date references should be used.
The assignment should be submitted on time by the end of week 11, that is, Saturday, 1511-2025 at 11:59 pm.
[Good Luck]

Restricted – ‫مقيد‬

Purchase answer to see full
attachment