Limited access

A large number of cold breakfast cereals were studied for a consumer magazine study. Variables identified in the table below include: the name of the cereal, the number of calories per serving, the number of grams of fat per serving, the number of milligrams of sodium per serving, the number of grams of dietary fiber per serving, the number of grams of carbohydrates per serving, the number of grams of sugar per serving, and the display shelf on which the cereal was found most frequently in supermarkets, as well as a health rating given by nutritionists.

The display shelf codes are: B (bottom shelf), M (middle shelf), and T (top shelf).

The health ratings span values from: 1 (most unhealthy), and 100 (healthiest).

In the sortable table below, click on the column title to organize the table by that column's values.

Name Calories Fat Sodium Fiber Carbs Sugar Shelf Health Rating
100%_Bran 70 1 130 10 5 6 T 68.403
100%_Natural_Bran 120 5 15 2 8 8 T 33.9837
All-Bran 70 1 260 9 7 5 T 59.4255
All-Bran_with_Extra_Fiber 45 0 140 14 8 0 T 93.7049
Apple_Cinnamon_Cheerios 110 2 180 1.5 10.5 10 B 29.5095
Apple_Jacks 110 0 125 1 11 14 M 33.1741
Basic_4 130 2 210 2 18 8 T 37.0386
Bran_Chex 90 1 200 4 15 6 B 49.1203
Bran_Flakes 90 0 210 5 13 5 T 53.3138

The table above can be sorted to decide whether the following statements are true or false, based on the scenario above.

True

False

Cereals on the bottom shelf have the highest mean amount of sugar per serving as compared with the other shelves.

The range of health ratings for fat-free cereals is greater than the range of health ratings for cereals that contain some fat.

One gram of fat contains about 9 calories. Using this standard, less than one quarter of the cereals listed in the table have fat accounting for at least 15% of their calories.

Select an assignment template