Blog

Recent Post

Gaussian Curve – Who Wants to be Normal Anyway?

Gaussian Curve – Who Wants to be Normal Anyway?

​What is a Gaussian Curve, what can you do with it, and how do you get one with your data? This blog post will give you all the  answers with lots of graphics and no complicated stats… Ready? Let’s jump right in… “In the 21st Century it is unacceptable that almost 50% of school leavers fail to…

Statistics – The Last Dark Art?

Statistics – The Last Dark Art?

In the first post in our ‘Discover Stats’ Blog Series we explain what stats is, what it isn’t and why you should take the time to learn the basics… No, wait, stop running – it’s really not that difficult. Honest! Come back and let me explain… Continue Reading

How to Clean Data Using Excel COUNTIF

How to Clean Data Using Excel COUNTIF

​Cleaning numerical data can take a ridiculous amount of time​, but learning to use ​Excel COUNTIF can save you a lot of time and hassle…​…and having to explain to your boss why that analysis report isn’t on his desk yet, a mere 2 weeks after he gave you the dataset! Bless him, he doesn’t understand. He…

How to Clean Text Data Using Excel VLOOKUP

How to Clean Text Data Using Excel VLOOKUP

​In this blog post I’m going to show you how you can combine Excel VLOOKUP with Remove Duplicates ​to clean text data.​​​It’s interesting that there is plenty of information in Excel’s help files about the way Microsoft suggests that you use ​these functions, but nowhere do they mention that you can use them to clean text…

Data Coding – Top 3 Data Classification Tips

Data Coding – Top 3 Data Classification Tips

​This blog post is all about data coding, and will give you our top 3 tips on how best to code your data. ​It is the third blog post in the series, following hot on the heels of 11 Essential Tips for Effective Data Collection and 5 Data Cleaning Techniques You Need To Learn. Here we deal with coding…

5 Data Cleaning Techniques You Need To Learn

5 Data Cleaning Techniques You Need To Learn

The previous blog post in this series 11 Essential Tips for Effective Data Collection dealt with practical data collection methods. This blog post is the second in the series and will teach you the 5 most important data cleaning techniques that you’ll ever need​. Data cleaning may not be everyone’s favourite part of working with data, but…

Do NOT follow this link or you will be banned from the site!