Hamilton County Judges(95 points)
Read the Hamilton County Judges case study and please provide a Managerial Report that includes the following:
1.The probability of cases being appealed and reversed in each of 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 the ranking method you used.
For ease in calculating your statistics, you can either hand enter the data into Excel or use the Student Webfile file Judge from the Cengage website.
Write a short report that includes an introduction, a body which answers the questions posed in the problem and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. Please include any tables of calculations and graphs associated with this problem in the body. NOTE: Submitting your Excel file will aid in grading if errors are found in the paper.
Probabilities need to be calculated in the Excel file. Along with a brief explain how the numbers are calculated, and a written explanation for the last part.