The following article introduces you to the PERMUT function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the number of permutations of a given object. Permutations are subsets of values where the position and number of elements in permutations are different.
Syntax: PERMUT (number, number_chosen)
Inside:
- number: Integer specifies the number of objects, is the required parameter .
- number_chosen: An integer that specifies the number of objects in a permutation, which is a required parameter.
Attention:
- If number, number_chosen are not whole numbers -> they are truncated to whole numbers.
- If number, number_chosen are not numbers -> the function returns the #VALUE! Error value
- If number
- If number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value
- The equation for numbers and permutations is:
[{P_ {k, n}} = frac {{n!}} {{Left ({n - k} right)!}}]
For example:
Find the number of permutations consisting of 4 elements from 93 elements described in the following data table:
- In the cell to calculate enter the formula : = PERMUT (E6, E7)
- Press Enter -> The number of permutations includes 4 elements:
- Where number (number of objects)
- Where number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using PERMUT function in Excel.
Good luck!