Compute a Trimmed Mean

http://ift.tt/1ySOJT1

Learn two methods: the NTILE function and the PERCENT_RANK or CUME_DIST function

Use the trimmed mean method to exclude outliers from the computation of an average aggregate.

read more

from SQL Server Pro http://ift.tt/1lGKtPv