M
Mally
I do a tote in my local club where I pick three letters for 10 pence. If
these come out I win several hundred pounds.
I have a spreadsheet that uses the FACT function to show the factorial of a
number up to the number 26 containing combinations of 3 numbers and the cost
e.g. 4 = 4 combinations of 3 numbers, 7 = 35 combinations of 3 numbers, 15
= 455 combinations of 3 numbers, etc., etc.
We pick 15 letters (instead of numbers) from 26 which costs £45.50 as there
is 455 combinations of 3 letters in 15.
We have been told that the most number of letters we can put on at once is 8
at a cost of £5.60 (56 combinations) but there is no limit to the number of
sets of 8 letters we can put on.
I know that there are, for example 56 combinations of 3 letters in 8
letters. How do I show how many sets of 8 letters there are that will cover
all of the 3 letter combinations from the 15 letters we pick?
We may pick different letters every time.
The total number of letters we pick may change but it will always cost 10
pence for 3 letters. It doesn’t have to be sets of 8 letters to cover the 15
letters (or the number selected).
If this can’t be done in excel is there any software out there that will do
it.
I hope this makes sense!
Thank you in advance for your help.
these come out I win several hundred pounds.
I have a spreadsheet that uses the FACT function to show the factorial of a
number up to the number 26 containing combinations of 3 numbers and the cost
e.g. 4 = 4 combinations of 3 numbers, 7 = 35 combinations of 3 numbers, 15
= 455 combinations of 3 numbers, etc., etc.
We pick 15 letters (instead of numbers) from 26 which costs £45.50 as there
is 455 combinations of 3 letters in 15.
We have been told that the most number of letters we can put on at once is 8
at a cost of £5.60 (56 combinations) but there is no limit to the number of
sets of 8 letters we can put on.
I know that there are, for example 56 combinations of 3 letters in 8
letters. How do I show how many sets of 8 letters there are that will cover
all of the 3 letter combinations from the 15 letters we pick?
We may pick different letters every time.
The total number of letters we pick may change but it will always cost 10
pence for 3 letters. It doesn’t have to be sets of 8 letters to cover the 15
letters (or the number selected).
If this can’t be done in excel is there any software out there that will do
it.
I hope this makes sense!
Thank you in advance for your help.