Category Archives: Blog

Sharing the knowledge

A major problem for organisations is that analytics consultants conduct (relatively simple) analysis but don’t [...]

SPSS table trick

For scaled questions, the output of SPSS tables places the mean scores in a separate [...]

SumIfs Vs VLookups / Index-Match

Standard Excel look-up functions suffer from a problem in that they only match on a [...]

Quick trick to check whether columns are identical

Excel stores the value for True as 1 and a False as 0. So, if [...]