Hi. Is there a formula or function, say using Excel, to calculate how many 2-dot to 9-dot combinations are possible on a mobile or similar screen-lock? Doing it manually, I stopped during the 4-dot patterns in MSpaint. Just mind-boggling how it escalates. Just for curiosity. Regards, Clive.
SOURCE: Combinations and Permutations
You can enter combinations and permutations.
If the order of the selection matters (ie. 1st, 2nd, and 3rd place out of 40 contestants) use permutation. Enter:
40{shift}{nPr}3 and then [=] for your answer set (=59280 possible ways).
IF order doesn not matter (ie. a team of 3 from 40 possible members) then it is a combination. Do the same as above, but substitute {nCr} for {nPr}. (= 9880 possible ways).
For your question: a three-digit set, selecting from 0-9. There is no specified order, it is a combination. The total n=10 (there are 10 digits in the range 0-9) and you are selecting 3.
so.... 10[nCr]3 with give the number of possible combinations.
SOURCE: How do I permutate a fixed quantity of digits ONE PER COLUMN in EXCEL?
Sorry we are not a math solving website, we deal in product self repair and use of said products.
Testimonial: "Thank you for advice re category. I re-posted it in 'Math' rather than 'Computers', which I thought was also relevant for Excel Software. Confusing.. :)"
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
17 views
Usually answered in minutes!
×