University academic staff are constantly required to continually improve the quality of their research, while also soliciting income from external funding agencies. Surely it makes sense to focus on research activities so that your performance…
Read More
There comes a point when your spreadsheet models of business processes just don’t cut it. You observe some complexity that is just too difficult to explore. You have questions that remain unanswered because you can’t do…
Those that practice regular reflection, and have an operational system in place, witness some significant benefits in their development. At the very least, you will be more aware of how you behave – and while…
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…
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…
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…
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…
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…
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,…
This is the first of a series of posts where I explain some basic concepts for analytics. Fundamental statistics: average and standard deviation in particular, are important to understand. Especially, since statistics has a reputation…
You want your factory to be IIoT enabled. You’ve seen the videos and read the case studies. It’s obvious: IIoT technologies are central to your digital transformation. But where do you start? How do you…
A review of research literature is a useful thing to do. It helps us understand what the current thinking, developments and practices are with regard to a particular subject area. The process of creating the…