The Personal Site of Jamel Cato



   Jamel Cato in 2008  

Entries Tagged as 'Data Analysis'

An Easy Way to Master INDEX/MATCH Formulas

September 1st, 2008 ·

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.

[Read more →]

Tags: Data Analysis · Excel · Jamel Cato

Missing Data Techniques for Dummies

July 3rd, 2007 ·

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.

[Read more →]

Tags: Data Analysis · Jamel Cato

How to do Percentile Ranking in Oracle

June 26th, 2007 ·

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 calculate [...]

[Read more →]

Tags: Data Analysis · Jamel Cato · Oracle