Using mathematical methods to spot anomalies

theta

Well-known Member
Joined
Jun 9, 2009
Messages
960
Hi all. If I had a list of numbers (1,000 rows) and wanted to find those which would appear to be anomalies, given the rest of population...what methods could I use?

15
19
65
87
4
23
100
53
14
7

Distance from the mean?
Normal (Gaussian) distribution?
Bi-nomial distribution?
Quantitative methods...

What would be the easist way to 'mark' these items with some sort of index (standard z-score) and perhaps graph it?

Would there be a way to 'tune' this to make it more/less senstitive...
 

theta

Well-known Member
Joined
Jun 9, 2009
Messages
960
Hi guys. I have my first draft using STD Dev and graphs. If I upload can I get some active feedback :)
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,114,278
Messages
5,546,939
Members
410,764
Latest member
Dedeke
Top