for the last question (upload your work) please create an excel sheet. thank you in advance.

Case Study: County Judges 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. A journalist conducted a study of cases handled by County judges over a 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 reversal for cases handled by different courts. Managerial Report Prepare a report with your rankings of the judges including an analysis of the likelihood of appeal and case reversal in the three courts. Given Data Consider the results for 183,040 cases handled (disposed) by 38 Judges in common Pleas Court, Domestic Relations Court, and Municipal Court in the table below. Two of the judges (Dinkelacker and Hogan) did not serve in the same court for the entire three-year period. Give Date Consider the results for sale for the Court. Domenico Cout and Municipal Court in the table beim The of the desiderate the same cut for the Jodige Thamu Dipindad OS co . 1.51 31 Arthur 135 22 3.21 13 11 10 2017 38 LI 130 WH 1103 . 2.735 Deboral Pepe Cum . 130 76 3.00 Dw 301 20 13 on Schwa 2. 31 Appealed and Reversed Cases Courts Compute the probabilities that a case is appealed and reversed for each of the three courts. (Round your answers toeght decimal places) Court Appealed Reversed Common Peas Domestic Relations Municipal Appeals are most bely in the Common Pls Court and seast likely in the Domeste ataion Court. Reversals are most likely in the Court and lastly in the base on Court Apped Cases by Compute the prebesity a case is appealed for each judge in the common Pleas Court Round your answers to eight secmel places.) Thomas Crush William Morrissey Norbert Nadel Ann Marie Tracey Ralph Winkler Fred Cartolano Arthur Ney Br. 3 1. Howard Sundermann Dr. Robert Rehman John O'Connor Thomas Murre Robert Kraft Patrick Dinkelcker Timothy Hogan Richard Niehaus William Mathews The judge with the highest probability of an eat in the Common Peas Court is Sales The judge with the lowest probability of an appear in the Common Pieas Court ist. Compute the probability comes appealed for each judge in the Domestic Relations Court. (Round your answers to eight decimal places) Deborah Gaines Penelope Cunningham Ronald Panioto Patrick Dinkelcker The judge The judge with the highest probability of an appeal in the Domestic Relations Court is --- with the lowest probability of an appeal in the Domestic Relations Courtis-Set the wa wwerte Wiliam Mary Davide Hart stars A. Wat The were Cormed with Thomas wa Hry Array Fred Castle Are 3.ward Sandermann Sun There are bert Hindi w The judges by the Com the processed for the Relations Couture Penelope Cursing Putri The with the print The with the vince in the Direct Comote the press the court Round you were being De James Free MA BY Tack Devi watery Deale Date March Mare JAW La Isaiah Nane Alle Albert Hestama Helle Marsh Timothy Magan Sewe the heat probiyot having Cered in the court that Derick Olanestee O OD Om waar David Scale Mark Pointer Joseph A we Die Abert Me Timothy Meer See the go with the story of things the Municipal Court Select that De Turkey Mielen Kary luckor David David Mei Witam Die Or Schwert ht Om met NA Aberto Mette Marsh Timothy Hoga Candy Cute the problemeve that is for eachine Carmen Court Round your wers to tecnico Themes Crush William More Norbert Hedel Ana Mane Tre Ha Win Fred Care Arthur Ney 3. Howard undermenu Roberta John Or Thomas Wurre Neben Patria platstart Wiliam Mathew The ju the highest of having cerede ind is the common em Court The with the best probably of having a case revered with the Cum Cts- Cetea ce se ven that is for eachine Des Couture Iwwer decals Deborah Gaines Pensle Cunningham Ronald Pune Patrick Dickr That with the strony ingreseve me pested the team Cutie - o. The train credit Domotion Court Compute the perhatia.colored gue that is good for each pater in the cow Court (pound you Dennis Helmiche James Patrick Kenney Mike Allen kara Grady Jack Rosen David Davis Bath Mattingly William Hallery Deidra Hair David Stockdale Mark Schwart Harl Painter Joseph Lubbers SA West Leslie Traia Gaines Nadine Allen A Mester Timothy Black Melba Marsh Timothy Hogan Select the chest processes the Munico Cout, (Select that ply) Demi James Patrick Keine Karta Grady Jack Rosen David Davis Beth Mating William Mary Deldrar David Sociale Mark Schwert Mark Pointer Joseph Letters John A. West Leslie Isaiah Gaines Nadine Alen Albert Mestemaker Timothy Merbe Marsh Timothy Select the judge with the lowest prayot having a case read more Ropa Court Select that apply Det er Prime Mie Allen Karl Grey lack Rosen David Davis let Martin Witam Mallory Dior Devid Stockdate Mars Schwest Marx Pante Jom Lubbe John A. West Lesehan Nie Alien Albert Mestemaker Timothy Black Timothy Hoa A newer ranked judges for each court on the proportions and comes that revered given there was appeal. A rank of het protectie to judges were given the same Forecamp the sectors for postos 12 the weed, then both would get the cake 12 The Muting the hallest tota ranking site with the most effective performance and meeting cated with the a efective performans Using the same process the newspaper and the desinthe Commons Recourt Judge Appeal Rank Rank Reversal Sum of Ranta Thomh Fred Catan Arthur Con Foto Richard Determine them and effective in the Commons-Court don thinking ture, the most effective in the common Court et effective des Using the process when the Domestion Court Applever everal Ghen Appealan Sumat lanks Debora Curingum Determine the most effective der in the Domestic Relation Cours. les on the ranking structure, the most effective in the Destination Court and the Ung the post the Court Judge Applevere neversal Gives Appealank Sum of Rank A We NA Abert Meter Tiety Tot Determine the most effective the Court Based on this ranking structure de mest effectivelor in the orico Couti Upload any relevantes ( State with me) Open Response (otional per The box can be used for componendar to pateikto document vide, or the test you have created for the intense contact your instructor you bout what anything should be mitted his time to be type Case Study: County Judges 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. A journalist conducted a study of cases handled by County judges over a 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 probabiley to help with the ranking or 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 including an analysis of the likelihood of appeal and case reversal in the three courts. Given Data Consider the results for 183,040 cases handled (disposed) by 33 judges in common Pleas Court, Domestic Relations Court, and Municipal Court in the table below. Two of the judges (Dinkelocker and Hogan) did not serve in the same court for the entire three-year period. Judge Disposed Appealed Reversed Court Thomas Crush 3,015 11 Common William Morrissey 3,376 117 10 Common Norbert Nadel 1.257 Common 140 43 Ann Marie Tracey 1,951 61 7 Common Ralph Winkler 3,132 123 7 Common Fred Cartolano 2,271 90 19 Common Arthur Neyr 3,037 124 21 Common 2,960 135 22 Common 3. Howard Sundermann Robert Ruelsman 3.241 123 13 Common John O'Connor 3,356 138 17 Common Thomas Nurre 3,010 120 6 Common Robert Kraft 2.970 123 11 Common Patrick Dinkelacker 3,188 149 16 Common Timothy Hogan 959 59 10 Common Richard Niehaus 3,158 131 12 Common William Mathews 3,102 91 6 Common Deborah Gaines 2,735 7 1 Domestic Penelope Cunningham 5,989 20 4 4 Domestic Ronald Panioto 8,886 50 9 Domestic Patrick Dinkelacker 13,042 30 Domestic Dennis Helmick 6,116 42 4 Muni James Patrick Kenney 7,795 32 6 Muni Mike Allen 7,989 40 6 Muni Karla Grady 7,670 41 u Muni Jack Rosen 5,301 36 12 Muni David Davis 5,207 6 0 Muni 2,513 5 0 Muni Beth Mattingly William Mallory 7,854 28 5 Muni Deidra Hair 2,298 12 2 Muni David Stockdale 2,816 6 1 Muni Mark Schweikert 4,694 23 8 Muni Mark Painter 8,308 39 9 Muni Joseph Luebbers 8,282 35 N Muni John A. West 2,984 11 1 Muni wand John A. West 2,984 11 1 Muni Leslie Isalah Gaines 4,977 26 Muni Nadine Allen 2,240 7 3 Muni Albert Mestemaker 7,797 39 12 Mini Timothy Black 5,34 32 6 Muni Melba Marsh 5.379 21 4 Muni Timothy Hogan 2,001 2 Muni Appealed and Reverso Cosen, Courts Compute the probabilities that a case is appealed and reversed for each of the three courts, (Round your answers to eight decimal places) Court Appealed Reversed Common Pleas Domestic Relations Municipal Court and least likely in the Domestic Relations Court. Reversals are most likely in the Common Pleas Court and least likely in the Appeals are most likely in the Common Pleas Domestic Relation Court Sovepoce by mammor Manage Appealed Cases by Judge Compute the probability a case is appealed for each judge in the Common Pleas Court. (Round your answers to eight decimal places.) Thomas Crush William Morrissey Norbert Nadel Ann Marie Tracey Ralph Winder Fred Cartolano Arthur Ney Ir. 3. Howard Sundermann Jr. Robert Ruohiman John O'Connor Thomas Nurre Robert Krant Patrick Dinlcelacker Timothy Hogan Richard Niehaus William Mathews Select The judge with the highest probability of an appeal in the Common Pleas Court is -Select The judge with the lowest probability of an appeal in the Common Pleas Court is Compute the probability a case is appealed for each judge in the Domestic Relations Court. (Round your answers to eight decimal places.) Man Deborah Gaines Penelope Cunningham Ronald Panioto Patrick Dinkelacker The judge with the highest probability of an appeal in the Domestic Relations Court is Select The Judge with the lowest probability of an appeat in the Domestic Relations Court is Select Compute the probability a case in appealed for each Judge in the Municipal Court. (Round your answers to eight decimal places.) Dennis Helmick James Patrick Kenney Mile Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deldra Hair David Stockdale Mark Schweikert Mark Painter INE Joseph Lubbers John A. West Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan The judge with the highest probability of an appear in the Municipal Court is Select The judge was the lowest probability of an appear in the Municipal Court Select Reversed Cars by Judge Compute the probability a case is reversed for each Judge in the Common Peas Court. (Round your answer to eight decimal places.) Thomas Crush William Morrissey Norbert Nadel Ann Marie Tracey Ralph Winkler Fred Cartolano Arthur Ney Br. 3. Howard Sundermann Jr. 3. Howard Sundermann Jr. Robert Ruchiman John O'Connor Thomas Nurre Robert Kraft Patrick Dinklacker Timothy Hogan Richard Niehaus William Mathews The judge with the highest probability of having a case reversed in the common Pleas Courtis Select The judge with the lowest probability of having a case reversed in the Common Pleas Court is --Select- Compute the probability cole is reversed for each Judge in the Domestle Relations Court. (Round your answers to eight decimal places.) Deborah Gaines Penelope Cunningham Ronald Panioto Patrick Dinkelcker The judge with the highest probability of having a case reversed in the Domestic Relations Court is Select The judge with the lowest probability of having a case reversed in the Domestic Relations Court i Select Compute the probability a case is reversed for each fudge in the Municipal Court. (Round your answers to eight decimal places) Dennis Helmich James Patrick Kenney Mike Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter Joseph Lubbers John A. West Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Select the judge(s) with the highest probability of having a case reversed in the Municipal Court. (Select all that apply.) Dennis Helmick James Patrick Kenney Mike Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter Joseph Luebbers John A. West Leslie Isalah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Select the judge(s) with the lowest probability of having a case reversed in the Municipal Court. (Select all that apply.) Dennis Helmick James Patrick Kenney Mike Allen Karla Grady . OOO Jack Rosen David Davis Beth Mattingly Case Reversed Given Appeal by Judge Compute the probability a case is reversed given that it is appealed for each judge in the Common Pleas Court (Round your answers to eight decimal places.) Thomas Crush William Morrissey Norbert Nadel Ann Marie Tracey Ralph Winkler Fred Cartolano Arthur Ney J. Howard Sundermann Jr. Robert Ruehlman John O'Connor Thomas Nurre Robert Kraft Patrick Dinkelcker Timothy Hogan Richard Niehaus William Mathews The judge with the lowest probability of having a The Judge with the highest probability of having a case reversed given it was appealed in the Common Pleas Court is Select case reversed given it was appealed the common Pleas Court is --Select- Compute the probability a case is reversed given that it is appealed for each Judge in the Domestic Relations Court. (Round your answers to eight decimal places.) Deborah Gaines Penelope Cunningham Ronald Panioto Patrick Dinkelakar The judge with the highest probability of having a case reversed given it was appealed the Domestic Relations Courtis-Select- The judge with the lowest probability of having a case reversed given it was appealed in the Domestic Relations Court is ---Select- Compute the probability a case is reversed given that it is appealed for each Judge in the Municipal Court (Round your answers to eight decimal places.) Dennis Helmick James Patrick Kenney Mike Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter Mark Painter Joseph Luebbers John A. West Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Select the judge(s) with the highest probability of having a case reversed given it was appealed in the Municipal Court. (Select all that apply.) Dennis Helmick James Patrick Kenney Mike Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter Joseph Luebbers John A. West Leslie Isaiah Gaines Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Select the judge(s) with the lowest probability of having a case reversed given it was appealed in the Municipal Court. (Select all that apply.) a Dennis Helmick James Patrick Kenney Mike Allen Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter Joseph Luebbers John A. West Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Judge Rankings A newspaper ranked judges for each court based on the proportions of cases appealed, cases reversed, and cases that were reversed given there was an appeal. A rank of 1 was given to the lowest proportion in each category. In the event of a tie, both judges were given the same rank. For example, if the probabilities are equal for two judges for positions 12 and 13 in the ordered data, then both would be assigned the rank of 12. The ranks were then summed to give a total rating. The smallest total ranking is associated with the most effective performance and the highest total ranking is associated with the least effective performance. Using the same process as the newspaper, rank the judges in the Common Pleas Court. Judge Appeal Rank Reverse Rank Reversal Given Appeal Rank Sum of Ranks Thomas Crush witam Morrissey Norbert Nadel Ann Marie Tracey Ralph Winkler Fred Cartolano Arthur Ney 3. Howard undermann Robert Reiman John O'Connor Thomas Nurre Robert Krant Patrick Dinkelacker Timothy Hogan Richard Niehaus Richard Niehaus William Mathews Determine the most and least effective judge in the Common Pleas Court. Based on this ranking structure, the most effective judge in the Common Pleas Court is Select Using the same process as the newspaper, rank the judges in the Domestic Relations Court. and the least effective Judge is --Select Judge Appeal Rank Reverse Rank Reversal Given Appeal Rank Sum of Ranks Deborah Gaines Penelope Cunningham Ronald Panioto Patrick Dinklacker Determine the most and least effective Judge in the Domestic Relations Court. Based on this ranking structure, the most effective judge in the Domestic Relations Court is ---Select- Using the same process as the newspaper, rank the judges in the Municipal Court. and the least effective judge is --Select- Judge Appeal Rank Reverse Rank Reversal Given Appeal Rank Sum of Ranks Dennis Helmick James Patrick Kenney Mike Allen Karta Grady Jack Rosen David Davis Beth Mattingly Karla Grady Jack Rosen David Davis Beth Mattingly William Mallory Deidra Hair David Stockdale Mark Schweikert Mark Painter LLLLLLLL LLLLLLL 0.001.00LLONI Joseph Luebbers John A. West Leslie Isaiah Gaines Nadine Allen Albert Mestemaker Timothy Black Melba Marsh Timothy Hogan Determine the most and least effective judge in the Municipal Court. Based on this ranking structure, the most effective judge in the Municipal Court is --Select- and the least effective judges Select