Fulton-Montgomery Community College Diabetes chart
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →For this assignment, you will apply knowledge learned thus far in the course to analyzing data and creating visualizations of that analysis with regard to subjects of a diabetes study.
First, analyze the data and answer the following questions:
- What are the average, minimum, and maximum ages of the subjects?
- What are the average, minimum, and maximum BMIs of the subjects?
- What are the average number of sick visits for subjects with diabetes?
- What percentage of diabetics are taking medication?
- What percentage of non-diabetics’ exercise?
Second, create visualizations that presents five analyses of the data. Be sure you include percentage of subjects by BMI category and percentage of diabetics who are overweight or obese, plus any three other aspects of your choosing.
The data below is a subset from a diabetes study.
|
Subject |
Age |
Gender |
BMI |
Diabetes |
Medication |
Exercise |
Sick Visits |
|
001 |
25 |
M |
28.8 |
Y |
Y |
N |
3 |
|
002 |
32 |
M |
17.9 |
N |
N |
Y |
0 |
|
003 |
44 |
F |
20.3 |
N |
N |
Y |
2 |
|
004 |
31 |
M |
25.1 |
Y |
N |
N |
4 |
|
005 |
66 |
F |
22.2 |
N |
N |
Y |
1 |
|
006 |
53 |
F |
31.1 |
Y |
Y |
N |
2 |
|
007 |
47 |
F |
26.6 |
N |
N |
N |
7 |
|
008 |
28 |
M |
27.6 |
Y |
Y |
Y |
0 |
|
009 |
32 |
F |
32.7 |
Y |
Y |
N |
1 |
|
010 |
43 |
U |
28.9 |
Y |
N |
N |
2 |
|
011 |
29 |
M |
27.2 |
N |
N |
N |
1 |
|
012 |
33 |
M |
27.2 |
Y |
Y |
Y |
5 |
|
013 |
33 |
M |
18.6 |
N |
N |
N |
1 |
|
014 |
27 |
F |
18.6 |
Y |
N |
Y |
3 |
|
015 |
37 |
M |
27.5 |
Y |
Y |
N |
0 |
|
016 |
47 |
M |
31.1 |
N |
N |
N |
3 |
|
017 |
57 |
M |
24.3 |
N |
N |
N |
2 |
|
018 |
55 |
U |
31.3 |
Y |
Y |
N |
2 |
|
019 |
41 |
U |
26.4 |
Y |
Y |
Y |
1 |
|
020 |
30 |
F |
28.8 |
Y |
N |
Y |
6 |
|
021 |
40 |
M |
33.3 |
Y |
Y |
Y |
0 |
|
022 |
38 |
M |
16.6 |
N |
N |
N |
0 |
|
023 |
44 |
F |
23.7 |
Y |
N |
Y |
1 |
|
024 |
69 |
M |
27.4 |
Y |
Y |
Y |
2 |
|
025 |
62 |
M |
18.7 |
N |
N |
Y |
4 |
|
026 |
57 |
U |
18.9 |
Y |
Y |
Y |
4 |
|
027 |
49 |
M |
34.4 |
Y |
Y |
N |
0 |
|
028 |
33 |
M |
25.1 |
N |
N |
N |
1 |
|
029 |
29 |
F |
29.1 |
Y |
N |
N |
2 |
|
030 |
50 |
M |
31.2 |
Y |
Y |
Y |
2 |
|
Category |
BMI |
|
Underweight |
< 18.5 |
|
Normal |
18.5-24.9 |
|
Overweight |
25.0-29.9 |
|
Obese |
≥ 30.0 |
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds