Showing posts with label calculator. Show all posts
Showing posts with label calculator. Show all posts

May 7, 2010

Online Murphy Risk Calculator

Risk is like quantum mechanics:

If you think you understand Risk, you don't understand Risk
Maggid after : Feynman

If you are not completely confused by Risk, you do not understand it
Maggid after : John Wheeler

Sure, risk is hard to tackle. The more you learn about risk, the more you become aware of it's sneaky characteristics (clustering, tails, etc).

This is why becoming a qualified actuary takes an incredible amount of time, hard study and many years of experience.  As masters in Risk, actuaries understand the limits in modeling and calculating Risk.

Probably one of the more intriguing risk quotes is :

"Anything that can go wrong, will go wrong"

by the famous Edwin Murphy.

A quote that keeps an actuary mind busy....  After all, as actuaries it is our duty to quantify and explain uncertainty (as much as is possible) in board rooms and on the accounting table. Not only when decisions have to be taken, but also after things turned out wrong or different from what we thought. This is - to put it mildly - no 'easy task' and it's not getting easier in the near future.....

Just like Murphy, actuaries experienced last decades that (statistic) bad luck often collaborates with bad timing. What drives God (i.e. quantum mechanics or 'Murphy probability') to confront us - (poor) actuaries - with 'fair value volatility', 'longevity explosions', 'subprime defeats', 'imploding real estate market's and 'extraordinary solvency demands by supervisors', all at the same time time?

(Un)Luckily, help is on the way....  In 2004 British Gas commissioned some scientists to create a formula to predict Murphy's Law, also known as Sod's Law.

Murphy's Formula
In a 2005 study, based on a survey of 1,023 adults, Murphy’s Law was shown 'statistically significant'. The final report also supplied a formula for predicting occurrences of Murphy’s Law. Here it is....

Let U, C, I, S, and F be integers between 1 and 9, reflecting respectively comparative levels of Urgency, Complexity, Importance, Skills, and Frequency in a given set of circumstances. Let A, which stands for Aggravation, equal 0.7 (Please, don’t ask why). The likelihood (L) of Murphy’s Law obtaining under those circumstances, on a scale of 0 to 8.6, turns out to be:

L = [((U + C + I) x (10 - S)) / 20] x A x 1 / (1 - sin (F / 10))

Murphy's Formula strikes itself
Unfortunately, Murphy's law suffered from self reference, as one of the  authors, the mathematician Phil Obayda, commented on a 2004 blog that this formula is wrong.

The correct formula according to Phil is:

 P= (((U+C+I) * (1-S))/2) * A * (1/(1-Sin F))

with P = probability of Sod's Law Occuring and U, C, I, S and F values greater than 0 and less than 1, keeping the mysterious A = 0.7.

Murphy's formula simplified
Simplifying this last formula leads to Maggid's formula for the probability (%) of Murphy hitting you, whenever you perform a task:

Although application of this formula is not (yet) an obligated part of the actuary's Code of Professional Conduct, please check this equation anytime you're about to defend an actuarial advice on a Board's table.

How to use Murphy's formula: an Actuarial Example
Let's do a simple exercise to demonstrate the power of Murphy's formula:

You've developed a risk model of the Stock market. In a meeting the Chair of the board asks you how certain you are of your model being right. You know the difference between risk and uncertainty, so you say "one moment please" and pick up your pocket calculator while reflecting: This is a ´U=3, I=9,C=10,F=3´ situation, and I'm a S=9 actuary. That calculates as P=10.4% of Murphy hitting me. Within 20 seconds you (over)confidently answer: I`m about 90% sure of my model!

The Chair of the Board looks desperate... His eyes reflect: ´Is 90% good or bad?` You didn't realize your model was that important to the board.  But.. if that's so, 'Importance' should not be rated at I=9 but at I=10, raising the failure probability to almost 11%. Now you start doubting yourself : What if you overestimated yourself? What if you're only a AA-Actuary (level S=7) instead of a AAA (level S=9)? This would increase the probability of failing to 31.3%. Suddenly you realize you're only one step away from a major personal actuarial meltdown.
You get yourself together, regain your self confidence, realize you're one of the best actuaries in the world (S=10) and full of confidence you reply the questioning eyes of the Chair with: "Sir, I'm almost 100% certain my model is right.

The Board is relieved and content. You're an actuary they can trust. Now they can decide without hesitation.

So next time you want to know the failure probability of a task, use the next Online Murphy Calculater.

Good Luck with Murphy's calculator!

Used sources/Links:
- Sod’s Law: A Proof
- Newyorker: Murphy At the Bat
- The Engineering of Murphy's Law?
- Legend, Inc. Murphy's Laws
- The Stock Market: Risk vs. Uncertainty
- Murphy's Online Calculator

Sep 7, 2009

Swine Flu Counter update Sept 2009

Here you'll find the September 2009 update of the

Global Swine Flu Counter

Although there is still an increasing risk of underreporting, the counter has been renewed on basis of the latest available global reports as provided by Wikipedia/ECDC.

Swine Flu under Control?
The September 2009 developments suggest the Swine Flu development is under control, as the reported infections changed from a exponential growth recent months, to more linear growth in August 2009. In September the increase of infections was already declining.

New Model
The above developments are the main reason why data in the Swine Flu calculator have now been modelled by a logistic function.
Well considered curve fitting at ZunZun, showed a Gompertz function (with offset) resulted in a satisfying approximation :

Life actuaries will be familiar with good old Gompertz. The Gompertz equations are - by the way - also used to model Plant Desease Progres.

The number of death have now been modelled ruffly as 1.8% of the infected people a month earlier [Death=0.018*I(t-30)]

Results update
The results the new approximation show that the number of reported infections increases asymptotically towards a limit of about 323,000.

Correspondingly, the number of death, , increases to a limit of ruffly 6000.

All provided the actual controlled development continues and no new mutation of the H1N1 will develop in the next months.....

The risk of underreporting is not negligible . Modeling on basis of excluding the September data would result in a limit of 528,000 infects and about 9500 deaths. We'll just have to wait how H1N1 develops.....
But as becomes clear, the explosion of swine flue cases looks under control.

If necessary, the counter will be updated again on a on a regular basis. The latest data you'll find in this XLS spreadsheet.

Install Swine Flu Counter
How to implement this Swine Flu Counter on your web site?

  • Put the next HTML-script (without the outer quotes) just before the end of the body tag:' <script language="javascript" type="text/javascript" src=""> </script>'

  • Put the next HTML-line (without the outer quotes) where you want the Swine Flu table to appear on your site :
    ' <div id="swineflutable"></div> '

  • Ready!