Question

Could anyone please explain how to do this? I would appreciate it!

The judges of County X try thousands of cases per year. Although in a big majority of the cases disposed the verdict stands as rendered, some cases are appealed. Of those appealed, some are reversed. Because appeals are often made as a result of mistakes by the judges, you want to determine which judges are doing a good job and which ones are making too many mistakes.

The attached Excel file has the results of 182,908 disposed cases over a three year period by the 38 judges in various courts of County X. Two of the judges (Judge 3 and Judge 4) did not serve in the same court for the entire three-year period. Using your knowledge of probability and conditional probability you will make an analysis to decide a ranking of judges. You will also analyze the likelihood of appeal and reversal for cases handled by different courts.

Using Excel to calculate the following probabilities for each judge. Use the attached Excel file to fill in these numbers on the tables for each court. Each court is given on a separate tab.

The probability of a case being appealed for each judge.

The probability of a case being reversed for each judge.

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

Probability of cases being appealed and reversed in the three courts.

Rank the judges within each court.

Only 1 dataset is post due to length of the question.

Common Pleas Court
Judge	Total Cases Disposed	Appealed Cases	Reversed Cases	Probability of Appeal	Probability of Reversal	Conditional Probability of Reversal Given Appeal	Rank of Judge
Judge 1	3,037	137	12
Judge 2	3,372	119	10
Judge 3	1,258	44	8
Judge 4	1,954	60	7
Judge 5	3,138	127	7
Judge 6	2,264	91	18
Judge 7	3,032	121	22
Judge 8	2,959	131	20
Judge 9	3,219	125	14
Judge10	3,353	137	16
Judge 11	3,000	121	6
Judge 12	2,969	129	12
Judge 13	3,205	145	18
Judge 14	955	60	10
Judge 15	3,141	127	13
Judge 16	3,089	88	6
Total	43,945	1762	199

Answer 1

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

where A is the set of cases appealed and R is a set of cases which are reversed from the set of the appealed cases

a judge is well performed when the no of the reversed cases are less from those of the appealed cases

which is nothing but the probability of reversal given appealed must be less

we can also choose no .of reversal cases as a parameter to give the rankings but no of reversed cases given appealed will be more appropriate(even though his judgement was appealed if the same judgement given by him is given proves his strength to give the right verdict)

remark: here the judge's judgement doesn't depend on the court. hence one need not consider the fact that Two of the judges (Judge 3 and Judge 4) did not serve in the same court for the entire three-year period