cutomer segmentation
maqi0912
hw6_segmentation.xlsSheet1
| Table 1: Counts | Table 2: Percentage Distribution | ||||||||||
| high | med | low | subtotal | high | med | low | subtotal | ||||
| younger | 250 | 250 | 550 | 1050 | younger | 5.00% | 5.00% | 11.00% | 21.00% | ||
| older | 1700 | 1250 | 1000 | 3950 | older | 34.00% | 25.00% | 20.00% | 79.00% | ||
| subtotal | 1950 | 1500 | 1550 | 5000 | total | subtotal | 39.00% | 30.00% | 31.00% | 100.00% | total |
| Table 3: Number of orders | Table 4: Response Rate | ||||||||||
| high | med | low | subtotal | high | med | low | subtotal | ||||
| younger | 19 | 24 | 22 | 65 | younger | 7.60% | 9.60% | 4.00% | 6.19% | ||
| older | 88 | 69 | 28 | 185 | older | 5.18% | 5.52% | 2.80% | 4.68% | ||
| subtotal | 107 | 93 | 50 | 250 | total | subtotal | 5.49% | 6.20% | 3.23% | 5.00% | total |
