Group Life COVID-19 Mortality Survey – Updated through September 2021

Link: https://www.soa.org/resources/experience-studies/2022/group-life-covid-19-mortality/

Report PDF: https://www.soa.org/48ff80/globalassets/assets/files/resources/research-report/2022/group-life-covid-19-mortality.pdf

Graphic:

Excerpt:

Table 5.2 shows more detailed industry results for the top ten industry segments by number of COVID claims. Most of these industries were in the top ten for the July 2021 report as well. As we now have more quarters with more complete results, both the A/E ratios for April 2020 through September 2021, as well as the COVID claims as a percentage of baseline claims, showed greater consistency across industries than in the previous report. Public Administration continues to be a key driver of high A/E ratios for the White Collar category. Doctors (Healthcare, also White Collar), Retail Trade (Grey Collar), and Misc. Services (Grey Collar) have the highest COVID claims as a percentage of baseline claims. Heavy Steel Manufacturing (Blue Collar) has a much lower A/E ratio than the other top 10 industries. In the table below, “B,” “W,” and “G” refer to Blue Collar, White Collar, and Grey Collar, respectively.

It should be noted that the high A/E ratios for Public Administration are driven by experience in the Executive, Legislative, and General Government segment (Standard Industry Classification [SIC] codes 9100-9199). This segment does not include police and fire and represents over 85% of claims in the broader Public Administration segment.

Video:

Publication Date: January 2022

Publication Site: Society of Actuaries Research Institute

Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST

Link: https://www.youtube.com/watch?v=kQPUWryXwag&ab_channel=LeilaGharani

Video:

Description:

OpenAI inside Excel? How can you use an API key to connect to an AI model from Excel? This video shows you how. You can download the files from the GitHub link above. Wouldn’t it be great to have a search box in Excel you can use to ask any question? Like to create dummy data, create a formula or ask about the cast of the The Sopranos. And then artificial intelligence provides the information directly in Excel – without any copy and pasting! In this video you’ll learn how to setup an API connection from Microsoft Excel to Open AI’s ChatGPT (GPT-3) by using Office Scripts. As a bonus I’ll show you how you can parse the result if the answer from GPT-3 is in more than 1 line. This makes it easier to use the information in Excel.

Author(s): Leila Gharani

Publication Date: 6 Feb 2023

Publication Site: Youtube

Data visualization lessons: Jitter charts, screwups, and visionaries

Link: https://marypatcampbell.substack.com/p/data-visualization-lessons-jitter

Video:

Excerpt:

Jitter charts are my new favorite tool for displaying how distributions change over time.

I used them to great effect in my recent post One Bad Year? Comparing the Long-Term Public Pension Fund Returns Against Assumptions.

I’m often looking at distributions, and wanting to communicate something about how those distributions change over time, or how distributions compare. Often, I have to simply pick out key percentiles in those distributions, or key aspects, such as mean and standard deviation.

But why not graph all the points in one’s sample directly, if one has them?

That’s where jitter charts can help.

Author(s): Mary Pat Campbell

Publication Date: 16 Sep 2022

Publication Site: STUMP at substack

Beyond Insurance

Link: https://www.youtube.com/watch?v=_Ba5wBGeUBk&t=1s&ab_channel=DominicLee

Video:

Description:

In a groundbreaking TED-style talk, Dominic Lee, ACAS takes the audience on a multisensory journey beyond the boundaries of traditional insurance. He presents a framework for the actuarial profession to step into the future and claim its rightful place as a dominant force in the world of risk: Reimagine, Embrace and Explore.

Author(s): Dominic Lee, ACAS

Publication Date: 6 July 2021

Publication Site: YouTube

Risk-Based Rating in Personal Lines Insurance

Link: https://www.youtube.com/watch?v=IPYSSZkP-Oo&ab_channel=RStreetInstitute

Video:

Description:

The insurance industry is unique in that the cost of its products—insurance policies—is unknown at the time of sale. Insurers calculate the price of their policies with “risk-based rating,” wherein risk factors known to be correlated with the probability of future loss are incorporated into premium calculations. One of these risk factors employed in the rating process for personal automobile and homeowner’s insurance is a credit-based insurance score.

Credit-based insurance scores draw on some elements of the insurance buyer’s credit history. Actuaries have found this score to be strongly correlated with the potential for an insurance claim. The use of credit-based insurance scores by insurers has generated controversy, as some consumer organizations claim incorporating such scores into rating models is inherently discriminatory. R Street’s webinar explores the facts and the history of this issue with two of the most knowledgeable experts on the topic.

Featuring:

[Moderator] Jerry Theodorou, Director, Finance, Insurance & Trade Program, R Street Institute
Roosevelt Mosley, Principal and Consulting Actuary, Pinnacle Actuarial Services
Mory Katz, Legacy Practice Leader, BMS Group

R Street Institute is a nonprofit, nonpartisan, public policy research organization. Our mission is to engage in policy research and outreach to promote free markets and limited, effective government.

We believe free markets work better than the alternatives. We also recognize that the legislative process calls for practical responses to current problems. To that end, our motto is “Free markets. Real solutions.”

We offer research and analysis that advance the goals of a more market-oriented society and an effective, efficient government, with the full realization that progress on the ground tends to be made one inch at a time. In other words, we look for free-market victories on the margin.

Learn more at https://www.rstreet.org/
Follow us on Twitter at @RSI

Author(s): Jerry Theodorou, Roosevelt Mosley, Mory Katz

Publication Date: 4 April 2022

Publication Site: R Street at YouTube

Jerry Theodorou Presents on Social Inflation to the Business Insurance World Captive Forum

Link: https://www.youtube.com/watch?v=HahkUnXje1A

Video:

Description:

R Street Institute Director of Finance, Insurance and Trade Jerry Theodorou presents on social inflation and his latest policy study to the Business Insurance World Captive Forum in Miami in February.

Author(s): Jerry Theodorou

Publication Date: 23 Feb 2022

Publication Site: YouTube and R Street Institute

Principal Component Analysis

Data Science with Sam

Link:https://www.youtube.com/watch?v=Z6feSjobcBU&ab_channel=DataScienceWithSam

Article: https://sections.soa.org/publication/?m=59905&i=662070&view=articleBrowser&article_id=3687343

Graphic:

Excerpt:

In simple words, PCA is a method of extracting important variables (in the form of components) from a large set of variables available in a data set. PCA is a type of unsupervised linear transformation where we take a dataset with too many variables and untangle the original variables into a smaller set of variables, which we called “principal components.” It is especially useful when dealing with three or higher dimensional data. It enables the analysts to explain the variability of that dataset using fewer variables.

Author(s): Soumava Dey

Publication Date: 14 Nov 2021

Publication Site: Youtube and SOA

Coffee Chat – “Data & Science”

Link:https://www.youtube.com/watch?v=S5GHsjgSl1o&ab_channel=DataScienceWithSam

Video:

Excerpt:

The inaugural coffee chat of my YouTube channel features two research scholars from scientific community who shared their perspectives on how data plays a crucial role in research area.

By watching this video you will gather information on the following topics:

a) the importance of data in scientific research,

b) valuable insights about the data handling practices in research areas related to molecular biology, genetics, organic chemistry, radiology and biomedical imaging,

c) future of AI and machine learning in scientific research.

Author(s):

Efrosini Tsouko, PhD from Baylor College of Medicine; Mausam Kalita, PhD from Stanford University; Soumava Dey

Publication Date: 26 Sept 2021

Publication Site: Data Science with Sam at YouTube

Mortality with Meep – Excess Deaths through September 2021 – Winter is Coming

Video description:

A look at the pattern of weekly deaths, all causes, for the entire United States through the beginning of September 2021, as well as: California Texas New York (minus NYC) New York City Pennsylvania Illinois CDC excess mortality dashboard: https://www.cdc.gov/nchs/nvss/vsrr/co…

Publication Date: 17 Sept 2021

Author: Mary Pat Campbell

Publication Site: Meep’s Math Matters at Youtube

Virtual Meetup: To Err is Human but to ISERR is Never OK!

Video description:

Have you ever built a perfect financial model without any errors? Thought not! And for that reason, all good modellers know they need to include some error checks. But what is not as clear is how many error checks you should have, when you should include them and what form they should take. Excel “helpfully” provided us with functions like ISERR, ISERROR and IFERROR but as you progress your modelling journey you should learn to avoid these functions. Plus, you also learn the sad truth that Excel can’t even do basic maths sometimes! Join us to hear from financial modelling specialist Andrew Berg, who has spent years building models, and so happily admits he has probably already made most of the mistakes you haven’t yet had a chance to! The good news is that he is willing to share the tips he has learned about the right types of error checks to add to your models so you don’t have to learn the hard way. ★Download the resources here ► https://plumsolutions.com.au/virtual-… ★Register for more meetups like this ► https://plumsolutions.com.au/meetup/ ★Connect with Andrew on Linkedin ► https://www.linkedin.com/in/andrew-be…

Author(s): Andrew Berg, Danielle Stein Fairhurst

Publication Date: 2 June 2021

Publication Site: YouTube