Skip to main content
The Actuary: The magazine of the Institute and Faculty of Actuaries - return to the homepage Logo of The Actuary website
  • Search
  • Visit The Actuary Magazine on Facebook
  • Visit The Actuary Magazine on LinkedIn
  • Visit @TheActuaryMag on Twitter
Visit the website of the Institute and Faculty of Actuaries Logo of the Institute and Faculty of Actuaries

Main navigation

  • News
  • Features
    • General Features
    • Interviews
    • Students
    • Opinion
  • Topics
  • Knowledge
    • Business Skills
    • Careers
    • Events
    • Predictions by The Actuary
    • Whitepapers
    • Moody's - Climate Risk Insurers series
    • Webinars
    • Podcasts
  • Jobs
  • IFoA
    • CEO Comment
    • IFoA News
    • People & Social News
    • President Comment
  • Archive
Quick links:
  • Home
  • The Actuary Issues
  • June 2022
General Features

Talking census: making use of data

Open-access content Wednesday 1st June 2022

With the ONS starting to release the data from the 2021 census, Jeremy Keating considers how those working in insurance can make use of it

dtj

The Office for National Statistics (ONS) will release the first batch of 2021 census data for England and Wales in early summer 2022. The UK completes a census every 10 years and these are the most recent results; Scotland and Northern Ireland’s figures are delayed until 2023 due to COVID-19.

Census data consists of statistics collected about a country’s population. The upcoming release will contain multiple categories of information on areas such as demographics, economics, population, housing, employment and transportation, provided by individual areas and regions.

The ONS will release the data on its website for free. The lowest granularity available instantly from the website will be Lower Layer Super Output Area, each containing roughly 1,000 people. The most granular level that can be obtained from the ONS is the Output Areas Small Area, each containing about 250 people.

There are several ways that census data can be used in modelling and rating.

Clustering

Clustering is useful for turning multiple continuous factors into a single discrete factor. It works by putting observations from the exposure into groups that are similar to each other. This is done by treating each factor as a distance from zero, then putting observations that are ‘close’ to each other into the same group; observations with similar census factors will end up in the same groups.

To prevent distortions, it is crucial to normalise the data – make sure all factors are on the same scale – before using it. Clustering works best with continuous factors, or at least factors that are naturally ordered, but there are techniques for applying it to binary and discrete factors.

A key question is how many clusters are needed. There is no right or wrong answer here and, often, multiple numbers of clusters should be tested and assessed.

Principal component analysis

Principal component analysis (PCA) is a way of reducing many continuous factors down to a smaller number by capturing only the essence of each existing factor. The output from a PCA is a weight to apply to each factor to make a new factor; the new factor is like a weighted average of the existing factors.

PCA usually creates more than one factor to capture all the information. Judgment must often be applied to decide how many of the new factors to use. As with clustering, data must be normalised. Mathematically, PCA is about finding the vectors in the multi-dimensional space that are at right angles to one other, and keeping only these.

Clustering and PCA can be combined for improved results; first, a PCA is performed to get the essence of the factors, then clustering is done to find which observations are similar, reducing down so there is just one factor left that best captures all of the information.

Directly rating

Directly rating means taking the individual factors and using them as they are in modelling and rating. This usually produces better results than reduction methods, but is more complex. Rating engine constraints often prevent the use of all individual factors live in the rating, as they need extra tables for looking up all the values. With more than 1m postcodes in the UK, these tables are sizable.

Real-life uses and outcomes

Once these steps are complete, census data can be included in a pricing modelling exercise. The data becomes a feature, or features, in the chosen model.

The Financial Conduct Authority (FCA) used census data in its interim report on general insurance pricing practices to enhance its analysis. The results of this are in Annex 1 of its report on consumer outcomes; the FCA modelled loss ratios using granular policy and claims data provided by most UK general insurers, in what is probably one of the most comprehensive insurance modelling exercises ever completed. The body assessed customer outcomes using the census data and its findings are included in the report.

Implementing census data leads to reduced loss ratios due to anti-selection. This is also the reason that a company has an advantage if it is using data that its competitors are not. If the data adds additional explanation and can be used to segment customers into groups based on the expected claims, the company using the extra data can offer some customers lower prices due to their lower propensity to claim or their lower cost of claims. This attracts those customers away from competitors, who see loss ratios worsen while the company with the extra data expands its book profitably.

Jeremy Keating is an underwriting data expert at errars.com.

Image credit | iStock
Linked ACT Jun22_Full LR.jpg
This article appeared in our June 2022 issue of The Actuary .
Click here to view this issue

You may also be interested in...

hrts

Storm watch: Can IPCC models be used in cat modelling?

Can IPCC projections be used to adjust catastrophe models for climate change? Nigel Winspear and David Maneval investigate, using US hurricanes as an example
Wednesday 1st June 2022
Open-access content
EG\

Uneven outcomes: findings on cancer mortality

Ayşe Arık, Andrew Cairns, Erengul Dodd, Adam Shao and George Streftaris share their findings on the impact of socio-economic differences and diagnostic delays on cancer mortality
Wednesday 1st June 2022
Open-access content
z

Changing gears: autonomous vehicles and motor insurance

Ben Hoster considers the implications of electric autonomous vehicles for motor insurance, and the role insurers will play in popularising this new mode of transport
Wednesday 1st June 2022
Open-access content
ees

Reversing the decline: understanding nature-related risks

Oliver Schelske places nature-related risks within an actuarial context, and explains why it is so important for insurers to understand such risks
Wednesday 1st June 2022
Open-access content

United front: responding to large loss events

Darshan Purmessur shares how public and private sector stakeholders came together following the 2020 Mauritian oil spill, and what it can teach us about responding to large loss events
Wednesday 1st June 2022
Open-access content
J6S

