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.

The Excel 2 file is attached in the Final Project learning object. It 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 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.

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.

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

5.Rank the judges within each court.

AutoSave On OFg MATH-807-FinalProject-PARTII Data. - Last Modified: Sh ago . 9 Search A Jacqueline Gray J LO File Home Insert Page Layout Formulas Data Review View Help Share Comments O Calibr 11 AA = = = 2 Wrap Text General 2 AutoSum " Ap O BIUMA BEE E Merge & Center $~ % 9 08-28 Conditional Format as Cell Fill ~ Formatting Table Styles Insert Delete Format Clear * Sort & Find & Filter ~ Select Ideas Clipboard Font Alignment Number Styles Cells Editing Ideas K13 M N 1 Municipal Court a Conditional Total Appeale Reversed Probability Probability |Reversal Probability of Judge Disposed d Cases Cases of Appeal of Reversal Given Appeal Judge Rank of Duage 20 6.149 5 Judge 21 6 Judge 22 9 7 Judge 23 7.954 10 Judge 2,532 14 Jud dge 28 dge 30 20 Jud W 22 Judge 37 23 Judge 38 5,371 24 Total 108,464 29 2:21 PM Common Pleas Court Domestic Rel Court Municipal Court + 8/6/2020 Display Settings Homework Help - Q&A from Onl x G number representation in statisti x | + C a coursehero.com/tutors/homework-help/ # Apps G Google Databases | Frankli.. Settings Google Scholar E Franklin University .. Getting Started & K... National Conference.. Is Home - State Netw.. $ SAGE Stats | Health System Das.. COVID-19: We are in this together. Access free textbook solutions and ask 5 free questions to expert tutors 24/7. X E Course Hero Find study resources Q Find Ask 15 Earn by Study Resources v Expert Tutors Contributing v Get 24/7 homework help from Expert Tutors Get step-by-step answers You can ask 15 questions (will expire 3) BIU X X fx Ix Enter your question and any additional information Enter a subject Get Answer This helps us match you with the right tutor Answers in as fast as 15 minutes Type here to search O