Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Finding anomaly in a group of  four numbers

Posted on 2013-11-12
1
Medium Priority
?
263 Views
Last Modified: 2013-11-13
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
Comment
Question by:morinia
1 Comment
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39642055
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question