Hamilton County judges try thousands of cases per year In an overwhelming majority of cases disposed
the verdict stands as rendered. However, some cases are appealed, and of those appealed, some of the
cases are reversed. Kristen Del Guzzi of The Cincinnati Enquirer conducted study of cases handled by
Hamilton County judges over three- year period. Shown in the tables on pages 2 and 3 are the results for
214,647 cases handled (disposed) by 42 judges in Common Pleas Court Domestic Relations Court and
Municipal Court. Use the data on pages and for this assignment; copy and paste into Excel
The purpose of the newspaper' study was to evaluate the performance of the judges. Appeals often are
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 assist in the data analysis.
Use your knowledge of probability and conditional probability thelp with the ranking of the judges.
You will also analyze the likelihood of appeal and reversal for cases handled by different courts.
First, include your name asone of the judges in any two of the three courts then add n numbers of total
cases disposed. appealed cases and reversed cases for yourself that are within the current range of the
Prepare report with your rankings of the judges
Include an analysis of the likelihood of Appealed cases and cases Reversed in each of the three courts
minimum, your report should include the following five (5) items in your report:
The probability of cases being appealed and reversed in the three different courts.
2. The probability of case being appealed for each judge
The probability of a case being reversed for each judge
The probability of reversal given an appeal for each judge
Rank the judges within cach court based on three probabilities above in questions 2, & 4
State the criteria you used to rank the judges.
TIP Excel has RANK function =R ANK(number, ref order)
Number the number (cell address of what value you wish to rank) whose rank you want to find
Ref the range of the list of numbers to be ranked
Order specifies how to rank the number; Ois descending (high to low) and is ascending (low to high)
Example: =RANK(AI ,A1:A100,1 Rank the value in A1, using list in column A. in ascending order.
Your report must contain the following
Cover page. page numbers and Times New Roman 11 point font
An introduction that summarizes the problem
Each case study question should be answered (this means discussed not just numbers) with
complete interpretation of results (see the Rubric in Canvas for this assignment)
Include results of calculations and state on which worksheet in Excel the calculations can
Excel worksheets MUST be appropriately named
A conclusion paragraph that addresses your findings and what you have determined (insight)
from the data and your analysis
Common Pleas Court
Ann Marie Tracey
Arthur Ney Jr.
J Howard Sundermann Jr.
Domestic Relations Court
James Patrick Kenney
Leslie Isaiah Gaines
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction
of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice.
Unethical use is strictly forbidden.