Jackson County judges try thousands of cases per year. In an

Jackson County judges try thousands of cases per year. In anoverwhelming majority of the cases disposed, the verdict stands asrendered. However, some cases are appealed, and of those appealed, someof the cases are reversed. Jackie Chan of The Star Tribune conducted a study of cases handled by Jackson County judges over a three-year period. In the Excel file, Judges,linked at the bottom of the page, are the results for the 182,908 caseshandled (disposed) by 40 judges in Common Pleas Court, DomesticRelations Court, and Municipal Court. The purpose of the newspaper’s study was to evaluate the performanceof the judges. The newspaper wanted to know which judges were doing agood job and which ones were making too many mistakes. You are to assistin the data analysis by using your knowledge of probability andconditional probability to help with the ranking of each of the judges,as well as each court.Managerial ReportPrepare a report (see below) with your ranking of the judges based onthe probabilities and conditional probabilities, as well as the analysisof each court. Include the following seven (7) items in table format tosupport your ranking. Be sure to use five (5) decimal places for your probabilities in the table, as some of them will be quite small.The probability of cases being appealed in each of the three different courts.The probability of cases being reversed in each of the three different courts.The probability of cases being reversed given an appeal in each of the three different courts.The probability of a case being appealed for each judge.The probability of a case being reversed for each judge.The probability of reversal, given an appeal for each judge.Rank the judges within each court for each of theprobabilities in 4 – 6. In other words, only rank the judges in theCommon Pleas court against the other judges in the Common Pleas court.perfrom the same analysis for the other two courts. Then, withineach court, find the sum of the ranks and get an overall ranking foreach judge. Evaluate and discuss the meaning of your results. Usetables, charts, graphs, or visual dashboards to support your findings.Write a report that adheres to the Written Assignment Requirements under the heading As with all written assignments , you should have in-text citations and a reference page.Your report must contain the following:A title page in APA style.An introduction that summarizes the problem.The body of the paper should answer the questions posed in theproblem by communicating the results of your analysis. Include resultsof calculations, as well as charts and graphs, where appropriate.A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. Submit your Excel file in addition to your report.