Abbott Interview Question

My thought process of the pricing case and data analysis in Excel