"Reverse" MODE? LEAST frequently occuring value in a number array?

[rodgersk24]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hello,

I am trying to assemble a list of "strengths" of a group of people after they take one of those "strengths tests", and was going to throw some stats in there for the higher-ups. Is there such thing as a "reverse MODE"? By that, I mean: MODE is used to find the most frequently occuring number in a given array, but is there a way to find the LEAST frequently occuring number in a given array?

Thank you very much in advance, I really appreciate it!

Kyle

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hello,

I am trying to assemble a list of "strengths" of a group of people after they
take one of those "strengths tests", and was going to throw some stats in
there for the higher-ups. Is there such thing as a "reverse MODE"? By that, I
mean: MODE is used to find the most frequently occuring number in a given
array, but is there a way to find the LEAST frequently occuring number in a
given array?

Thank you very much in advance, I really appreciate it!

Kyle

Not really, as that may not produce a unique result. (There may be many
unique values.) Try filtering the list, and it will give you a good idea of
the frequency.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hello,

I am trying to assemble a list of "strengths" of a group of people after they
take one of those "strengths tests", and was going to throw some stats in
there for the higher-ups. Is there such thing as a "reverse MODE"? By that, I
mean: MODE is used to find the most frequently occuring number in a given
array, but is there a way to find the LEAST frequently occuring number in a
given array?

One way:

Array enter (CMD-RETURN):

=INDEX(rng,MATCH(TRUE,COUNTIF(rng,rng)=MIN(COUNTIF(rng,rng)),FALSE))

where rng is your range.

Note that if there are two least frequently occuring numbers, only the
first will be returned.

 

[Carl Witthoft]

Not really, as that may not produce a unique result. (There may be many
unique values.) Try filtering the list, and it will give you a good idea of
the frequency.

A kludge: try creating a histogram whose bins are 1 unit wide (whatever
unit you want), and run MIN() on the results.
I just posted a variant of the OatBran histogram workbook at
http://witthoft.com/histogram.zip if you'd like to check it out
(if your browser hates redirect, go to
http://home.comcast.net/~cgwcgw/histogram.zip )