Solved

Finding anomaly in a group of  four numbers

Posted on 2013-11-12
1
236 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 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA: copy data from one workbook to another 6 39
Formula not working in excel =SUMPRODUCT 4 40
Math Equation 23 82
Excel Pivot Chart - Need to show sum of totals 3 17
Have you ever thought of installing a power system that generates solar electricity to power your house? Some may say yes, while others may tell me no. But have you noticed that people around you are now considering installing such systems in their …
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

806 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