Ivan.Rivera6.MM305_Unit2_Project - b. Using Excel construct...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MM305 Quantitative Analysis for Managers Unit 2 Project Please download this document to your computer and save it using the naming  convention specified in the course syllabus.  After completing and saving the project  problems, submit your project in the Drop Box for Unit 2. 1. 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?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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? 2. Using Excel Add-in Data Analysis and the following data: X = Years with company Y = Shares of company stock 6 300 12 408 14 560 6 252 9 288 13 650 15 630 9 522 a. What are the measures of central tendency and the standard deviation for both the X and Y data? b. What is the correlation between X and Y? c. Create a Scatter Diagram for these data. d. How would you describe this correlation?...
View Full Document

This note was uploaded on 07/06/2011 for the course MM 305 taught by Professor Fulton during the Fall '09 term at Kaplan University.

Page1 / 2

Ivan.Rivera6.MM305_Unit2_Project - b. Using Excel construct...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online