Global Research Syndicate
No Result
View All Result
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights
No Result
View All Result
globalresearchsyndicate
No Result
View All Result
Home Data Analysis

Workers Comp Statistical Significance Is Still Statistically Significant

globalresearchsyndicate by globalresearchsyndicate
November 19, 2019
in Data Analysis
0
Workers Comp Statistical Significance Is Still Statistically Significant
0
SHARES
2
VIEWS
Share on FacebookShare on Twitter

READ ALSO

Global patterns and trends in incidence and mortality of thyroid cancer in children and adolescents: a population-based study

Stellar Lumens, Waves, IOTA Price Analysis: 20 January

Workers Comp Statistical Significance Is Still Statistically Significant



Workers Comp Statistical Significance Better Known As The Benchmark


Most discussions and articles concerning Workers Comp Statistical Significance center on the Experience Modification Factor and Loss Development Factors. Benchmarks also come from tests for statistical significance.

The article that generated this article can be found here. I find it amazing that data scientists recommended elimination of Correlation due to its inexactness. I have used the test for Correlation often.

One of the main reasons to use this powerful statistic occurs when the incoming data is non-reliable. Why run a battery of statistical tests when the data is not verifiable or consistent?

To me, the word benchmark’s overuse knows no bounds in insurance. I prefer workers comp statistical significance. Why?

I often am given massive data sets to analyze. The three main tests I use are:

  1. Regression and Stepwise Regression
  2. Coefficient of Correlation and Determination
  3. Proportional Math (almost magic)
  4. Loss Triangles – added in to keep the actuaries happy

Let us look at each of these tests in Workers’ Compensation. Excel provides the first three with no problem. One can accomplish purchasing loss triangle software by a few vendors on the internet.

Hang in there with me. This article will not cause too much pain. The Excel formula name appears below the title if you wish to reference what Microsoft says about each of the statistical tests. You must have the Data Analysis Toolpak installed to use any of the Excel functions.

Regression and Stepwise Regression

TREND, LINEST

For Workers Comp, regression may seem too long-tail (covers too many years) to use in most cases. Estimating trends requires fewer data points than one might think for analysis.

Experience Modification Factors usually cover only a short range of employer data. With the advent of Predictive Analytics, E-Mods sometimes take a backseat to longer-tail data. E-Mods cover only 4.5 years in the past maximum. Predictive analytics examine losses over a much longer amount of time, such as 20 years or as long as the business has been in existence.

I use the LINEST and TREND functions to forecast Experience Modification factors with an acceptable level of accuracy. NCCI and the other rating bureaus store long periods of Experience Mod. Workers Comp statistical significance began to step away from Mods over the last 10 – 15 years.

Not to bore anyone, but the formula for linear regression (sum of least squares) is:

Y=mx + b

A simple yet powerful formula for forecasting and examining the relationships between two or more variables.

workers comp statistical significance graph linear regression

Public Use License – Wikimedia

The red line represents a linear trend amongst data plots. Let us leave the regression discussion with the graph.

Coefficient of Correlation and Determination

CORREL

Regression and correlation go hand in hand as regression measures the amount of linear correlation. The coefficient of correlation can be a great tool when given multiple sets of supposedly related data to examine for any workers comp statistical significance. I received three sets of what turned out to be unrelated data after putting the Coefficient of Correlation to work for me.

The University of Connecticut performed an excellent job of explaining how to use and graph correlation in Excel here.

A company forwarded two sets of claims payment data last week. One set was temporary total payments on new claims paid for one year. I then received a set of data based on the number of accidents.

By running a Coefficient of Correlation test between the two data sets, I could tell that some inaccuracies existed in one or both sets of the data. The low Workers Comp statistical significance of the data showed that the correlation came in at .32. I was expecting a .80 result or higher.

The Coefficients are:

  • 1 means perfect correlation
  • .5 – the two variables are not probably related
  • 0 – random data or the test was not set up properly
  • -1 -perfect negative correlation – can still be a good thing

If you wish to see how the Coefficient of Correlation can cause the gain or loss of billions of dollars, follow the first link in the article to the Claims Journal article.

You can run any two sets of data together to see if they have something in common (a correlation) I have used this powerful statistical test numerous times to test data sets for reliability.

Proportional Math – Great Workers Comp Statistical Significance Test

Proportions remain my go-to non-statistical statistic when dealing with Experience Modification Factors. Sometimes, I have to run different numbers through a premium audit or E-mod calculation extremely quickly.

Going through all the numbers will not do as the time is short. Proportions are a quick-and-dirty way to go through a series of calculations without spending the time to do each calculation. Premium audit statements and bills can be gone through in a few steps.

In algebra, proportions can be used to solve many common problems about changing numbers. As an example, for the increase in a $40 purchase of gasoline, if the price rose 35 cents, from $3.50 to $3.85, the proportion would be:

x⁄3.85 = $40⁄3.50

The solution is simply:

x = $40/3.50 x 3.85 = $44.00, or $4 more when $0.35 higher.

As long as a linear relationship exists between the variables, one can crank out proportions that make sense very rapidly.

Loss Triangles – The Actuarial Debate

The final measure of workers compensation statistical significance is loss triangles sometimes known as loss picks. A few software vendors provide these powerful assessors of the current risk involved with a set of claims.

