Show your calculations in an Excel or Google Sheets spreadsheet and upload.   Suppose that two different network firewall software applications are being tested by a new small business. Two firewalls

Show your calculations in an Excel or Google Sheets spreadsheet and upload.  

Suppose that two different network firewall software applications are being tested by a new small business. Two firewalls were tested, A and B. Suppose that over one month of time, the below types of spyware/malware were passed through onto the network by these firewalls. Answer the following questions.

                              Key Loggers   Cookies     Hijackers     Trojan Horses

Firewall A                 4                      184                 0                                2

Firewall B                 4                       166                 2                               5

1. What percentage of all spyware/malware in this test was not captured by A.
2. Of the hijackers, what percentage were allowed by Firewall B.
3. If I chose a security issue at random, what is the probability that it was either a key logger or trojan horse.
4. If I chose a security issue at random, and given that it was not blocked by B, what is the probability that the issue not blocked by B was a cookie.