The process consisted of two panel interviews and one excel based and one Stata test. After the first interview and excel and a stata test was given. The excel test was to check formula building capability and spotting issues in charts. And stata was to merge two databases and run some commands.