I have a spreadsheet attached where I attempted to calculate the percentage change (difference) between the total population and the respective group.
By eyeballing the sheet, I have identified Rows 26 -30 which show a significant difference in the percentage of households among Asian's who subscribe to cable.
I am looking for a way to automate the process so that this number would stand out. The index is much lower in this case.
Can someone tell me the best statistical approach in Excel to use to be able to identify the group where the number is much lower or much higher than the others.
Any help or suggestions would be appreciated.