Posted: January 24th, 2023

Data Analytics case 3

Have to answer the questions using the excel data file.

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

Don't use plagiarized sources. Get Your Custom Essay on
Data Analytics case 3
Just from $13/Page
Order Essay

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

Patrick Dinkelacker

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

Timothy Hogan

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

Judge Disposed Appealed Reversed Court
Fred Cartolano 3 0 7 1 12 Common
Thomas Crush 33 1

1

9 10
Patrick Dinkelacker 12

5 8 4
Timothy Hogan 1954 6
Robert Kraft 3

13 127
William Mathews 22 91 18
William Morrissey 30

32 121
Norbert Nadel 29 131 20
Arthur Ney Jr. 3219 25 14
Richard Niehaus 3

35 16
Thomas Nurre 3000
John O’Connor 2969 129
Robert Ruehlman 3205 145
J. Howard Sundermann Jr. 955 60
Ann Marie Tracey 31

41
Ralph Winkler 3089 88
Penelope Cunningham 2729 Domestic
6001
Deborah Gaines 8799 48
Ronald Panioto 12970
Mike Allen 6149 43 Muni
Nadine Allen 7812 34
Timothy Black 7954
David Davis 7736
Leslie Isaiah Gaines 5

28
Karla Grady 5253
Deidra Hair 2532
Dennis Helmick 7900
2308
James Patrick Kenney 2798
Joseph Luebbers 4698
William Mallory 8277 38
Melba Marsh 8219
Beth Mattingly 2971
Albert Mestemaker 4975
Mark Painter 2239
Jack Rosen 7790
Mark Schweikert 5403
David Stockdale 5371
John A. West 2797

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00

Order your essay today and save 20% with the discount code Newyr