Resolve outliers skewing analytics by clamping input values between 100 and 3000 using nested IF or MIN MAX functions.