Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Use the data in these tables to complete the tasks below. Frequency Severity Probability m Probability Tasks 1. Calculate the mean and standard deviation

image text in transcribed
image text in transcribed
Data Use the data in these tables to complete the tasks below. Frequency Severity Probability m Probability Tasks 1. Calculate the mean and standard deviation statistics for the frequency and severity distributions respectively. 2. Calculate the mean and standard deviation of the aggregate loss distribution using the results of Task 1. 3. Develop the aggregate loss distribution by calculating the probability of each outcome analytically. 4. Simulate the aggregate loss distribution. Conduct a simulation with N=100 trials and N=1000 trials. Submit two (2) printed products: a. One document that shows how you set up the problem and the value results of the first five (5) simulation trials. b. A second document that shows the formulas for the set up and the first five (5) simulation trials. 5. Calculate the mean and standard deviation of the simulated aggregate losses using the aggregate loss distribution developed in Task 4. Discuss how well you were able to replicate the actual distribution and compare your simulation results based on 100 trials and 1000 trials. 6. Create three (3) separate graphs in Excel: a. The actual probability distribution you calculated in Task 3 b. The loss distribution based on 100 trials c. The loss distribution based on 1000 trials

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis And Decision Making

Authors: Christian Albright, Wayne Winston, Christopher Zappe

4th Edition

538476125, 978-0538476126

More Books

Students also viewed these Finance questions