Mastercard interview question

How did you carry out this data analysis?