Instructions For Using Data On Each Sheet

Instructionsinstructionsusing The Data Provided On Each Sheet Of This

Using the data provided on each sheet of this spreadsheet, create specific types of graphs as instructed. Each sheet corresponds to a different graph type, including pie charts, histograms, line graphs, column graphs, and bar graphs. Follow the detailed instructions for each graph, ensuring to use the sheet titles as graph titles and to label each axis appropriately. The assignment is worth 200 points and is due in the last week of class by 10:00 PM. If you have questions, consult the provided link for detailed instructions on creating graphs in Excel.

Paper For Above instruction

The task involves creating multiple types of graphs using provided data, each aligned with specific instructions to illustrate distinct statistics and trends related to complaints and referrals within an organization. These graphs include pie charts representing complaint dispositions, histograms for allegations, line graphs for complaint history over a decade, column graphs summarizing actions taken, and custom graphs visualizing the frequency of ethics code provisions addressed in formal opinions.

To begin, the pie chart illustrating complaints from 2020 must accurately reflect the data: out of 243 complaints and referrals, 123 were dismissed for lack of sufficiency, 4 dismissed because public interest would not be served, 1 withdrawn, 91 ordered for investigation, and 24 pending a legal determination. The slices should be labeled with percentage shares, and the chart should be titled using the sheet name.

Next, a horizontal bar graph depicting allegations involving 91 complaints ordered for investigation should be constructed based on categories such as voting conflicts, unauthorized compensation, gifts, employment restrictions, and others. Each category's count should be clearly shown, facilitating comparison across allegations.

The line graph should show the number of complaints received annually over ten years, highlighting trends such as increases or decreases in complaint volume over time. Data points should be plotted accurately, with a descriptive title and labeled axes.

For the column graph summarizing actions taken in 2020, each action type (e.g., dismissals, hearings, violations, stipulations) should be represented with the number of cases. The graph must clearly compare the actions, aiding in understanding the disposition of complaints.

Finally, the custom graph depicting instances where ethics provisions were addressed in formal opinions should reflect the frequency of topics like voting conflicts, gifts from lobbyists, financial disclosures, and conflicts of employment. Multiple issues may be addressed in a single opinion, so the graph should account for overlapping topics, perhaps through a stacked bar or similar style.

Overall, these visualizations should be accurate, well-labeled, and professionally formatted to clearly convey the data insights. Correct use of Excel's graphing tools, attention to titles and labels, and adherence to the instructions will be critical in successfully completing this assignment.

References

  • Excel Easy. (2020). How to Create a Pie Chart in Excel. Retrieved from https://www.excel-easy.com/examples/pie-chart.html
  • Microsoft Support. (2021). Create a Chart from Start to Finish. Retrieved from https://support.microsoft.com/en-us/excel
  • Chambers, J. (2014). Visualizing Data with Excel. Wiley.
  • Few, S. (2009). Now You See It: Simple Visualization Techniques for Quantitative Data. Analytics Press.
  • Evergreen, S. D. (2017). Effective Data Visualization: The right Chart for the Right Data. Sage Publications.
  • Kirk, A. (2016). Data Visualisation: A Handbook for Data Driven Design. Sage Publications.
  • Curtis, M. (2015). Mastering Data Visualization with Excel. Packt Publishing.
  • Stone, D. (2018). Understanding the Power of Graphs and Charts. Statistics in Practice.
  • Harvard Business Review. (2018). The Data Visualisation Toolkit. Retrieved from https://hbr.org/2018/09/the-data-visualization-toolkit
  • Evergreen, S. (2010). Presenting Data Effectively: Communicating with Clarity and Impact. SAS Institute.

Related Assignments