An Easy Way to Master INDEX/MATCH Formulas
At least once a month I use an INDEX/MATCH formula to match and merge patient data from multiple Excel files. I wrote this post because when I first sought to learn the technique I found the other tutorials on the web either lacking or hard-to-follow. If you’re reading this, chances are you have strong Excel [...]
Missing Data Techniques for Dummies
This is not another article explaining various missing data techniques. This is a post about how to use them without getting an advanced degree in statistics or charming that nice young Data Analyst into doing it for you. If you Google “missing data” you will be barraged with complicated statistical techniques. That’s par for the [...]
How to do Percentile Ranking in Oracle
Recently I had to provide a script to convert a dataset of raw assessment scores into an Oracle table with the scores ordered by percentile rank. This is a common request so I figured a short, non-technical post on percentile ranking might be helpful to a lot of people. There are three main ways to [...]
Cato's Life of the Mind is the personal site of Jamel Cato, a writer and database developer who can usually be found between the pages of a good book when he's not laughing with his kids. | 