Analysis.xlsx

	A	B	C	D	E
1		Chance of Making a 4 Major Contract
2		Total Major Fit
3	Total HCP	7	8	9	10
4	24	21.79%	57.05%	79.57%	87.07%
5	25	34.04%	71.47%	87.88%	92.37%
6	26	48.85%	82.51%	93.59%	95.88%
7	27	64.64%	90.29%	96.90%	99.79%
8	28	79.52%	95.20%	99.35%	100.00%
9	29	88.24%	97.57%	99.87%	99.62%
10	30	94.43%	99.35%	100.00%	100.00%
11
12		Chance of Making 3NT
13		Total Major Fit
14	Total HCP	7	8	9	10
15	24	35.18%	30.98%	34.09%	34.47%
16	25	51.46%	47.29%	48.61%	49.25%
17	26	67.46%	62.37%	60.98%	61.28%
18	27	79.32%	73.73%	73.42%	70.98%
19	28	88.49%	82.51%	82.05%	77.39%
20	29	91.71%	89.63%	85.66%	82.76%
21	30	95%	95%	91%	88%
22
23		Comparing Odds of Playing Major vs. NT (Major minus NT)
24		Total Major Fit
25	Total HCP	7	8	9	10
26	24	-13.39%	26.07%	45.48%	52.61%
27	25	-17.42%	24.18%	39.28%	43.12%
28	26	-18.61%	20.15%	32.61%	34.60%
29	27	-14.68%	16.56%	23.48%	28.81%
30	28	-8.97%	12.68%	17.30%	22.61%
31	29	-3.46%	7.94%	14.21%	16.86%
32	30	-0.84%	4.49%	9.40%	12.50%
33
34		Number of Data Points
35		Total Major Fit
36	Total HCP	7	8	9	10
37	24	11235	7649	3476	998
38	25	9334	6120	2905	865
39	26	7360	4924	2263	656
40	27	5619	3841	1772	479
41	28	4135	2768	1231	345
42	29	2773	1890	788	261
43	30	1904	1226	564	136
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