Analytics






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…


Ram on scree looking imposing

Human Resource Analytics anyone?

People are the key asset of any business organisation. For a business to be profitable we need to manage resources effectively, especially Human Resources. Years of management practice, organisational research and psychology, and explorations into…


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,…




Data tools: less can be more

The explosion of interest in data analysis has led to a wider audience participating in the development of new methods and tools to help gain new insight. Careers in Data Science are relatively new, but…


Disorganised storage shelves

Understanding types of data

Good data visualisation communicates meaning to a wide audience in an unambiguous way. Unfortunately, a lot of data visualisation is not so effective and communicating meaning. There can be many reasons for this, from not…