Matching Items (4)
- All Subjects: Actuarial
- All Subjects: Cystic Fibrosis, Modulator Therapies
- Creators: Zicarelli, John
- Creators: Gilkey, Gina
- Creators: Swoverland, Robert Bo
- Member of: Barrett, The Honors College Thesis/Creative Project Collection
- Status: Published
For years, patients with Cystic Fibrosis (CF) were able to only treat the symptoms of the disease, but advancements over the last decade have made it possible to partially correct the genetic mutation which causes the disease. Treatment for this disease has long been complex due to the number of organs affected by the mutation, but these new modulator therapies add another level of complexity due to the large yearly cost of $300,000. While approvals for the drugs are reaching more age groups in many countries, ease of access still varies due to the reimbursement deals or prescription coverage available in each country.
A factor accounting for the COVID-19 pandemic was added to a generalized linear model to more accurately predict unpaid claims. COVID-19 has affected not just healthcare, but all sectors of the economy. Because of this, whether or not an automobile insurance claim is filed during the pandemic needs to be taken into account while estimating unpaid claims. Reserve-estimating functions such as glmReserve from the “ChainLadder” package in the statistical software R were experimented with to produce their own results. Because of their insufficiency, a manual approach to building the model turned out to be the most proficient method. Utilizing the GLM function, a model was built that emulated linear regression with a factor for COVID-19. The effects of such a model are analyzed based on effectiveness and interpretablility. A model such as this would prove useful for future calculations, especially as society is now returning to a “normal” state.
The objective of this study is to build a model using R and RStudio that automates ratemaking procedures for Company XYZ’s actuaries in their commercial general liability pricing department. The purpose and importance of this objective is to allow actuaries to work more efficiently and effectively by using this model that outputs the results they otherwise would have had to code and calculate on their own. Instead of spending time working towards these results, the actuaries can analyze the findings, strategize accordingly, and communicate with business partners. The model was built from R code that was later transformed to Shiny, a package within RStudio that allows for the build-up of interactive web applications. The final result is a Shiny app that first takes in multiple datasets from Company XYZ’s data warehouse and displays different views of the data in order for actuaries to make selections on development and trend methods. The app outputs the re-created ratemaking exhibits showing the resulting developed and trended loss and premium as well as the experience-based indicated rate level change based on prior selections. The ratemaking process and Shiny app functionality will be detailed in this report.
Catastrophe events occur rather infrequently, but upon their occurrence, can lead to colossal losses for insurance companies. Due to their size and volatility, catastrophe losses are often treated separately from other insurance losses. In fact, many property and casualty insurance companies feature a department or team which focuses solely on modeling catastrophes. Setting reserves for catastrophe losses is difficult due to their unpredictable and often long-tailed nature. Determining loss development factors (LDFs) to estimate the ultimate loss amounts for catastrophe events is one method for setting reserves. In an attempt to aid Company XYZ set more accurate reserves, the research conducted focuses on estimating LDFs for catastrophes which have already occurred and have been settled. Furthermore, the research describes the process used to build a linear model in R to estimate LDFs for Company XYZ's closed catastrophe claims from 2001 \u2014 2016. This linear model was used to predict a catastrophe's LDFs based on the age in weeks of the catastrophe during the first year. Back testing was also performed, as was the comparison between the estimated ultimate losses and actual losses. Future research consideration was proposed.