Question

Here is a project I am currently working on and I could use some feedback on how to get started. I calculated the general probabilities for the first two columns of each spreadsheet (successes / total outcomes). I don't want to move forward until I know I'm on the right track but I'm concerned that I've oversimplified the question being asked. I'm also using Excel and am having a hard time finding an appropriate formula for conditional probability. My book provides the handwritten formula but not for Excel. Is there one? Thanks for any guidance!

-------------------------------------

The spreadsheet provides the data for the total cases disposed, numbers of appealed cases and the numbers of reversed cases for judges in each court. Using Excel, calculate the following probabilities for each judge. Use the spreadsheets to fill in these numbers on the tables for each court.

1. The probability of a case being appealed for each judge.

2. The probability of a case being reversed for each judge.

3. The probability of a reversal given an appeal for each judge.

Common Pleas Court
Judge	Total Cases Disposed	Appealed Cases	Reversed Cases	Probability of Appeal	Probability of Reversal	Conditional Probability of Reversal Given Appeal
Judge 1	3,037	137	12	0.045110306	0.003951268
Judge 2	3,372	119	10	0.035290629	0.002965599
Judge 3	1,258	44	8	0.034976153	0.0063593
Judge 4	1,954	60	7	0.030706244	0.003582395
Judge 5	3,138	127	7	0.040471638	0.00223072
Judge 6	2,264	91	18	0.040194346	0.00795053
Judge 7	3,032	121	22	0.039907652	0.007255937
Judge 8	2,959	131	20	0.044271713	0.00675904
Judge 9	3,219	125	14	0.038831935	0.004349177
Judge10	3,353	137	16	0.040858932	0.004771846
Judge 11	3,000	121	6	0.040333333	0.002
Judge 12	2,969	129	12	0.043448973	0.004041765
Judge 13	3,205	145	18	0.04524181	0.005616225
Judge 14	955	60	10	0.062827225	0.010471204
Judge 15	3,141	127	13	0.040432983	0.004138809
Judge 16	3,089	88	6	0.028488184	0.001942376
Total	43,945	1762	199	0.651392056	0.078386192

Answer 1

1.

2.

3.

Judge	Total Cases Disposed	Appealed Cases	Reversed Cases	Probability of Appeal	Probability of Reversal	Conditional Probability of Reversal Given Appeal
Judge 1	3,037	137	12	0.045110306	0.003951268	0.087591241
Judge 2	3,372	119	10	0.035290629	0.002965599	0.084033613
Judge 3	1,258	44	8	0.034976153	0.0063593	0.181818182
Judge 4	1,954	60	7	0.030706244	0.003582395	0.116666667
Judge 5	3,138	127	7	0.040471638	0.00223072	0.05511811
Judge 6	2,264	91	18	0.040194346	0.00795053	0.197802198
Judge 7	3,032	121	22	0.039907652	0.007255937	0.181818182
Judge 8	2,959	131	20	0.044271713	0.00675904	0.152671756
Judge 9	3,219	125	14	0.038831935	0.004349177	0.112
Judge 10	3,353	137	16	0.040858932	0.004771846	0.116788321
Judge 11	3,000	121	6	0.040333333	0.002	0.049586777
Judge 12	2,969	129	12	0.043448973	0.004041765	0.093023256
Judge 13	3,205	145	18	0.04524181	0.005616225	0.124137931
Judge 14	955	60	10	0.062827225	0.010471204	0.166666667
Judge 15	3,141	127	13	0.040432983	0.004138809	0.102362205
Judge 16	3,089	88	6	0.028488184	0.001942376	0.068181818