Homework SourseBased on this data analysis 1 Any conclusions on sugar conte
Based on this data analysis
1. Any conclusions on sugar content, cost per ounce, calories per serving?
2. What about product placement on the shelves?
3. Any conclusions on the results from looking at all 30 versus the three categories (Healthy, Neutral, Non-Healthy)?
Variables
Location on the shelf (bottom, middle, top).
Mean
Standard Deviation
Range
Mode
Median
Number of cal. Per serving
Bottom
125.71
24.398
70
120
120
Middle
136.2
41.940
130
120
120
Top
134
42.216
100
100
120
Number of grams of sugar
Bottom
9.286
4.1115
11
6
8
Middle
9.462
1.984
6
10
10
Top
9.8
4.131
14
15
9.5
Serving Size gm*cup
Bottom
31.893
11.806
32.75
**
30
Middle
28.330
10.050
36.375
21.75
24
Top
32.375
14.951
36.5
56
25.625
Size in ounces
Bottom
14.257
3.079
9.5
**
14
Middle
12.192
1.505
4.8
12.2
12.2
Top
13.285
2.479
7.1
16
13.6
Price
Bottom
3.904
1.004
3
3.99
3.99
Middle
4.436
0.592
1.7
4.99
4.49
Top
4.31
0.3824
1
4.99
4.14
| Variables | Location on the shelf (bottom, middle, top). | Mean | Standard Deviation | Range | Mode | Median |
| Number of cal. Per serving | Bottom | 125.71 | 24.398 | 70 | 120 | 120 |
| Middle | 136.2 | 41.940 | 130 | 120 | 120 | |
| Top | 134 | 42.216 | 100 | 100 | 120 | |
| Number of grams of sugar | Bottom | 9.286 | 4.1115 | 11 | 6 | 8 |
| Middle | 9.462 | 1.984 | 6 | 10 | 10 | |
| Top | 9.8 | 4.131 | 14 | 15 | 9.5 | |
| Serving Size gm*cup | Bottom | 31.893 | 11.806 | 32.75 | ** | 30 |
| Middle | 28.330 | 10.050 | 36.375 | 21.75 | 24 | |
| Top | 32.375 | 14.951 | 36.5 | 56 | 25.625 | |
| Size in ounces | Bottom | 14.257 | 3.079 | 9.5 | ** | 14 |
| Middle | 12.192 | 1.505 | 4.8 | 12.2 | 12.2 | |
| Top | 13.285 | 2.479 | 7.1 | 16 | 13.6 | |
| Price | Bottom | 3.904 | 1.004 | 3 | 3.99 | 3.99 |
| Middle | 4.436 | 0.592 | 1.7 | 4.99 | 4.49 | |
| Top | 4.31 | 0.3824 | 1 | 4.99 | 4.14 |
Solution
The mean, standard deviation and range is highest for Number of calories per serving.
The product placements are divided into three categories: Bottom, middle and top.
The mean is always higher for healthy products, so it may be concluded that the other two products neutral and non healthy, the healthy ones should be preferred.