Obstacle course: IFRS 17 implementation challenges for Kenyan insurers

Joan Mungai examines the practical challenges for Kenyan insurers when it comes to IFRS 17 implementation
Wednesday 1st June 2022
Open-access content

Latest from Modelling/software

EWG

Finding a good fit: innovation in DC pensions

Esther Hawley and Clarence Er look at the progress being made on developing better post-retirement solutions
Wednesday 4th May 2022
Open-access content
rea

Pensions: proceeding with prudence

Phil Hardingham and Keith McInally discuss linking scheme funding valuations to the cost of CDI assets, and what prudence looks like in this context
Wednesday 4th May 2022
Open-access content
web_p34-35_Model-citizens_Covid-models_Covid-ICU-unit_CREDIT_Getty-1211903275.jpg

Model citizens during the pandemic

Chris Martin and Steve Bale discuss how actuaries modelled the impacts of critical care demand and long COVID during the pandemic
Wednesday 6th April 2022
Open-access content

Latest from General Insurance

td

Brain power

The latest microchips mimic cerebral function. Smaller, faster and more efficient than their predecessors, they have the potential to save lives and help insurers, argues Amarnath Suggu
Wednesday 1st March 2023
Open-access content
bl

'Takaful' models of Islamic insurance

Ethical, varied and a growing market – ‘takaful’ Islamic insurance is worth knowing about, wherever you’re from and whatever your beliefs, says Ali Asghar Bhuriwala
Wednesday 1st February 2023
Open-access content
il

When 'human' isn't female

It was only last year that the first anatomically correct female crash test dummy was created. With so much data still based on the male perspective, are we truly meeting all consumer needs? Adél Drew discusses her thoughts, based on the book Invisible Women by Caroline Criado Perez
Wednesday 1st February 2023
Open-access content

Latest from General Features

yguk

Is anybody out there?

There’s no point speaking if no one hears you. Effective communication starts with silence – this is the understated art of listening, says Tan Suee Chieh
Thursday 2nd March 2023
Open-access content
ers

By halves

Reducing the pensions gap between men and women is a work in progress – and there’s still a long way to go, with women retiring on 50% less than men, says Alexandra Miles
Thursday 2nd March 2023
Open-access content
web_Question-mark-lightbulbs_credit_iStock-1348235111.png

Figuring it out

Psychologist Wendy Johnson recalls how qualifying as an actuary and running her own consultancy in the US allowed her to overcome shyness and gave her essential skills for life
Wednesday 1st March 2023
Open-access content

Latest from Data Science

gc

Free for all

Coding: those who love it can benefit those who don’t by creating open-source tools. Yiannis Parizas outlines two popular data science programming languages, and the simulator he devised and shared
Wednesday 1st March 2023
Open-access content
il

When 'human' isn't female

It was only last year that the first anatomically correct female crash test dummy was created. With so much data still based on the male perspective, are we truly meeting all consumer needs? Adél Drew discusses her thoughts, based on the book Invisible Women by Caroline Criado Perez
Wednesday 1st February 2023
Open-access content
res

Interview: Tim Harford on the importance of questioning our assumptions

Tim Harford speaks to Ruolin Wang about why it’s so important to slow down and question things from emotive headlines to the numbers and algorithms we use in our work
Wednesday 30th November 2022
Open-access content

Latest from June 2022

k

Sponsored roundtable: Meeting the data demand

Emerging data science tools and techniques are redefining what it is to be an actuary. Organisations worldwide are looking to optimise their operations , and recruitment agencies are inundated with requests for talent that stands out from the crowd.
Wednesday 1st June 2022
Open-access content
hg

Filling the gap: actuarial resources between nations

Ibrahim Muhanna looks at the state of the actuarial profession around the world, and considers what it might take to narrow the gaps in resources
Wednesday 1st June 2022
Open-access content
Puzzles-iStock-1146577830.jpg

Puzzles June 2022

The June puzzles and the solutions are viewable in PDF format only.
Wednesday 1st June 2022
Open-access content
Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

Leading Insurer/Asset Manager – Pricing Actuary (Mortgages)

London (Greater)
Competitive
Reference
148750

Senior Consultant - Risk Settlement - Any UK Location - Up to £100,000 plus bonus

London / Manchester / Edinburgh / Remote
Up to £100,000 + Bonus
Reference
148832

Finance Transformation Actuarial student/Qualified Actuary

London (Central)
£50,000 - £75,000 depending on experience
Reference
148830
See all jobs »
 
 
 
 

Sign up to our newsletter

News, jobs and updates

Sign up

Subscribe to The Actuary

Receive the print edition straight to your door

Subscribe
Spread-iPad-slantB-june.png

Topics

  • Data Science
  • Investment
  • Risk & ERM
  • Pensions
  • Environment
  • Soft skills
  • General Insurance
  • Regulation Standards
  • Health care
  • Technology
  • Reinsurance
  • Global
  • Life insurance
​
FOLLOW US
The Actuary on LinkedIn
@TheActuaryMag on Twitter
Facebook: The Actuary Magazine
CONTACT US
The Actuary
Tel: (+44) 020 7880 6200
​

IFoA

About IFoA
Become an actuary
IFoA Events
About membership

Information

Privacy Policy
Terms & Conditions
Cookie Policy
Think Green

Get in touch

Contact us
Advertise with us
Subscribe to The Actuary Magazine
Contribute

The Actuary Jobs

Actuarial job search
Pensions jobs
General insurance jobs
Solvency II jobs

© 2023 The Actuary. The Actuary is published on behalf of the Institute and Faculty of Actuaries by Redactive Publishing Limited. All rights reserved. Reproduction of any part is not allowed without written permission.

Redactive Media Group Ltd, 71-75 Shelton Street, London WC2H 9JQ