Data analytics
Please find attached the question and prepared the managerial report using the excel data.
Apa stylePlagiarism free
Case Hamilton County Judges – Data: – Judges.xlsx
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.
· Write a summary analysis of the problems and answers
>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 Muni2
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
Patrick Dinkelacker
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
Timothy Hogan
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