How do you work out how heaps combinations at hand are surrounded by the national lottery. Excel get this no. 13983816?
I thought it was 49*48*47*46*45*44 but I was wrong.
Answers:
If you are talking about the National Lottery contained by the UK, you are right it is 13,983,815 to 1.
the esaiest instrument is to use COMBIN
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
Syntax
COMBIN(number,number_chosen)
Number is the number of items.
Number_chosen is the number of items in each combination.
so contained by a cell type =combin(49,6)
returns 13983816
Find a future-teller and ask him what he thinks.
(Seriously though, No one knows otherwise they would win the lottery respectively week) SORRY
The order in which the numbers are drawn does not thing, so divided your 49*48*47*46*45*44 by 6! (6 factorial)
The Excel amount is correct, but you are on the right lines too.
49*48*47*46*45*44 is the total number of combinations available. But that includes results such as 1,2,3,4,5,6 and 6,5,4,3,2,1 - which is the same result (for most normal 6 from 49 lotteries) because the ORDER does not business.
So you also need to divide the possible combinations by the number of ways they could be repeated.
Which is easier than it sounds, because it is the number of different ways you can order the six ball drawn. So same as you already did but for the 6 balls, i.e. 6*5*4*3*2*1.
So you get:
49*48*47*46*45*44 = 10,068,347,520
and,
6*5*4*3*2*1 = 720
so,
10,068,347,520 / 720 = 13,983,816
Simple as that :-)
Related Questions:
Is wearing sunglasses at the poker table doomed to failure etiquette?
There have been other questions on this, some asking whether it is undeserved (which it can't be as anyone can wear them) or not it removes an interesting aspect of the game from reaing the eyes or using the eyes to distract (which many can agree or disagree on). My comment is...
what web pages have lottery prediction?
If you could win it...?
I hold a poker cross-examine
I need driving directions to the new casino(s) at Yonkers Raceway from Beacon N.Y.?
Whenever I divide playing cards- it's always 7 of CLUBS? Does it mean anything? It's weird?
Why do casinos make a BFD about "silver mining" (looking for abandoned credits or coins in slot machines)?
Fruit Machines in Ireland?
anyone know any good poker sites, besides Party Poker?
Answers:
If you are talking about the National Lottery contained by the UK, you are right it is 13,983,815 to 1.
the esaiest instrument is to use COMBIN
Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.
Syntax
COMBIN(number,number_chosen)
Number is the number of items.
Number_chosen is the number of items in each combination.
so contained by a cell type =combin(49,6)
returns 13983816
Find a future-teller and ask him what he thinks.
(Seriously though, No one knows otherwise they would win the lottery respectively week) SORRY
The order in which the numbers are drawn does not thing, so divided your 49*48*47*46*45*44 by 6! (6 factorial)
The Excel amount is correct, but you are on the right lines too.
49*48*47*46*45*44 is the total number of combinations available. But that includes results such as 1,2,3,4,5,6 and 6,5,4,3,2,1 - which is the same result (for most normal 6 from 49 lotteries) because the ORDER does not business.
So you also need to divide the possible combinations by the number of ways they could be repeated.
Which is easier than it sounds, because it is the number of different ways you can order the six ball drawn. So same as you already did but for the 6 balls, i.e. 6*5*4*3*2*1.
So you get:
49*48*47*46*45*44 = 10,068,347,520
and,
6*5*4*3*2*1 = 720
so,
10,068,347,520 / 720 = 13,983,816
Simple as that :-)
Related Questions:
Is wearing sunglasses at the poker table doomed to failure etiquette?
There have been other questions on this, some asking whether it is undeserved (which it can't be as anyone can wear them) or not it removes an interesting aspect of the game from reaing the eyes or using the eyes to distract (which many can agree or disagree on). My comment is...
The answers post by the user, for information only, GamblingAsk.com does not guarantee the right.