Graphing

GraphingAssignment.xlsx

Instructions

Instructions
Using the data provided on each sheet of this spread sheet create a graph using the instructions
provided. Each sheet is a different type of graph. This assignment is worth 200 points and is
due the last week of class by 10:00 PM.
If you have any questions regarding the assignnment please let me know. I have attached a
link for instructions on how to create a graph in excel.
NOTE:	Be sure to use the title of each sheet for each graph and label each axis.
How to Make a Graph in Excel: A Step by Step Detailed Tutorial (workzone.com)

Complaints
Using the following data create a pie graph.
Of the 243 complaints and referrals received in 2020:
	123 - were dismissed for lack of sufficiency
	4 - were dos,ossed becaise the public interest would not be served
	1 - was withdrawn
	91 - were ordered to be investigated
	24 - were pending a legal sufficiency determination
POSITION	NUMBER OF COMPLAINTS	PERCENT OF TOTAL
State Elected	12	4.90%
State Appointed	2	0.80%
State Employee	7	2.90%
District Elected	28	11.50%
District Appointed	2	0.80%
District Employee	6	2.50%
County Elected	48	19.80%
County Appointed	2	0.80%
County Employee	28	11.50%
Municipal Elected	62	25.50%
Municipal Appointed	9	3.70%
Municipal Employee	7	2.90%
Candidate	19	7.80%
Lobbyist	4	1.60%
Other	7	2.90%
TOTOAL	243	100.00%

Allegations
Using the following data create a horizontal bar graph
Of the 243 complaints and referrals received in 2020, 91 had been ordered to be investigated as of December 31, 2020.
A breakdown of the allegations made in complaints found sufficient for investgation is illustrated below. Many complaints
contained allegations concerning more than one area of law. Using the informaiton below create a horizontal bar graph
depicting the number of complaints per category
Category	Number of complaints
Voting Conflict	5
Unauthorized Compensation	4
Solicitation or acceptance of gifts	4
Restriction on Employment of Relatives	5
Reporting and prohibited receipt of gifts	4
Misue of public position	55
Local government attorneys	1
Lobbyist audit investiation	4
Full and public disclousre of financial interests	23
Form 6 willful failure to file	1
Dual public employment	1
Doing business with ones agency	2
Disclosure or use of certain ifnormation	7
Disclosure of financial interests	3
Conflicting employment or contractual relationship	5

10 Year History of Complaints
Using the data below create a line graph depicting a 10 year history of complaints
Year	Number of Complaints
2020	243
2019	231
2018	211
2017	180
2016	220
2015	244
2014	259
2013	210
2012	296
2011	169

Summary of Actions Taken
The following is a summary of the number of actions taken in 2020. Create a bar graph depicting
the type of complaint and the number of complaints investigated
Action Taken	Number of Cases
Dismissed for lack of legal suggiciency	234
dismissed as public interest not served by further proceedings	144
Dismissed for lack of jurisdiciton	9
Dismissed due to death of respondend	4
Probably Cause Hearings Held	1
No probable cause - dismissed	66
Probably Cause Hearings Held	42
Probable cause - no further action	16
Stipulations	8
Violation	8
Publc hearings at the Division of Administrative Hearings	8
Violation	2
No Violation Costs and attorney's fees petitions	1
Costs and attorney's fees petitions	1
Awarded	0
Insufficient petition - dismised	1
Total Number of Actions Taken on Complaints	235

Advisory Opinions
Creat a graph of your choice in style depicting the number of instances in which a provision of the ethics code was
addressed in a formal opinion of the Commission in 2020. A number of opinions addressed more than one
aspect of the ethics laws.
Provision of the Code	Number of Instances
Voting conflicts	4
Gifts from Lobbyists or the principals	1
Finanical disclosure	1
Executive branch expenditures	1
Doint business with one's aggency	5
Conflicting eimployment or contractual relationship	8