PART II:

In this part of your project, you will be asked to evaluate the performance of the judges in County X of Ohio. Here is the background:

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.

TheExcel 2 file is attached in the Final Project learning object. Itprovides the data for the total cases disposed, numbers of appealed cases and the numbers of reversed cases for judges in each court.

Using Excel or SAS Studio, 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.

A B C D E F G H Conditional Probability of Total Cases Appealed Reversed Probability Probability Reversal Rank of 4 Judge Disposed Cases Cases of Appeal of Reversal Given Appeal Judge 5 Judge 1 3,037 137 12 6 Judge 2 3,372 119 10 7 Judge 3 1,258 44 8 Judge 4 1,954 60 7 9 Judge 5 3,138 127 7 10 Judge 6 2,264 91 18 11 Judge 7 3,032 121 22 12 Judge 8 2,959 131 20 13 Judge 9 3,219 125 14 14 Judge10 3,353 137 16 15 Judge 11 3,000 121 6 16 Judge 12 2,969 129 12 17 Judge 13 3,205 145 18 18 Judge 14 955 60 10 19 Judge 15 3,141 127 13 20 Judge 16 3,089 88 6 21 Total 43,945 1762 199 22 23 24 25 26 27 28 29 Common Pleas Court Domestic Rel Court Municipal Court + ReadyA B C D E F G H N Domestic Relations Court Conditional Total Probability of Cases Appealed Reversed Probability Probability Reversal Given Rank of 3 Judge Disposed Cases Cases of Appeal of Reversal Appeal Judge 4 Judge 17 2,729 7 1 5 Judge 3 6,001 19 6 Judge 18 8,799 48 9 7 Judge 19 13,970 32 3 8 Total 31,499 106 17 10 11 12 13 23 24 25 26 27 Common Pleas Court Domestic Rel Court Municipal Court +KDCDKJOWU'I-bU-J 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 A B C D E F G H Municipal Court Conditional Total Probability of Cases Appealed Reversed Probability Probability Reversal Given Rank of Judge Disposed Cases Cases of Appeal of Reversal Appeal Judge Judge 20 6,149 43 4 Judge 21 7,812 34 6 Judge 22 7,954 41 6 Judge 23 7,736 43 5 Judge 24 5,282 35 13 Judge 25 5,253 6 0 Judge 26 2,532 5 0 Judge 27 7,900 29 5 Judge 4 2,308 13 2 Judge 28 2,798 6 1 Judge 29 4,698 25 8 Judge 30 8,277 38 9 Judge 31 8,219 34 7 Judge 32 2,971 13 1 Judge 33 4,975 28 9 Judge 34 2,239 7 3 Judge 35 7,790 41 13 Judge 36 5,403 33 6 Judge 37 5,371 22 4 Judge 38 2,797 4 2 Total 108,464 500 104 Common Pleas Court Domestic Rel Court Municipal Court Gr)