Download this spreadsheet that contains the exported data for you to use to comp – graduate researcher

Download this spreadsheet that contains the exported data for you to use to complete this assignment. Download spreadsheet that contains the exported data for you to use to complete this assignment.
Once you open this spreadsheet, you will see two tabs at the bottom left. The first tab labeled ‘Table 1″ contains the referenced website’s multi-year table. Next to the first tab is a second tab labeled ‘Graphs & Conclusion”. This second tab is where you will put the two graphs that you will create and your conclusion.
If you are not familiar with creating charts in Excel, please review the links I provided in the Resources below to learn how.
Complete the spreadsheet by learning to:
Create the bar graph showing the number of data breaches year-by-year by an entity (Banking/Credit/Financial, Business, Educational, Government/Military, and Medical/Healthcare) from 2005 to 2018. Put this graph in the second tab.
Create a second bar graph showing the number of breaches year-by-year by method (Insider theft, hacking, unauthorized access, data on the move, accidental Web/Internet exposure, Employee/error/negligence/improper disposal/lost, physical theft). Put this bar graph below the first bar graph.
Make sure to label the two axes and give a title for each bar chart
Make sure that both charts have the appropriate legends
Learn how to resize rows together to create a text field large enough to contain your answer. Write substantive answers (maximum of 600 words) below the two bar charts to answer the three questions:
In which entity is the number of data breaches per industry increasing fastest?
In which entity is the number of data breaches per method increasing the fastest?
What other conclusions can you draw from each of, or both of, the bar graphs?
Verify that you have picked the appropriate bar graphs to answer the questions.
Remember to apply as many concepts and terminologies from chapters 5 and 6 to illustrate your understanding of the materials.
Submit your completed spreadsheet.
How to format my report:
The document must be a Microsoft Excel spreadsheet since this objective is for you to learn Microsoft Excel.
Make sure to write with complete sentences (as an essay) and not just use a list of bullets. Your writing skills are assessed along with your understanding of this chapter.
Make sure to cite all references used following the APA6th guideline.