Card-like probability calculator

	A	B	C	D	E	F	G
1	Card-like probability calculator
2	Uses the hypergeometric distribution function
3	HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
4	that calculates (without replacement; see below)
5	the number of successes, num_successes
6	in a number of draws, num_draws
7	when there are a known number of matching cards (successes), successes_in_pop
8	in the deck (the population), pop_size
9	without replacement, as if a hand is being dealt or drawn from the deck
10
11	Intuitive input (entered)		Additional columns for "or more"
12	Number of cards in deck	42	42	42	42	42
13	Number of matches in deck	9	9	9	9	9
14	Total number of cards drawn	1	1	1	1	1
15	Number of matches sought	1	2	3	4	5	exactly. Since probabilities taper off quickly, it's easy to get very close with few calculations.
16
17
18	num_successes	1	2	3	4	5
19	num_draws	1	1	1	1	1
20	successes_in_pop	9	9	9	9	9
21	pop_size	42	42	42	42	42
22	Probability of "exactly" desired matches	21.429%	0.000%	0.000%	0.000%	0.000%
23	Total probability of desired "or more"	21.429%
24	(or at least up to 4 more)
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100