Learn Excel Episode 760: No Outliers

Posted in Companies, Podcasts on July 15, 2008

How can you calculate the MIN or MAX value ignoring one outlier? Or, how can you figure out the MIN or MAX throwing out 5% of the outliers? Episode 760 takes a look at SMALL, LARGE, and PERCENTILE functions.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, MIN, LARGE, Outlier, PERCENTILE, SMAL