Mastercard Interview Question

How did you carry out this data analysis?