CONDITIONAL_PROBABILITY.xlsx

	A	B	C	D	E	F	G	I	J	K	L	M	N	O	P	Q	R
1		Conditional Probability
2	Variables	Placement	(Yes, No)
3		Data	(Male, Female)
4
5		Cross Tabulation							Restrict to Male				Restrict to Female
6			Placement						Placement				Placement
7			Yes	No	Total	Absolute Frequency			Yes	No	Total		Yes	No	Total
8	Gender	Male	21	19	40				21	19	40		25	10	35
9	Gender	Female	25	10	35
10		Total	46	29	75				Outcome	Count	Count as a proportion of total		Combinations	Count	Count as a proportion of total
11								Conditional Probability	Placed	21	0.53	Given that a student is male, chances of being placed	Placed	25	0.71	Conditional Probability	Given that a student is female, chances of being placed
12									Not Placed	19	0.48	Given that a student is male, chances of being not placed	Not Placed	10	0.29		Given that a student is female, chances of being not placed
13									Total	40	1.00		Total	35	1.00
14
15
16		Combinations	Combinations	Counts	Count of Combination as a Proportion of Total				Restrict to "Placed"				Restrict to "Not Placed"
17		1	Male & Yes	21	0.28	Joint Probability	What are the chances of a male student getting placed		Gender				Gender
18		2	Male & No	19	0.25		What are the chances of a male student not getting placed		Male	Female	Total		Male	Female	Total
19		3	Female & Yes	25	0.33		What are the chances of a female student getting placed		21	25	46		19	10	29
20		4	Female & No	10	0.13		What are the chances of a female student not getting placed
21			Total	75	1.00				Outcome	Count	Count as a proportion of total		Combinations	Count	Count as a proportion of total
22								Conditional Probability	Male	21	0.46	Given that a student is placed, chances of being a male	Male	19	0.66	Conditional Probability	Given that a student is not placed, chances of being a male
23			Row/Coumn Total		Row/Column Count as a Proportion of Total				Female	25	0.54	Given that a student is placed, chances of being a female	Female	10	0.34		Given that a student is not placed, chances of being a female
24		Row Count	Count of Male	40	0.53	Marginal Probability	Irrespctive of being placed or not, chances of having a male student		Total	46	1.00		Total	29	1.00
25		Row Count	Count of Female	35	0.47		Irrespctive of being placed or not, chances of having a female student
26		Column Count	Count of "Yes"	46	0.61		Irrespctive of the gender, chances of being placed
27		Column Count	Count of "No"	29	0.39		Irrespctive of the gender, chances of being not placed
28			Total Count	75
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