help answer all pls

The management at HMT is very concerned about security incidents that have been occurring at their facilities. Nonetheless - these people are MBAs and lawyers who really don't understand security issues. Therefore, using the Heavy Metal Technology Case prepare a clear and accurate security assessment for upper management's understanding. This case must include a: 1. Valid set of summary statistics for security events by event category (connect the dots in the HMT case narrative) 2. Valid set of analyses of event trends using the "formulas" tab of Microsoft Excel. At a minimum record and display descriptive measures used to generate graphs 3. Clear set of graphs and charts using the Excel data. Illustrate the trends in security incidents over the past year 4. Clear set of recommendations derived from the data. This is a problem-solving exercise so prioritize your findings into a data supported action plan. Write up that plan including your approach to solving the