Hamilton County judges 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 those cases are reversed. The Cincinnati Enquirer conducted a study of cases handled by Hamilton County judges over a three-year period. Shown in the Excel file (Judges) are the results of 43,945 cases disposed by 16 judges in the Common Pleas Court. The purpose of the 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 as a data analyst intern. Use your knowledge of probability and descriptive statistics to help with the ranking of the judges. You also may be able to analyze the likelihood of appeal and reversal for the cases handled by the Common Pleas Court.

In this assignment excel report and you will also address the following 5 questions.

1. What is the sum total, average, variance, and standard deviation of appealed cases, reversed cases, and total of cases disposed?
2. What is the probability of each appeal by each judge?
3. What is the rankingof appeals by judge from smallest to largest? Name the three lowest judges that made appeals and explain what this means in the context of appeals at the court.
4. What is the probability of each reversal by each judge?
5. What is the ranking of appeals of each reversal by each judge? Name the three lowest judges that made reversals and explain what this means in the context of appeals at the court.