Filtering by
- All Subjects: Actuarial Science
- All Subjects: Actuarial
- Creators: Zicarelli, John
- Creators: Clermont, Nicholas Charles
- Creators: Gilkey, Gina
- Creators: Swoverland, Robert Bo
- Member of: Barrett, The Honors College Thesis/Creative Project Collection
- Status: Published
![133403-Thumbnail Image.png](https://d1rbsgppyrdqq4.cloudfront.net/s3fs-public/styles/width_400/public/2021-05/133403-Thumbnail%20Image.png?versionId=i34dNYHZ_Fj8Kga8OW4BWEe9krbKMoyt&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASBVQ3ZQ42ZLA5CUJ/20240425/us-west-2/s3/aws4_request&X-Amz-Date=20240425T133903Z&X-Amz-SignedHeaders=host&X-Amz-Expires=120&X-Amz-Signature=ca4fa5b1666cd42e4a24aeb1fa59e984f731e8105a4ab58447622836cfe34592&itok=gGztuTNO)
![133413-Thumbnail Image.png](https://d1rbsgppyrdqq4.cloudfront.net/s3fs-public/styles/width_400/public/2021-05/133413-Thumbnail%20Image.png?versionId=wo7P9kXmqqAHxKLqC6469YdIsTrUM5tv&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASBVQ3ZQ42ZLA5CUJ/20240425/us-west-2/s3/aws4_request&X-Amz-Date=20240425T033024Z&X-Amz-SignedHeaders=host&X-Amz-Expires=120&X-Amz-Signature=52418f58c0e3f77118aaea8b729b558cacf8e9717adf858448a043653ee695cc&itok=U6R6e6hB)
![147953-Thumbnail Image.png](https://d1rbsgppyrdqq4.cloudfront.net/s3fs-public/styles/width_400/public/2021-07/147953-Thumbnail%20Image.png?versionId=JV3qohFq3zpL1XwOH7DDriG.9aDkMk.Z&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASBVQ3ZQ42ZLA5CUJ/20240425/us-west-2/s3/aws4_request&X-Amz-Date=20240425T114151Z&X-Amz-SignedHeaders=host&X-Amz-Expires=120&X-Amz-Signature=f08789492f68dce4173cd4ca7aa22db5a4a61be76576a83d4e2d5a30f6893441&itok=AD7EIh1f)
Actuaries can analyze healthcare trends to determine if rates are reasonable and if reserves are adequate. In this talk, we will provide a framework of methods to analyze the healthcare trend during the pandemic. COVID-19 may influence future healthcare cost trends in many ways. First, direct COVID-19 costs may increase the amount of total experienced healthcare costs. However, with the implementation of social distancing, the amount of regularly scheduled care may be deferred to a future date. There are also many unknown factors regarding the transmission of the virus. Implementing epidemiology models allows us to predict infections by studying the dynamics of the disease. The correlation between infection amounts and hospitalization occupancies provide a methodology to estimate the amount of deferred and recouped amounts of regularly scheduled healthcare costs. Thus, the combination of the models allows to model the healthcare cost trend impact due to COVID-19.
The Mack model and the Bootstrap Over-Dispersed Poisson model have long been the primary modeling tools used by actuaries and insurers to forecast losses. With the emergence of faster computational technology, new and novel methods to calculate and simulate data are more applicable than ever before. This paper explores the use of various Bayesian Monte Carlo Markov Chain models recommended by Glenn Meyers and compares the results to the simulated data from the Mack model and the Bootstrap Over-Dispersed Poisson model. Although the Mack model and the Bootstrap Over-Dispersed Poisson model are accurate to a certain degree, newer models could be developed that may yield better results. However, a general concern is that no singular model is able to reflect underlying information that only an individual who has intimate knowledge of the data would know. Thus, the purpose of this paper is not to distinguish one model that works for all applicable data, but to propose various models that have pros and cons and suggest ways that they can be improved upon.
![165134-Thumbnail Image.png](https://d1rbsgppyrdqq4.cloudfront.net/s3fs-public/styles/width_400/public/2022-05/165134-thumbnail-image.png?versionId=0m8xJV2lgJZQ.hzoRhDz6OfsHZmyZfzv&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASBVQ3ZQ42ZLA5CUJ/20240425/us-west-2/s3/aws4_request&X-Amz-Date=20240425T033336Z&X-Amz-SignedHeaders=host&X-Amz-Expires=120&X-Amz-Signature=4e35db24780a4d6681cdd49db226ebf87aaa9f502d297b2fd9999c906757813c&itok=vM-l54Iw)
![165923-Thumbnail Image.png](https://d1rbsgppyrdqq4.cloudfront.net/s3fs-public/styles/width_400/public/2022-05/165923-thumbnail-image.png?versionId=q0dU36LrWtCajvS4gu9MDtCvID3N9Mkp&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASBVQ3ZQ42ZLA5CUJ/20240425/us-west-2/s3/aws4_request&X-Amz-Date=20240425T033336Z&X-Amz-SignedHeaders=host&X-Amz-Expires=120&X-Amz-Signature=63f79e8fb090b0fc9d0b5adade23dd1a9d02b0cb45e0dd12acdc4018c6e41d7c&itok=dUi89RdP)
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.