4.xlsx - Risk event Impact Total lose Likelihood Expected...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Risk ID x= 5 3,000,000 0.3 0.7 0.21 630,000 300,000 2 5,000,000 0.1 0.2 0.02 100,000 600,000 3 1,000,000 0.1 0.5 0.05 50,000 900,000 4 700,000 0.2 0.2 0.04 28,000 1,200,000 1 100,000 0.5 0.2 0.1 10,000 1,500,000 1,800,000 2,100,000 2,400,000 2,700,000 3,000,000 3,300,000 3,600,000 3,900,000 4,200,000 4,500,000 4,800,000 5,100,000 Total lose (L t ) Risk event probability (P e ) Impact probability (P i ) Likelihood (R L ) Expected Loss(L e ) 0 2,000,000 4,000,000 6,000,000 0 0.2 0.4 0.6 0.8 1 1.2 Risk y=300,000/x
Image of page 1

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

View Full Document Right Arrow Icon
x= y=300,000/(x^2) x= 1 300,000 3.33333E-006 300,000 1 0.5 600,000 8.33333E-007 600,000 0.5 0.333333 900,000 3.70370E-007 900,000 0.333333 0.25 1,200,000 2.08333E-007 1,200,000 0.25 0.2 1,500,000 1.33333E-007 1,500,000 0.2 0.166667 1,800,000 9.25926E-008 1,800,000 0.166667 0.142857 2,100,000 0.000000068 2,100,000 0.142857 0.125 2,400,000 5.20833E-008 2,400,000 0.125 0.111111 2,700,000 4.11523E-008 2,700,000 0.111111 0.1 3,000,000 3.33333E-008 3,000,000 0.1 0.090909 3,300,000 2.75482E-008 3,300,000 0.090909 0.083333 3,600,000 2.31481E-008 3,600,000 0.083333 0.076923 3,900,000 1.97239E-008 3,900,000 0.076923 0.071429 4,200,000
Image of page 2
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern