Difference between revisions of "Documentation/How Tos/Calc: PERMUT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(13 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:PERMUT function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_NORMSDIST_function
 +
|NextPage=Documentation/How_Tos/Calc:_PERMUTATIONA_function
 +
}}__NOTOC__
  
 
== PERMUT ==
 
== PERMUT ==
−
Returns the number of permutations for a given number of objects.
+
Returns the number of ordered permutations for a given number of objects.
  
 
=== Syntax: ===
 
=== Syntax: ===
Line 9: Line 14:
 
: where <tt>'''n'''</tt> and <tt>'''k'''</tt> are integers.
 
: where <tt>'''n'''</tt> and <tt>'''k'''</tt> are integers.
  
−
: <tt>'''PERMUT'''</tt> returns the number of ordered ways that <tt>'''k'''</tt> objects can be chosen from a set of <tt>'''n'''</tt> objects. For example with a set of 3 objects A, B, C, we can choose 2 as follows: AB, AC, BA, BC, CA, CB.
+
: <tt>'''PERMUT'''</tt> returns the number of ordered ways that <tt>'''k'''</tt> objects can be chosen from a set of <tt>'''n'''</tt> objects, where an object can only be chosen once. For example with a set of 3 objects A, B, C, we can choose 2 as follows: AB, AC, BA, BC, CA, CB.
  
 
: <tt>'''PERMUT'''</tt> calculates:
 
: <tt>'''PERMUT'''</tt> calculates:
  
−
image to follow
+
: [[Image:Calc_permut_formula.png]]
  
 
=== Example: ===
 
=== Example: ===
Line 20: Line 25:
 
: returns <tt>'''6'''</tt>, as in the example above.
 
: returns <tt>'''6'''</tt>, as in the example above.
  
−
=== See also: ===
+
===Issues: ===
−
[[Documentation/How_Tos/Calc: PERMTUTATIONA function|'''PERMTUTATIONA''']]
+
* The international standard ODFF expects <tt>'''n'''</tt> and <tt>'''k'''</tt> to be integers. Both Calc and Excel truncate any non-integer parameter.
  
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]]
 +
* [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]]
 +
* [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]]
  
−
[[Documentation/How_Tos/Calc: Mathematical functions|'''Mathematical functions''']]
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
  
−
===Issues: ===
+
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]
−
* The forthcoming international standard ODFF expects <tt>'''n'''</tt> and <tt>'''k'''</tt> to be integers. Both Calc and Excel truncate any non-integer parameter.
+
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Statistical functions]]

Latest revision as of 14:13, 2 February 2024



PERMUT

Returns the number of ordered permutations for a given number of objects.

Syntax:

PERMUT(n; k)

where n and k are integers.
PERMUT returns the number of ordered ways that k objects can be chosen from a set of n objects, where an object can only be chosen once. For example with a set of 3 objects A, B, C, we can choose 2 as follows: AB, AC, BA, BC, CA, CB.
PERMUT calculates:
Calc permut formula.png

Example:

PERMUT(3; 2)

returns 6, as in the example above.

Issues:

  • The international standard ODFF expects n and k to be integers. Both Calc and Excel truncate any non-integer parameter.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_PERMUT_function&oldid=260061"
Views
Personal tools
Navigation
Tools