The data is included below in an Excel File. Thanks

In this part of your project, you will be asked to evaluate the performance of the judges in County X of Ohio. Here is the background:

The judges of County X try thousands of cases per year. Although in a big majority of the cases disposed the verdict stands as rendered, some cases are appealed. Of those appealed, some are reversed. Because appeals are often made as a result of mistakes by the judges, you want to determine which judges are doing a good job and which ones are making too many mistakes.

The attached Excel file has the results of 182,908 disposed cases over a three year period by the 38 judges in various courts of County X. Two of the judges (Judge 3 and Judge 4) did not serve in the same court for the entire three-year period. Using your knowledge of probability and conditional probability you will make an analysis to decide a ranking of judges. You will also analyze the likelihood of appeal and reversal for cases handled by different courts.

The Excel 2 file is attached in the Final Project learning object. It provides the data for the total cases disposed, numbers of appealed cases and the numbers of reversed cases for judges in each court.

Using Excel or SAS Studio, calculate the following probabilities for each judge. Use the attached Excel file to fill in these numbers on the tables for each court. Each court is given on a separate tab.

1.The probability of a case being appealed for each judge.

2.The probability of a case being reversed for each judge.

3.The probability of a reversal given an appeal for each judge.

4.Probability of cases being appealed and reversed in the three courts.

5.Rank the judges within each court.

Probability Distribution of the Number of Families per Parish of German Immigrants on Board the ship NueWelt in mid-18th century Number of Families Probablility per Parish 1 0.706 2 0.176 3 0.000 4 0.059 5 0.000 6 0.059 Probability Distribution of the Known Numbers of Freights Purchased by the German Families on Board the ship NueWelt in mid18th century Number of Freights 1.0 1.5 2.0 2.5 3.0 3.5 4.0 5.0 6.0 Probability 0.075 0.025 0.425 0.150 0.125 0.100 0.050 0.025 0.025 Probablility Distribution of the Known Numbers of People in a Family for the Germans on Board the ship NueWelt in mid-18th century Number in Family 1 2 3 4 5 6 7 8 9 Probability 0.322 0.186 0.136 0.102 0.051 0.136 0.034 0.017 0.016