Have to answer the questions using the excel data file.

I’m attaching excel data file(Data – Case – Week – 3 – Judges.xlsx).

have to answer all questions below.

========Question:

Hamilton 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. Kristen DelGuzzi of The Cincinnati Enquirer conducted a study of cases handled by Hamilton County judges over a three-year period.

Shown in data – Judges are the results for 182,908 cases handled (disposed) by 38 judges in Common Pleas Court, Domestic Relations Court, and Municipal Court. Two of the judges (Dinkelacker and Hogan) did not serve in the same court for the entire 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. Also, include an analysis of the likelihood of appeal and case reversal in the three courts.

At a minimum, your report should include the following:

1. The probability of cases being appealed and reversed in 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 your choice.

No PlagiarismAPA Formaturgent

2

>Data

3

3

7

72

Common

4

8 Common

0

7 Common

8

7 Common

64

Common

22 Common

59

Common

1

Common

3

137

Common

121 6 Common

12 Common

18 Common

10 Common

127 13 Common

6 Common

7 1

19 4 Domestic

9 Domestic

32 3 Domestic

4

6 Muni

41 6 Muni

43 5 Muni

2

35 13 Muni

6 0 Muni

5 0 Muni

29 5 Muni

13 2 Muni

6 1 Muni

25 8 Muni

9 Muni

34 7 Muni

13 1 Muni

28 9 Muni

7 3 Muni

41 13 Muni

33 6 Muni

22 4 Muni

4 2 Muni