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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,118,575
Messages
5,573,017
Members
412,498
Latest member
Eddy08
Top