Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment Mercer Paints Risk Assessment ExposureProbability of Occurrence ( % ) Average Loss (
Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment Mercer Paints Risk Assessment ExposureProbability of Occurrence Average Loss $Malware attack$Data loss$Embezzlement$User errors$Threats from hackers$Improper use by employees$Power failure$ Mercer paints is a paint manufacturing company located in New Jersey that uses a network to link its business operations. A security risk assessment that management requested identified a number of potential exposures. These exposures, their associated probabilities, and average losses are summarized in the table above. Use the table to answer the following questions: Identify two additional exposures, assign probabilities of occurrences, and average losses to your additional exposures. Use Excel to input the table and create a fourth column call Expected Annual Loss and calculate the expected annual loss for each exposure. Sum the expected annual losses and create a pie chart for each exposure based on the exposure and expected annual loss Highlight your results by filling the rows with Yellow fill for the top three exposures. Upload your spreadsheet to the appropriate dropbox.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started