Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11PERMUT function - The function returns the number of permutations of a given number of objects in Excel
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!
Jessica TannerYou should read it
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- ISODD function - The function returns True if the value is an odd number in Excel
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- The SQRT function returns the square root of a positive number in Excel
- SHEETS function - The function returns the number of pages in a reference in Excel
- NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
May be interested
- PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel
permutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen) - PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excelquartile.inc function: the function returns the quartile of a data set, with percentile values from 0 to 1 including 0 and 1. support functions from execl 2010 onwards. syntax: quartile.inc (array, quart)
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excelrank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
Office information
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel- COUPNUM function - The function returns the number of interest payments on a security in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
- ISODD function - The function returns True if the value is an odd number in Excel
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel
COUPNUM function - The function returns the number of interest payments on a security in Excel
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
The DAYS function - The function returns the number of days between 2 dates in Excel
ISODD function - The function returns True if the value is an odd number in Excel