IF YOU COULD PLEASE CREATE AN EXCEL SPREADSHEET AND ANSWER EACH QUESTION AS A DIFFERENT SHEET USING EXCEL 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 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 detailed analysis and rankings of the judges Also include an analysis of the likelihood of appeal and case reversal in the three courts At minimum, your report should include the following The probability of cases being appealed and reversed in the three different courts The probability of a 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 each court State the criteria you used and provide a rationale for your choice Judge Disposed Appealed Reversed Court Fred Cartolano 3037 137 12 Common Thomas Crush 3372 119 10 Common Patrick Dinkelacker 1258 44 8 Common Timothy Hogan 1954 60 7 Common Robert Kraft 3138 127 7 Common William Mathews 2264 91 18 Common William Morrissey 3032 121 22 Common Norbert Nadel 2959 131 20 Common Arthur Ney Jr 3219 125 14 Common Richard Niehaus 3353 137 16 Common Thomas Nurre 3000 121 6 Common John O'Connor 2969 129 12 Common Robert Ruehlman 3205 145 18 Common J Howard Sundermann Jr 955 60 10 Common Ann Marie Tracey 3141 127 13 Common Ralph Winkler 3089 88 6 Common Penelope Cunningham 2729 7 1 Domestic Patrick Dinkelacker 6001 19 4 Domestic Deborah Gaines 8799 48 9 Domestic Ronald Panioto 12970 32 3 Domestic Mike Allen 6149 43 4 Municipal Nadine Allen 7812 34 6 Municipal Timothy Black 7954 41 6 Municipal David Davis 7736 43 5 Municipal Leslie Isaiah Gaines 5282 35 13 Municipal Karla Grady 5253 6 0 Municipal Deidra Hair 2532 5 0 Municipal Dennis Helmick 7900 29 5 Municipal Timothy Hogan 2308 13 2 Municipal James Patrick Kenney 2798 6 1 Municipal Joseph Luebbers 4698 25 8 Municipal William Mallory 8277 38 9 Municipal Melba Marsh 8219 34 7 Municipal Beth Mattingly 2971 13 1 Municipal Albert Mestemaker 4975 28 9 Municipal Mark Painter 2239 7 3 Municipal Jack Rosen 7790 41 13 Municipal Mark Schweikert 5403 33 6 Municipal David Stockdale 5371 22 4 Municipal John A West 2797 4 2 Municipal

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 27, 2024

IF YOU COULD PLEASE CREATE AN EXCEL SPREADSHEET AND ANSWER EACH QUESTION AS A DIFFERENT SHEET. USING EXCEL The purpose of the newspaper's study was

IF YOU COULD PLEASE CREATE AN EXCEL SPREADSHEET AND ANSWER EACH QUESTION AS A DIFFERENT SHEET. USING EXCEL

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 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 detailed analysis and rankings of the judges. Also include an analysis of the likelihood of appeal and case reversal in the three courts. At minimum, your report should include the following:

The probability of cases being appealed and reversed in the three different courts.
The probability of a 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 each court. State the criteria you used and provide a rationale for your choice

Judge	Disposed	Appealed	Reversed	Court
Fred Cartolano	3037	137	12	Common
Thomas Crush	3372	119	10	Common
Patrick Dinkelacker	1258	44	8	Common
Timothy Hogan	1954	60	7	Common
Robert Kraft	3138	127	7	Common
William Mathews	2264	91	18	Common
William Morrissey	3032	121	22	Common
Norbert Nadel	2959	131	20	Common
Arthur Ney Jr.	3219	125	14	Common
Richard Niehaus	3353	137	16	Common
Thomas Nurre	3000	121	6	Common
John O'Connor	2969	129	12	Common
Robert Ruehlman	3205	145	18	Common
J. Howard Sundermann Jr.	955	60	10	Common
Ann Marie Tracey	3141	127	13	Common
Ralph Winkler	3089	88	6	Common
Penelope Cunningham	2729	7	1	Domestic
Patrick Dinkelacker	6001	19	4	Domestic
Deborah Gaines	8799	48	9	Domestic
Ronald Panioto	12970	32	3	Domestic
Mike Allen	6149	43	4	Municipal
Nadine Allen	7812	34	6	Municipal
Timothy Black	7954	41	6	Municipal
David Davis	7736	43	5	Municipal
Leslie Isaiah Gaines	5282	35	13	Municipal
Karla Grady	5253	6	0	Municipal
Deidra Hair	2532	5	0	Municipal
Dennis Helmick	7900	29	5	Municipal
Timothy Hogan	2308	13	2	Municipal
James Patrick Kenney	2798	6	1	Municipal
Joseph Luebbers	4698	25	8	Municipal
William Mallory	8277	38	9	Municipal
Melba Marsh	8219	34	7	Municipal
Beth Mattingly	2971	13	1	Municipal
Albert Mestemaker	4975	28	9	Municipal
Mark Painter	2239	7	3	Municipal
Jack Rosen	7790	41	13	Municipal
Mark Schweikert	5403	33	6	Municipal
David Stockdale	5371	22	4	Municipal
John A. West	2797	4	2	Municipal