PERMUT Excel Formula
Excel Statistical Function allows you to do simple to complex statistical computations: from mean, median, and mode to probability tests. The Statistical Function is composed of five subgroups. Under the subgroups is PERMUT Function. PERMUT function allows you to compute how many permutations do a given value of objects has. As an overview permutation is the significance of an internal order of a group of events or objects. This function is commonly used in calculating the probability of lottery results.
The syntax of PERMUT function include:
=PERMUT (number,number_chosen)
…whereas the argument Number is a numerical value that describes how many are the objects. The argument Number_chosen is a value that corresponds to how many the objects are in a given permutation.
Test the function by opening a blank Excel worksheet or spreadsheet and input the following data in the source cells. For cell A1 input 100, for cell A2 input 3 and the formula is =PERMUT (A2, A3) and the result will be 970200. The result refers to the possible permutations with the data given. You can also immediately input the values in the function as: =PERMUT (49, 6) and the result will be 10,068,347,520.
For PERMUT function, there are common errors that will occur and these are #VALUE! error and #NUM! Errors. #VALUE! Error occurs when the argument Numbers or Number_chosen are non-numerical values. #NUM! error will occur if the argument number is equavalent to or lesser than zero and if Number_chosen arguments is lesser than 0. Likewise, if the argument Number is lesser than the argument Number_chosen #NUM! Error will also occur. In addition, take heed that the arguments if function is shortened and made into integers.
Once you have inputted the formula in the selected cell the result will automatically show. If you like to view the formula of the results you can hit Ctrl+` (grave accent) in the keys. In addition, you can do this by selecting Formulas tab hit the Formulas Auditing group and in the options select the Show Formula.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro