Skills


Excel: quartile

Similar to the PERCENTILE formula, MS Excel has two functions that enable you to find the value in a range of numbers at a specific quartile. QUARTILE.EXC is used if you want to obtain the…


Excel: percentile

MS Excel has two functions that enable you to find the value in a range of numbers at a specific percentile. PERCENTILE.EXC is used if you want to obtain the percentile excluding the first and…


Statistics: quartiles

Quantiles are useful for talking about where a particular value lies within a dataset. Unfortunately, they are not that widely understood. We can think of quantile as equal portions of the data distribution. Once we…


Scatter plot with red outlier values

Excel: dealing with outliers

It has been said before, but having clean data is one of the best ways to ensure that your analysis is based on a sound footing. In the same way that we can tell whether a…


Temperature gauge

Machine learning basics

Machine Learning (ML) is very popular at present. It’s capabilities are almost magical if you listen to the software vendors. There is no doubt that ML enables interesting capabilities. If you have ever browsed Amazon…


Three empty concrete seats

Excel: mean, median, mode

A lot of people will use Microsoft Excel to do their analysis as it is installed on their desktop computer. To do basic descriptive statistics you will need to know how to calculate the mean,…