Tag: Mathematics

Heavy Tailed Distributions and the States of Randomness

Heavy Tailed Distributions and the States of Randomness

I. Normality

The “Normal Distribution” (also called the Gaussian Distribution) is a very useful and well-studied tool for analysing data.  It is however often misapplied, despite the efforts of Benoit Mandelbrot and Nassim Taleb to raise awareness of areas where it might be inappropriate to use.  One reason people may be tempted to overuse it might be its name, which is a little too suggestive of it being some kind of “standard”, so henceforth I will use its alternative name to avoid perpetuating this any more than is inevitable.

The trouble is, that everyone is so familiar with the Gaussian Distribution, that it is very seductive to shoehorn your data into it and try to use the familiar techniques to analyse your data.  When people see a “bell curve”, their first thought is usually “looks like it is Gaussian distributed”, meaning that the data behaves like it has been sampled from the graph below…

Read More Read More

Bayesian Updating

Bayesian Updating

Question

You have a randomly biased coin picked from the uniform distribution U(0,1).  It is flipped 3 times and comes up heads twice and tails once.  What is probability that 4th flip is a head?

This is a question that we can answer using Bayesian Updating, but unlike most simple examples of Bayes Theorem, we are not updating a single probability but an entire probability distribution.  There are many very good explanations of how to apply Bayes Theorem to update a single probability (video, article).  The principle is the same for updating a distribution, but it is a little more involved…

Read More Read More

Computus – Calculating the Date of Easter

Computus – Calculating the Date of Easter

This may seem like an odd topic, but it is nevertheless quite interesting. Quite aside from any ecclesiastical purposes, it is useful to know when Easter is going to be, as in many countries there are public holidays associated with it. As well as telling you when you might be able to get 16 days off by only using 8 days of leave (or alternatively, telling you when all the places you want to go will be super busy), Easter has significant financial implications too. Supermarkets usually have much higher sales volumes, and of course, banks and the stock market are closed for four days in a row. The calculation of the date of Easter is of such historical importance that it even has its own name – “Computus”.

Lots of businesses use Microsoft Excel for all manner of purposes – often financial. Therefore it would probably be useful to be able to calculate the date of Easter in an Excel formula. Hahaha. Let’s get started shall we…

Read More Read More