The Ultimate Loss Value for each claim and the set of claims is tantamount to loss triangles. Loss Development Factors for self insureds are generated from this statistical method.

A great Loss Development Factor article can be found here from Sigma Actuarial Group.

Measurements for workers comp statistical significance usually are not that difficult with the advent of so much software.

This blog post is provided by James Moore, AIC, MBA, ChFC, ARM, and is republished with permission from J&L Risk Management Consultants. Visit the full website at www.cutcompcosts.com.



Visit Program Rules Here
| Visit From Bob’s Cluttered Desk Here


Comments

Be the first person to comment!


You must Login or Register in order to read and make comments!

Member Login

Don’t Have an Account? Click Here to Register.

Disclaimer: WorkersCompensation.com publishes independently generated writings from a variety of workers’ compensation industry stakeholders. The opinions expressed are solely those of the author and do not necessarily reflect those of WorkersCompensation.com.

Related Posts

Global patterns and trends in incidence and mortality of thyroid cancer in children and adolescents: a population-based study
Data Analysis

Global patterns and trends in incidence and mortality of thyroid cancer in children and adolescents: a population-based study

January 20, 2021
Stellar Lumens, Waves, IOTA Price Analysis: 20 January
Data Analysis

Stellar Lumens, Waves, IOTA Price Analysis: 20 January

January 20, 2021
Capped under robust resistance after suffering the sell-off– Confluence Detector
Data Analysis

XAU/USD surges on Biden’s inauguration day, levels to watch – Confluence Detector

January 20, 2021
Pullback from 21-day SMA recalls sub-131.00 area
Data Analysis

Hits the highest level since September 2020, around 142.35

January 20, 2021
Orifice Plates Market Study Report (2020-2026), Competitive Analysis, Proposal Strategy, Potential Targets, Assessment And Recommendations
Data Analysis

Global Thymoquinone Market Scope and Price Analysis of Top Manufacturers Profiles 2020-2027 – NeighborWebSJ

January 20, 2021
Litecoin, Algorand, VeChain Price Analysis: 20 January
Data Analysis

Litecoin, Algorand, VeChain Price Analysis: 20 January

January 20, 2021
Next Post
Hydroperoxy octadecadienoic acid Market Overview with Demographic Data and Industry Growth Trends by 2026 – Galus Australis

Hydroperoxy octadecadienoic acid Market Overview with Demographic Data and Industry Growth Trends by 2026 – Galus Australis

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

POPULAR NEWS

‘Vatican Blackout’ Trends on Twitter as Trigger-Happy Users Try to Link It with US Election Fraud

‘Vatican Blackout’ Trends on Twitter as Trigger-Happy Users Try to Link It with US Election Fraud

January 10, 2021
Global Food Authenticity Industry

Fifth Third Bank Partners with Cardtronics to Enhance Brand Visibility in Carolinas through ATM Branding Program

February 4, 2020
Horowitz: Asian-American researcher fired from Michigan State administration for advancing facts about police shootings

Horowitz: Asian-American researcher fired from Michigan State administration for advancing facts about police shootings

July 8, 2020
Digital Learning Market 2020 industry report explores segmented by growth opportunities, emerging-trends, and industry verticals till 2025

Online Brand Protection Software Market report reviews size, share, analysis, trends, growth and forecast 2025

March 6, 2020
Survey finds 40% of fashion brands have not paid suppliers | Apparel Industry News

Survey finds 40% of fashion brands have not paid suppliers | Apparel Industry News

May 29, 2020

EDITOR'S PICK

We’ve Glimpsed The Future, And It Is Multicultural 12/13/2019

Brand Buddha Joins Tantillo Foods’ Agency Roster 12/31/2019

December 31, 2019
Smart Meat Thermometer Market Size, Production, Consumption, Export and Import, Growth Rate and Price Analysis by Types and Applications, Forecast to 2025 – The Daily Chronicle

Smart Meat Thermometer Market Size, Production, Consumption, Export and Import, Growth Rate and Price Analysis by Types and Applications, Forecast to 2025 – The Daily Chronicle

August 21, 2020
GBL Market Research Report, Growth Forecast 2025

Wireless Data Radio Modem Market 2020 Global Outlook, Research, Trends and Forecast to 2025

October 4, 2020
Advanced Planning and Scheduling (APS) Software Market Key Players, SWOT Analysis, Key Indicators, Forecast To 2019 to 2025 – 3w Market News Reports

Fast Fashion Market 2020 Key Players, SWOT Analysis, Key Indicators, Forecast To 2026 – Cole of Duty

July 21, 2020

Categories

  • Consumer Research
  • Data Analysis
  • Data Collection
  • Industry Research
  • Latest News
  • Market Insights
  • Marketing Research
  • Survey Research
  • Uncategorized

Recent Posts

  • Cornell Day of Data to focus on research collaboration
  • Global patterns and trends in incidence and mortality of thyroid cancer in children and adolescents: a population-based study
  • Global Rugs and Carpets Market 2020 Trends, Segmentation, Swot Analysis, Opportunities And Forecast To 2027 – NeighborWebSJ
  • Privacy Policy
  • Terms of Use
  • Antispam
  • DMCA
  • Contact Us

Copyright © 2020 Globalresearchsyndicate.com.

No Result
View All Result
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights

Copyright © 2020 Globalresearchsyndicate.com.

Login to your account below

Forgotten Password?

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In