Data Analysis

How to match names in Excel where spelling differ

Hi recently had to match two sets of data by names, where the names were similar but not quite the same. There were 3,500 of them so I needed to do it automatically. I managed to do a good job using Microsoft Excel and I thought others might benefit from hearing how I did it. For those of you that…read more →

Useful tools for data analysis

I exhibited at the excellent seminar called ‘Advanced Analytics‘ organised by the OR society last Wednesday (25/4/12) and offered a free handout with some of the new tools, many of them free, for spatial visualisation and analysis. I hope this is useful to people. At the conference Liz Shepherd from Hotels.com said that no one tool if sufficient for data analysis….read more →