The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish).
For the data relating to the number of calories and the amount of cholestrol for the popular protein foods:
a. Consruct a frequency distribution and a percentage distribution.
b. Construct a histogram and a percentage polygon.
c. Form a cumulative percentage distribution and plot a cumulative percentage polygon.
d. What conclusions can you draw from these analyses?
Calories |
Protein |
%Calories fat |
%Calories saturated fat |
Cholesterol |
250 |
25 |
58 |
23 |
82 |
287 |
23 |
66 |
26 |
87 |
184 |
28 |
24 |
12 |
82 |
263 |
28 |
54 |
21 |
91 |
244 |
28 |
51 |
22 |
71 |
191 |
28 |
38 |
16 |
89 |
215 |
30 |
42 |
17 |
94 |
217 |
27 |
36 |
12 |
482 |
240 |
27 |
52 |
18 |
90 |
208 |
30 |
37 |
15 |
89 |
397 |
29 |
67 |
27 |
121 |
183 |
33 |
42 |
20 |
127 |
175 |
26 |
37 |
15 |
131 |
239 |
27 |
51 |
14 |
88 |
190 |
29 |
37 |
10 |
89 |
157 |
30 |
18 |
6 |
69 |
98 |
16 |
6 |
0 |
39 |
98 |
22 |
8 |
1 |
74 |
99 |
21 |
12 |
2 |
54 |
199 |
27 |
77 |
20 |
100 |
110 |
23 |
13 |
3 |
53 |
182 |
27 |
24 |
5 |
93 |
112 |
23 |
8 |
1 |
56 |
116 |
24 |
15 |
2 |
156 |
181 |
32 |
41 |
10 |
48 |