• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Finding anomaly in a group of four numbers

Experts,

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.
Anomolies.xlsx
0
morinia
Asked:
morinia
1 Solution
 
NBVCCommented:
You can use conditional formatting that will highlight the smallest non-zero Index value in each section....

Select from D7:G45, then go to Home|Conditional Formatting, then New Rule

Select "use a formula to determine which cells to format"

then enter formula:

=AND($B7="Index",D7=SMALL($D7:$G7,COUNTIF($D7:$G7,0)+1))

click Format and choose from Font tab.  You can select Bold and/or Font Colour.

Click Ok, then Ok to finish.

If more than one of the min value appear they will all be highlighted...
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now