Need help with question number 5 only please all the data has been provided

fx 100% A Home Layout Tables Charts SmartArt Formulas Data Review Font Alignment Edit - A- A- abc Wrap Text Ge Fill Times New Roman - 12 Clear BIUH. - A Merge Paste A1 : x - fx Judge A B C D E F G H Judge Disposed Appealed Reversed Court 2 Fred Cartolano 3037 137 12 Common 3 Thomas Crush 3372 119 10 Common 4 Patrick Dinkelacker 1258 44 8 Common 5 Timothy Hogan 1954 60 7 Common 6 Robert Kraft 3138 127 7 Common 7 William Mathews 2264 91 18 Common 8 William Morrissey 3032 121 22 Common 9 Norbert Nadel 2959 131 20 Common 10 Arthur Ney Jr. 3219 125 14 Common 11 Richard Niehaus 3353 137 16 Common 12 Thomas Nurre 3000 121 6 Common 13 John O'Connor 2969 129 12 Common 14 Robert Ruehlman 3205 145 18 Common 15 J. Howard Sundermann Jr. 955 60 10 Common 16 Ann Marie Tracey 3141 127 13 Common 17 Ralph Winkler 3089 88 6 Common 18 Penelope Cunningham 2729 7 1 Domestic 19 Patrick Dinkelacker 6001 19 4 Domestic 20 Deborah Gaines 8799 48 9 Domestic 21 Ronald Panioto 12970 32 3 Domestic 22 Mike Allen 6149 43 Mun 23 Nadine Allen 7812 34 6 Mun 24 Timothy Black 7954 41 6 Mun 25 David Davis 7736 43 Mun 26 Leslie Isaiah Gaines 5282 35 13 Mun 27 Karla Grady 5253 0 Muni 28 Deidra Hair 2532 0 Muni 29 Dennis Helmick 7900 29 Muni 30 Timothy Hogan 2308 13 Muni 31 James Patrick Kenney 2798 00 - N Muni 32 Joseph Luebbers 4698 25 Muni 33 William Mallory 8277 38 9 Muni 34 Melba Marsh 8219 34 Muni 35 Beth Mattingly 2971 13 1 Muni 36 Albert Mestemaker 4975 28 9 Muni 37 Mark Painter 2239 Muni 38 Jack Rosen 7790 41 13 Muni 39 Mark Schweikert 5403 33 6 Muni 40 David Stockdale 5371 22 A Muni Data + Normal View Ready esc F1 58- F2 20 F3 8 8 8 F4 ". F5 . F6 $ W# 4 5 6 Q W E R T tab D F caps lock A S Z X C Vtoo many mIStakes. YOU are called In to aSSlSt In the data analysis. Use your knowledge of probability and conditional probability to help with the ranking of the judges. You also may be able to analyze the likelihood of appeal and reversal for cases handled by different courts. your rankings of the Man analysis of the likelihood of appeal and case reversal in the three courts. Icrosoft Excel, port in the same Microsoft Excel document. \fd=12665... MINDTAP Q Sea Go to pg. 215 1/ AA Norbert Nadel 2,959 131 20 Arthur Ney, Jr. 3,219 125 14 The purpose of the newspaper's study was to evaluate the performance of the judges. Appeals are often the result of mistakes made by judges, and the newspaper wanted to know which judges were doing a good job and which were making too many mistakes. You are called in to assist in the data analysis. Use your knowledge of probability and conditional probability to help with the ranking of the judges. You also may be able to analyze the likelihood of appeal and reversal for cases handled by different courts. Managerial Report Prepare a report with your rankings of the judges. Also, include an analysis of the likelihood of appeal and case reversal in the three courts. At a minimum, your report should include the following: 1. The probability of cases being appealed and reversed in the three different courts. 2. The probability of a case being appealed for each judge. 3. The probability of a case being reversed for each judge. 4. The probability of reversal given an appeal for each judge. 5. Rank the judges within each court. State the criteria you used and provide a rationale for your choice. 30,3 288F4 ." FS 4 17 I FB 4 F10 4 % 5 6 & R U O P G H J K . . . . B N M 9:6 alt command optionGo to pg. 215 112 AA Chapter Review ase Problem 1 Hamilton County Judges Hamilton County judges try thousands of cases per year. In an overwhelming majority of the cases disposed, the verdict stands as rendered. However, some cases are appealed, and of those appealed, some of the cases are reversed. Kristen DelGuzzi of The Cincinnati Enquirer conducted a study of cases handled by Hamilton County judges over a three-year period. Shown in Table 4.8 are the results for 182,908 cases handled (disposed) by 38 judges in Common Pleas Court, Domestic Relations Court, and Municipal Court. Two of the judges (Dinkelacker and Hogan) did not serve in the same court for the entire three-year period. DATA file Judge Table 4.8 Total Cases Disposed, Appealed, and Reversed in Hamilton County Courts Common Pleas Court + Judge Total Cases Appealed Reversed Disposed Cases Cases Fred Cartolano 3,037 137 12 Thomas Crush 3,372 119 10 Patrick Dinkelacker ,258 44 888,4 4 F7 E R U O D D F G H K C B N M alt command optionHamilton County judges try thousands of cases per year. In an overwhelming majority of the cases disposed, the verdict stands as rendered. However, some cases are appealed, and of those appealed, some of the cases are reversed. Kristen DelGuzzi of The Cincinnati Enquirer conducted a study of cases handled by Hamilton County judges over a three-year period. Shown in Table 4.8 are the results for 182,908 cases handled (disposed) by 38 judges in Common Pleas Court, Domestic Relations Court, and Municipal Court. Two of the judges (Dinkelacker and Hogan) did not serve in the same court for the entire three-year period. The purpose of the newspaper's study was to evaluate the performance of the judges. Appeals are often the result of mistakes made by judges, and the newspaper wanted to know which judges were doing a good job and which were making too many mistakes. You are called in to assist in the data analysis. Use your knowledge of probability and conditional probability to help with the ranking of the judges. You also may be able to analyze the likelihood of appeal and 1. The probability of cases being appealed and reversed in the three different courts. 2. The probability of a case being appealed for each judge. 3. The probability of a case being reversed for each judge. 4. The probability of reversal given an appeal for each judge. 5. Rank the judges within each court. State the criteria you used and provide a rationale for your choice