4(d) Using pivot table and class as filter, prepare separate brand switching matrices for (1) seniors, and (2) others (that is, freshmen, sophomore, and junior, combined)
Brand Switching Matrix for Seniors
Next Brand
Current Brand Apple LG None Other Samsung Grand Totals
Apple
LG
None
Other
Samsung
Grand Totals
Brand Switching Matrix for Others (freshmen, sophomore, and juniors, combined)
Next Brand
Current Brand Apple LG None Other Samsung Grand Totals
Apple
LG
None
Other
Samsung
Grand Totals