Question: Download and use the data from below link to answer the following questions: https://docs.google.com/spreadsheets/d/1nnGY8Nh5qE5q_lWaftCOYOTzv4hOLEUr/edit?usp=sharing&ouid=112329878583935125425&rtpof=true&sd=true Solve following Questions using R software Pick a year (2007) and

Download and use the data from below link to answer the following questions:

https://docs.google.com/spreadsheets/d/1nnGY8Nh5qE5q_lWaftCOYOTzv4hOLEUr/edit?usp=sharing&ouid=112329878583935125425&rtpof=true&sd=true

Solve following Questions using R software

  1. Pick a year (2007) and filter the data based on the chosen year.
  2. Fit the Frequency data to the following distribution: Binomial distribution, Negative binomial distribution, Poisson distribution
  3. Determine whether the frequency data fit any of the distribution in Question number 2. Provide your analysis.
  4. Fit the Severity data to at least 3 (three) continuous distributions. Perform an analysis on the results.
  5. Using Monte Carlo Simulation, carry out aggregate loss modeling using the fitted distribution(s) in Question number 2 and number 3.
  6. Estimate the following measures: Expected Loss, Value-at-Risk (99% confidence level), Expected Shortfall (99% confidence level)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Using excell sheets and Data for group (31) , please solve the followibg project 3. They should study "Appendix A' and the following book examples on how to use spreadsheets to solve specific...

Q:

1. Download the dataset, "Climate indicators 2021.xls" from the files area of ELMS 2. Use the data you find there to answer the following questions: A) With these data, is there support for the...

Q:

A company needs a modern material handling system for facilitating access to and from a busy warehouse. If the company's management use a MARR (given in the below table for each group) in their...

Q:

Required, part 2 section c, best solved through excel please include method of solving. A company needs a modern material handling system for facilitating access to and from a busy warehouse. If the...

Q:

Please can you with help me with these problems. I tried to work on them tirelessly but I don't understand it. However am allow to consult a tutor for help. This is the web link to the data...

Q:

Version - Applied Analytics Part 4 Step 1: Import the data Connect to the Excel file. "Business Analytics Tableau Lab Quiz". There is just one worksheet, "invoices Tables should automatically import...

Q:

Question 1 Ongoing Analysis Project An important part of learning is application. To learn accounting, we must practice the skills taught and apply those skills to real-world problems. To that end,...

Q:

Lab Assignment - Sentiment Analrsis and SVM [ 8 marks] We will analyze positive and negative reviews comments of a movie. You will use the movie dataset provided for this lab assignment accessible...

Q:

The following Tableau dashboard is an analysis of the Dow Jones industrial Average (DOW) from its inception to 2015 . The Dow is an index fund consisting of 30 large public companies listed on stock...

Q:

1) Which of the following transaction costs could impact the profitability of a trade? a) Broker fee b) Bid-ask spread c) Depth d) Price Impact e) A, B, and D 2) You have the opportunity to invest in...

Q:

Suppose that the number of minutes a person must wait for a bus each morning has the uniform distribution on the interval [0, ], where the value of the endpoint is unknown. Suppose also that the...

Q:

Cutler Compacts will generate cash flows of $30,000 in year 1, and $65,000 in year 2. However, if it makes an immediate investment of $20,000, it can instead expect to have cash streams of $55,000 in...

Q:

Assuming the correlation between stocks and bonds is 0 . 3 0 , compute the standard deviation of the combined risky portfolio ( use % and three decimals ) . ? 1 5 . 2 4 % 1 2 . 6 4 % 1 2 . 7 9 % 1 5...

Q:

5. (20 points). North Pine ATV (fictional company) is a major firm in the all-terrain vehicle industry. While still growing, the growth rate of this industry has slowed, making it a mature industry....

Q:

1. Discuss the following statements: (a) The dangers of mountain driving in an old Lada 4 4, and safety concerns. (b) We perceive the world backwards. (c) Numbers are different from words, but they...

Q:

5. How can a sender (utterer) directly influence the interpreter (receiver)?

Q:

10. Find a news article in a daily newspaper, and answer the following questions: (a) Does the information in the article support your views and attitudes or does it conflict with them? (b) Does the...