Assignment:
With the help of below table solve the following:
Nutrition
The food-frequency questionnaire (FFQ) is an instrument often used in dietary epidemiology to assess consumption of specific foods. A person is asked to write down the number of servings per day typically eaten in the past year of over 100 individual food items. A food- composition table is then used to compute nutrient intakes (protein, fat, etc.) based on aggregating responses for individual foods. The FFQ is inexpensive to administer but is considered less accurate than the diet record (DR) (the gold standard of dietary epidemiology). For the DR, a participant writes down the amount of each specific food eaten over the past week in a food diary and a nutritionist using a special computer program computes nutrient intakes from the food diaries. This is a much more expensive method of dietary recording. To validate the FFQ, 173 nurses participating in the Nurses' Health Study completed 4 weeks of diet recording about equally spaced over a 12- month period and an FFQ at the end of diet recording [11]. Data are presented for saturated fat, total fat, total alcohol consumption, and total caloric intake for both the DR and FFQ. For the DR, average nutrient intakes were computed over the 4 weeks of diet recording.
Q1: Use descriptive statistics to relate nutrient intake for the DR and FFQ. Do you think the FFQ is a reasonably ac-curate approximation to the DR? Why or why not?
Q2) A frequently used method for quantifying dietary intake is in the form of quintiles. Compute quintiles for each nutrient and each method of recording, and relate the nutrient composition for DR and FFQ using the quintile scale. (That is, how does the quintile category based on DR relate to the quintile category based on FFQ for the same individual?) Do you get the same impression about the concordance between DR and FFQ using quintiles as in Problem 2.27, in which raw (ungrouped) nutrient intake is considered? In nutritional epidemiology, it is customary to assess nutrient intake in relation to total caloric intake. One measure used to accomplish this is nutrient density, which is defined as 100% × (caloric intake of a nutrient/ total caloric intake). For fat consumption, 1 g of fat is equivalent to 9 calories.
These are 5x5 tables that you create to show the number of people classified into a particular combination of quintile categories. For each table the rows represent the quintiles of the DR and the columns represent quintiles of the FFQ. Look to see whether there is a weak or strong concordance between the measures and whether there is agreement for the measures.
Variable Column Description Format or Code
Id 1-6 ID number
sfat_dr 8-15 Saturated fat-DR XXXXX.XX
sfat_ffq 17-24 Saturated fat-FFQ XXXXX.XX
tfat_dr 26-33 Total fat-DR XXXXX.XX
tfat_ffq 35-42 Total fat-FFQ XXXXX.XX
alco_dr 44-51 Alcohol consumption-DR XXXXX.XX
alco_ffq 53-60 Alcohol consumption-FFQ XXXXX.XX
cal_dr 62-70 Total calories-DR XXXXXX.XX
cal_ffq 72-80 Total calories-FFQ XXXXXX.XX
Id |
sfat_dr |
sfat_ffq |
tfat_dr |
tfat_ffq |
alco_dr |
alco_ffq |
cal_dr |
cal_ffq |
100396 |
33.2 |
21.2 |
81.15 |
53.8 |
8.26 |
1.68 |
1807 |
1242.2 |
100566 |
17.73 |
10.6 |
53.28 |
36.6 |
0.83 |
0 |
1418 |
907 |
107633 |
38.73 |
23.8 |
83.48 |
47.2 |
20.13 |
15.1 |
1889 |
786 |
107737 |
21.57 |
22.7 |
49.65 |
55.3 |
11.16 |
7.49 |
1426 |
1392.5 |
107744 |
21.35 |
30.4 |
55.18 |
71 |
7.18 |
12.84 |
1253 |
1259.8 |
107813 |
28.04 |
15.1 |
73.83 |
41.1 |
1.76 |
0 |
1699 |
987.1 |
107825 |
23.17 |
17.8 |
68.29 |
49.1 |
22.66 |
25.06 |
1700 |
1189.9 |
107879 |
19.73 |
19.1 |
58.3 |
48.9 |
0 |
0 |
1369 |
1364.1 |
108618 |
36.31 |
23.4 |
92.58 |
55.4 |
0 |
0 |
2163 |
1311.4 |
109000 |
20.87 |
16 |
68.44 |
44.2 |
0 |
0 |
1609 |
1200.6 |
109259 |
26.4 |
19.4 |
69.16 |
46.6 |
4.75 |
1.06 |
1704 |
1227.4 |
109565 |
28.26 |
27.4 |
79.42 |
59.7 |
4.57 |
1.81 |
1884 |
1448.1 |
109856 |
19.81 |
15.8 |
69.59 |
50.5 |
15.12 |
11.14 |
1518 |
1367.7 |
109885 |
23.48 |
19.9 |
65.86 |
55.6 |
5.37 |
2.57 |
1450 |
1154.4 |
109908 |
25.62 |
17.4 |
74.22 |
51.7 |
0 |
0 |
1702 |
1217.7 |
110108 |
23.59 |
9.5 |
63.44 |
23.4 |
1.89 |
0.76 |
1400 |
483.4 |
110360 |
14.6 |
20.9 |
38.14 |
46.9 |
0.78 |
5.7 |
910 |
1056.5 |
110406 |
20.71 |
27.7 |
49.77 |
70.1 |
8.09 |
10.56 |
1332 |
1265.3 |
110419 |
28.63 |
15.3 |
80.73 |
35.3 |
37.9 |
35.34 |
1947 |
890.1 |
110483 |
18.12 |
20.7 |
53.56 |
55.7 |
2.22 |
0.76 |
1428 |
1378.5 |
110579 |
16.93 |
17.6 |
52.75 |
51.5 |
20.69 |
18.22 |
1557 |
1317.5 |
110714 |
25.1 |
18.9 |
80.15 |
57.5 |
0 |
0 |
1788 |
1257.5 |
111040 |
14.04 |
14.9 |
39.4 |
37 |
2.62 |
1.68 |
1098 |
1087.8 |
111220 |
21.98 |
32.6 |
54.91 |
73.2 |
9.49 |
6.49 |
1362 |
1589.6 |
111536 |
24.83 |
24 |
67.73 |
63.1 |
9.69 |
16.72 |
1562 |
1422.7 |
111538 |
20.72 |
15.6 |
55.24 |
47.6 |
0.95 |
1.51 |
1286 |
1569.6 |
111799 |
24.61 |
24.2 |
68.11 |
54.4 |
3 |
2.74 |
1529 |
1386 |
111970 |
32.03 |
38.2 |
71.02 |
98.8 |
37.28 |
45.08 |
1810 |
2220 |
112071 |
23.49 |
18.8 |
63.72 |
55.8 |
21.78 |
33.49 |
1606 |
1291.4 |
112087 |
25.69 |
23.5 |
67.99 |
68 |
15.41 |
12.91 |
1363 |
1102 |
112163 |
23.65 |
21.3 |
64.61 |
46.8 |
7.85 |
0.76 |
1457 |
943.2 |
112226 |
23.45 |
13.9 |
60.13 |
31.8 |
0.39 |
0 |
1233 |
731.4 |
112650 |
46.36 |
33.3 |
104.91 |
88.1 |
29.81 |
64.75 |
2285 |
1878.9 |
112738 |
16.04 |
17.6 |
44.23 |
40.6 |
0 |
0 |
1183 |
1326.6 |
112812 |
38.68 |
17.8 |
98.14 |
55.8 |
6.77 |
2.57 |
2176 |
1635.4 |
112862 |
24.1 |
15.9 |
64.21 |
41.5 |
5.97 |
2.74 |
1587 |
1035.5 |
112896 |
27.92 |
16.7 |
91.37 |
53.5 |
0.85 |
0 |
2029 |
1548.3 |
112982 |
26.26 |
24.1 |
70.44 |
61.9 |
5.23 |
5.7 |
1484 |
1376.3 |
113429 |
26.46 |
21 |
76.06 |
57.7 |
2.26 |
2.11 |
1685 |
1460.5 |
113436 |
22.02 |
19.5 |
61.13 |
63.8 |
7.79 |
1.06 |
1440 |
1970.2 |
113441 |
24.51 |
25.9 |
62.6 |
60.7 |
7.75 |
11.14 |
1293 |
1350.3 |
113525 |
20.06 |
16.1 |
55.5 |
49.9 |
10.86 |
10.75 |
1433 |
1326.3 |
113613 |
34.14 |
38.5 |
93.04 |
93.5 |
22.44 |
11.38 |
2333 |
2253.5 |
113882 |
24.38 |
18.2 |
67.02 |
48.7 |
4.49 |
12.06 |
1402 |
1139.9 |
114053 |
14.38 |
5.6 |
41.09 |
14.8 |
5.2 |
4.55 |
923 |
463.2 |
114129 |
17.74 |
15.2 |
54.07 |
48.4 |
0.38 |
0.76 |
1330 |
1498.4 |
114353 |
27.83 |
16.5 |
78.26 |
36.7 |
5.17 |
3.79 |
1731 |
946.7 |
114865 |
29.17 |
24.8 |
84.52 |
71.1 |
0 |
0 |
1636 |
1396.7 |
115013 |
15.94 |
12.8 |
45.89 |
38 |
22.89 |
8.64 |
1311 |
1078.4 |
115223 |
28.33 |
27.2 |
75.96 |
88.4 |
2.93 |
0.76 |
1769 |
1996.8 |
115399 |
15.18 |
11.6 |
49.44 |
30.7 |
0.05 |
0 |
1481 |
1051.9 |
115512 |
22.51 |
31.2 |
68.28 |
78.7 |
4.75 |
5.7 |
1649 |
2100.3 |
115601 |
46.01 |
17.4 |
119.83 |
49.5 |
10.12 |
5.57 |
2334 |
988.7 |
115724 |
27.15 |
16.9 |
80.54 |
37.7 |
17.9 |
8.93 |
1823 |
1025.7 |
115764 |
25.47 |
15.8 |
75.54 |
41.6 |
0 |
1.81 |
1548 |
1259.6 |
115806 |
27.99 |
17.5 |
69.13 |
40.7 |
3.35 |
0.76 |
1456 |
825.1 |
115822 |
25.28 |
17 |
68.36 |
48.6 |
10.04 |
2.87 |
1535 |
1047 |
115875 |
26.58 |
14.8 |
77.83 |
40.1 |
17.27 |
15.86 |
1718 |
726.9 |
115879 |
28.72 |
35.8 |
74.26 |
76 |
0 |
0 |
1641 |
1961.6 |
116007 |
24.62 |
34.6 |
66.12 |
66 |
8.15 |
13.76 |
1402 |
1434.4 |
116164 |
26.46 |
18 |
78.2 |
48.8 |
27.55 |
34.42 |
2143 |
1464.4 |
116263 |
29.57 |
14.4 |
69.8 |
33.5 |
0.6 |
0 |
1490 |
768.7 |
116413 |
20.39 |
23.7 |
48.85 |
56.5 |
22.31 |
12.06 |
1221 |
1698.5 |
116461 |
14.68 |
13.6 |
52.24 |
40.3 |
4.4 |
2.11 |
1255 |
758.3 |
116528 |
23.43 |
25.6 |
71.16 |
62.4 |
1.99 |
0.76 |
1555 |
1462 |
129518 |
20.74 |
23.7 |
61.82 |
68.8 |
0 |
0 |
1374 |
1592.4 |
129729 |
21.76 |
19.3 |
63.73 |
56.3 |
0.38 |
0 |
1593 |
1661.5 |
129732 |
21.58 |
13.8 |
64.25 |
40.9 |
0.8 |
1.81 |
1491 |
1249.3 |
129743 |
39.3 |
32.7 |
109.83 |
78.5 |
0.14 |
0.76 |
2505 |
2282.1 |
129765 |
21.95 |
21 |
59.74 |
52.9 |
12.03 |
10.75 |
1560 |
1152.1 |
129813 |
21.9 |
11.9 |
67.87 |
38.3 |
10.35 |
3.63 |
1661 |
979.9 |
130757 |
28.65 |
13.6 |
78.99 |
41 |
5.84 |
0.76 |
1742 |
1253 |
130786 |
30.01 |
33.4 |
79.13 |
82.8 |
17.22 |
12.99 |
1680 |
1799.2 |
130793 |
29.35 |
23.9 |
98.96 |
75.6 |
5.97 |
4.64 |
2096 |
1873.2 |
130847 |
21.56 |
8.8 |
72.02 |
34.6 |
2.79 |
0 |
1438 |
811.8 |
130863 |
18.83 |
40.6 |
54.78 |
100 |
20.5 |
37.75 |
1325 |
1940.4 |
131023 |
36.16 |
18.5 |
100.56 |
52.6 |
8.65 |
4.55 |
2051 |
1219.8 |
131100 |
31.2 |
29.3 |
92.12 |
70.5 |
10.41 |
16.72 |
2050 |
1644.5 |
131126 |
29.06 |
23.5 |
80.52 |
67.9 |
7.12 |
6.76 |
1707 |
1933.5 |
131129 |
21.79 |
14.6 |
68.42 |
45.2 |
12.97 |
16.06 |
1502 |
1120.8 |
132293 |
29.6 |
30.3 |
70.98 |
78.9 |
8.75 |
4.64 |
1691 |
1470.5 |
132303 |
12.71 |
12.1 |
35.9 |
32.3 |
3.45 |
1.51 |
940 |
842.3 |
132316 |
22.16 |
14.8 |
70.33 |
45.6 |
3.11 |
0.76 |
1591 |
1156.4 |
132327 |
22.61 |
13.8 |
65.19 |
34.6 |
2.69 |
0.76 |
1769 |
1539.8 |
132328 |
27.08 |
18.8 |
70.95 |
43.7 |
49.15 |
27.75 |
2054 |
1330.9 |
132361 |
17.92 |
15.2 |
49.72 |
41.9 |
0.57 |
0 |
1514 |
1509.9 |
132382 |
31.41 |
30.4 |
90.21 |
74.1 |
31.26 |
11.14 |
1989 |
1506.5 |
132390 |
33.25 |
25.8 |
87.69 |
73.9 |
11.13 |
11.38 |
1968 |
1795.5 |
132426 |
32.19 |
54.9 |
86.35 |
133.5 |
4.67 |
2.87 |
1781 |
2263.5 |
132621 |
25.17 |
7.5 |
70.2 |
18.4 |
15.69 |
11.14 |
1761 |
513.6 |
132622 |
34.34 |
19 |
86.68 |
44.7 |
23.44 |
43.75 |
1639 |
1124.7 |
132624 |
25.11 |
24.2 |
69.86 |
63.1 |
4.6 |
16.72 |
1445 |
1340.3 |
132638 |
45.31 |
47.1 |
106.4 |
93.8 |
0.03 |
0 |
2260 |
2047.8 |
132662 |
18.59 |
12.5 |
45.37 |
29.5 |
19.38 |
29.92 |
1107 |
811.1 |
133002 |
28.34 |
35.5 |
71.45 |
80 |
0.77 |
0 |
1878 |
2136 |
133079 |
18.75 |
11.8 |
60.54 |
36.4 |
8.49 |
7.25 |
1612 |
1251.2 |
133094 |
24.37 |
39 |
67.73 |
109.3 |
0.79 |
0 |
1669 |
3077.3 |
133317 |
18.33 |
19.1 |
64.53 |
56.1 |
11.15 |
6.63 |
1533 |
1415.3 |
133372 |
17.26 |
20 |
42.53 |
41.4 |
13.11 |
12.84 |
1149 |
1055.8 |
133443 |
16.73 |
57.4 |
54.07 |
119 |
0 |
0 |
1555 |
2691 |
133497 |
24.78 |
11.8 |
73.18 |
28 |
0 |
0 |
1470 |
662.4 |
133507 |
16.74 |
5.7 |
54.84 |
16.5 |
4.17 |
2.57 |
1620 |
932.5 |
133533 |
15.3 |
17.1 |
51.96 |
41.4 |
6.68 |
3.63 |
1122 |
1100.2 |
133606 |
27.74 |
26.6 |
82.71 |
70.9 |
0.4 |
0.76 |
1994 |
1530.5 |
133615 |
26.4 |
14.8 |
80.64 |
40.8 |
1.58 |
0.76 |
1940 |
902.4 |
133637 |
26.76 |
20.4 |
70.67 |
47 |
3.44 |
0 |
1472 |
954.2 |
133676 |
17.73 |
19.4 |
52.62 |
55.1 |
3.7 |
3.79 |
1388 |
1504.7 |
133692 |
25.97 |
24.3 |
65.65 |
52 |
4.88 |
1.98 |
1683 |
1333.6 |
133833 |
18.57 |
14 |
53.18 |
37.4 |
7.31 |
4.64 |
1226 |
798.2 |
133925 |
26.48 |
17.3 |
72.45 |
37.9 |
25.74 |
28.06 |
1679 |
912.3 |
133987 |
26.98 |
23.2 |
64.35 |
60.9 |
32.64 |
28.85 |
1583 |
1210.5 |
134013 |
33.26 |
27.6 |
80.79 |
62.3 |
1.14 |
2.57 |
2229 |
1637.1 |
134021 |
19.03 |
11.2 |
47.56 |
29 |
0.9 |
0 |
1321 |
1254.6 |
134047 |
16 |
13.6 |
49.35 |
37.7 |
2.25 |
0 |
1162 |
1046.1 |
134103 |
27.59 |
17 |
72.49 |
34.8 |
16.61 |
10.8 |
1761 |
1009.6 |
134119 |
22.32 |
13.2 |
64.53 |
31 |
1.27 |
1.85 |
1376 |
730.6 |
134129 |
26.83 |
19.9 |
77.98 |
49.5 |
2.2 |
1.06 |
1689 |
1130.7 |
134144 |
36.44 |
36.8 |
94.53 |
89.3 |
16.51 |
11.86 |
2010 |
1870.1 |
134223 |
26.25 |
43.4 |
73.74 |
89.8 |
6.92 |
10.32 |
1815 |
2425.4 |
134350 |
30.92 |
20.2 |
82.98 |
51.8 |
17.76 |
15.86 |
1779 |
1187.8 |
134385 |
27.5 |
9.8 |
74.55 |
25.5 |
1.84 |
0.76 |
2038 |
782.3 |
134431 |
34.25 |
18.8 |
77.12 |
41.9 |
40.11 |
46.39 |
1973 |
1187.9 |
134486 |
23.79 |
28.7 |
62.49 |
67.8 |
32.72 |
56.39 |
1870 |
2166.6 |
134495 |
23.56 |
36.9 |
72.11 |
105 |
1.89 |
2.57 |
1936 |
2497 |
134519 |
20.46 |
7.5 |
58.42 |
21.1 |
27.86 |
43.32 |
1619 |
757.5 |
134550 |
24.16 |
21.8 |
69.11 |
60.4 |
13.62 |
19.74 |
1757 |
1297.6 |
134553 |
23.42 |
31.5 |
72.08 |
90.4 |
9.92 |
7.55 |
1582 |
1837.6 |
134566 |
26.4 |
14.5 |
72.99 |
36.1 |
5.04 |
4.64 |
1670 |
956.9 |
134598 |
24.09 |
14.9 |
61.17 |
35.2 |
12.95 |
9.3 |
1454 |
878.4 |
134611 |
25.25 |
20.5 |
56.16 |
42.6 |
9.43 |
12.08 |
1616 |
1144.2 |
134622 |
23.34 |
41.1 |
66.51 |
113.2 |
0 |
0 |
1371 |
2921.6 |
134835 |
16.61 |
21.6 |
49.65 |
56.8 |
27.26 |
27 |
1388 |
1227.6 |
134838 |
39.36 |
22.7 |
99.1 |
45.8 |
18.69 |
39.26 |
2425 |
891.8 |
134839 |
23.66 |
18.3 |
55.86 |
41 |
28.28 |
25.9 |
1280 |
842.6 |
134845 |
40.59 |
48.4 |
108.72 |
107.5 |
6.99 |
6.63 |
2376 |
2539.5 |
135002 |
34.04 |
37.4 |
82.11 |
91.1 |
0 |
0 |
1885 |
2389.5 |
135009 |
18.94 |
37 |
56.34 |
90.7 |
12.48 |
12.91 |
1302 |
1713.9 |
135026 |
21.41 |
23.4 |
52.2 |
60.2 |
4.21 |
4.42 |
1016 |
936.6 |
135126 |
18 |
24.1 |
46.44 |
61.2 |
12.18 |
11.86 |
963 |
1307.6 |
135130 |
21.04 |
24.8 |
58.92 |
67 |
0 |
0 |
1501 |
1466.6 |
135146 |
11.82 |
11.5 |
38.59 |
28.9 |
2.18 |
0.76 |
1026 |
991.7 |
135172 |
27.39 |
20.8 |
79.63 |
58.1 |
1.76 |
0 |
1820 |
1532.9 |
135182 |
34.61 |
34.3 |
98.94 |
104.6 |
2.17 |
2.87 |
2087 |
2279.8 |
135201 |
19.79 |
22.6 |
57.7 |
62.1 |
1.43 |
4.64 |
1299 |
1228.1 |
135258 |
21.34 |
16.7 |
57.3 |
33.9 |
14.23 |
6.76 |
1524 |
854.3 |
135262 |
18.79 |
25.7 |
57.33 |
76.6 |
1.39 |
2.87 |
1450 |
1975.8 |
135313 |
18.63 |
6.6 |
61.11 |
20.7 |
2.98 |
5.7 |
1340 |
601.1 |
135324 |
20.39 |
16.9 |
62.54 |
48 |
3.77 |
1.06 |
1634 |
1140.4 |
135330 |
18.64 |
14.9 |
53.56 |
44.2 |
8.1 |
11.14 |
1608 |
1520.6 |
135351 |
15.39 |
12.1 |
50.4 |
33.7 |
13.79 |
5.57 |
1649 |
922.9 |
135372 |
31.35 |
24.9 |
91.65 |
72.8 |
28.29 |
39.26 |
2013 |
1394.8 |
135391 |
23.62 |
23.3 |
62.62 |
59.3 |
15.6 |
10.75 |
1626 |
1706.9 |
135465 |
27.51 |
42.8 |
81.29 |
112.3 |
6.97 |
6.63 |
1732 |
2447.5 |
135472 |
41.01 |
18.3 |
114.85 |
41.7 |
0 |
0 |
2518 |
1323.7 |
135488 |
15.99 |
20.6 |
48.25 |
50.2 |
8.18 |
6.63 |
1561 |
1399.8 |
135530 |
17.48 |
18.8 |
50.43 |
46.5 |
0.51 |
0 |
1485 |
1739.3 |
135547 |
31.35 |
35.3 |
76.92 |
75.1 |
7.82 |
12.08 |
1767 |
1627.5 |
135559 |
17.64 |
17.8 |
45.39 |
38.5 |
6.6 |
11.14 |
1006 |
922.5 |
135588 |
39.43 |
26.4 |
98.34 |
77.9 |
28.79 |
52.07 |
2085 |
1602.7 |
135596 |
30.98 |
28.8 |
73.8 |
70.3 |
3.82 |
1.81 |
1588 |
1570.3 |
135619 |
32.86 |
41.2 |
84.85 |
92.5 |
0 |
0 |
1682 |
2074.9 |
135769 |
26.24 |
26.4 |
72.73 |
60.7 |
8.31 |
2.91 |
2121 |
2039.1 |
135829 |
20.07 |
25.9 |
65.41 |
87.6 |
8.22 |
13.76 |
1568 |
1958.8 |
135834 |
14.42 |
11.3 |
40.64 |
29.6 |
0.96 |
0.76 |
1216 |
1043.6 |
135848 |
29.59 |
29.9 |
71.41 |
67.6 |
0.63 |
0 |
1612 |
1327.6 |
135869 |
28.02 |
15.5 |
77.82 |
40.5 |
15.72 |
16.81 |
1827 |
1026.9 |
136104 |
25.85 |
23.7 |
70.89 |
75 |
23.97 |
12.43 |
1721 |
1584.6 |
136377 |
20.2 |
20.3 |
51.99 |
52 |
7.28 |
6.63 |
1467 |
1342.4 |
136378 |
36.19 |
18.1 |
95.43 |
47.1 |
4.6 |
7.25 |
1976 |
1204.3 |
136407 |
22.42 |
10.9 |
62.15 |
32 |
2.56 |
1.81 |
1731 |
981.6 |
136421 |
16.98 |
20.4 |
42.85 |
47.5 |
13.91 |
8.64 |
1033 |
1128.3 |
137461 |
23.98 |
18.5 |
67.43 |
45.9 |
5.39 |
7.19 |
1585 |
1247.5 |
184093 |
21.39 |
19 |
56.7 |
40.4 |
0.6 |
3.49 |
1320 |
994 |