Real Geek Forums > Archives > Operating Systems > Apple Macintosh > Mac Office > Mac Office Excel > "Reverse" MODE? LEAST frequently occuring value in a number array?

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

Posted: 04-23-2008, 01:49 AM
rodgersk24@officeformac.com
Guest
Posts: n/a
 
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
Reply With Quote

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

Bob Greenblatt
Guest
Posts: n/a
 
Re: "Reverse" MODE? LEAST frequently occuring value in a numberarray?
Posted: 04-23-2008, 01:01 PM
On 4/22/08 8:49 PM, in article ee994c4.-1@webcrossing.caR9absDaxw,
"rodgersk24@officeformac.com" <rodgersk24@officeformac.com> wrote:
> 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.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply With Quote
Carl Witthoft
Guest
Posts: n/a
 
Re: "Reverse" MODE? LEAST frequently occuring value in a number array?
Posted: 04-23-2008, 03:59 PM
In article <C4349D6F.AB035%bob@nospam.com>,
Bob Greenblatt <bob@nospam.com> wrote:
> On 4/22/08 8:49 PM, in article ee994c4.-1@webcrossing.caR9absDaxw,
> "rodgersk24@officeformac.com" <rodgersk24@officeformac.com> wrote:
>
> > 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.
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 )

--
Team EM to the rescue! http://www.team-em.com
Reply With Quote
JE McGimpsey
Guest
Posts: n/a
 
Re: "Reverse" MODE? LEAST frequently occuring value in a number array?
Posted: 04-23-2008, 02:58 PM
In article <ee994c4.-1@webcrossing.caR9absDaxw>,
rodgersk24@officeformac.com wrote:
> 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.
Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Page number" missing from "Insert" in menu bar Theo Mac Ofice Word 1 03-23-2006 07:12 AM
How to setup "per target-mode-SCSI-operation DMA" for "target mode" data transfer with **ScsiPort Miniport** driver model? Shailesh Chaudhari Windows XP Device Drivers 0 08-23-2005 03:19 PM
do windows xp suport "asymmetric clustering" or "symmertric mode" stoic Windows XP Hardware 0 12-17-2003 11:29 PM
switching from "safe mode" back to "normal mode" bob Windows XP Help & Support 2 12-05-2003 05:45 PM
connect to share in "safe w/networking" mode but not in "normal" mode John Burnham Windows XP Network & Web 1 09-25-2003 02:15 PM