PepsiCo Interview Question

How would you solve this data problem?