LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
RedChequer
 
Posts: n/a
Default

Thanks Bernard

"Bernard Liengme" wrote:

From http://mathworld.wolfram.com/search/



Searched for "permutation". Results 1 - 10 of about 233.

Permutation -- From MathWorld
A permutation, also called an "arrangement number" or "order," is a
rearrangement of the elements of an ordered list S into a one-to-one
correspondence with S itself. The number of permutations on a set of n
elements is given by n! (n factorial; Uspensky 1937, p. 18). For example,
there are 2!==2.1==2 pe

Searched for "combination". Results 1 - 10 of about 105.


Combination -- From MathWorld
The number of ways of picking k unordered outcomes from n possibilities.
Also known as the binomial coefficient or choice number and read "n choose
k," _nC_k=(n; k)=(n!)/(k!(n-k)!), where n! is a factorial (Uspensky 1937, p.
18). For example, there are (4; 2)==6 combinations of two elements out of
the se
http://mathworld.wolfram.com/Combination.html - 21k - 2005-03-16


Note the reference to ORDER and UNORDERED

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RedChequer" wrote in message
...
Myrna,
I already posed a than yo reply bu I meant to ask, Wht is the difference
between Permutations & Combinations

"RedChequer" wrote:

Thanks Myrna

"Myrna Larson" wrote:

If the only thing that matters is the identity of the 6 numbers, and
the order
in which they were selected is not important, the function you want is
COMBINATIONS, not PERMUTATIONS. The function name is COMBIN.

On Sat, 24 Sep 2005 19:49:01 -0700, "RedChequer"
wrote:

Can any one give me the formula for doing permutations
ie. odds against picking 6 numbers, not in numerical order, from 45
numbers.
Excel's PERMUT function for =Permut(45.6) returns odds of
5,864,443,200
This seems too excessive, it's more like the odds of picking the 6
numbers
in numerical order.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate permutations of nonnumeric data RonG Excel Worksheet Functions 1 March 31st 05 04:30 AM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"