Solution) An article (R. Richmond, “Anatomy of a Threat.” The Wall Street Journal, February 13, 2006, pp R5, R
Question: An article (R. Richmond, “Anatomy of a Threat.” The Wall Street Journal, February 13, 2006, pp R5, R6) discussed the costs companies face in defending their networks from attack. The following table provides the breakdown in costs:
| Cost | Percentage |
| Consulting | 7.6 |
| Hardware tools | 8.2 |
| Labor | 25.9 |
| Lost business/revenue | 23.6 |
| Nonproductive employee time | 15.5 |
| Software tools | 14.2 |
| Other | 5.0 |
a. Do you think this chart should have been presented with the percentages in order? Why? I would say yes as when you construct a chart you want it to show the minimum to the maximum numbers. Some charts require specific data to be arranged as excel determines the best way to plot the information.
b. Using Excel construct a bar chart, a pie chart, and a Pareto Chart. Which graphical method do you think is best to portray these data? What conclusions can you reach concerning the costs companies face in defending their networks from attack?
Solution Format: Word Document
