# Skills

### 5 Reasons Why Your Research Underpins A Great Student Experience

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…

### Model a business: simulate industrial processes

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…

### Deep reflection for practitioners

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…

### 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 quantiles

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…

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

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

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

### Fundamental statistics: average and standard deviation

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…

### IIoT: Technical vs. people skills

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…

### How to make reading work for 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…