Here, below sample table for caluculating medain, 2nd standard deviation, min, max and outlier calculation. I'm trying to calculate but its shows wrong value in sql server 2008.
Rat Cat A B C Median 2StandDevi Count Min Range Max Range Outlier
AAA 1 6.5 6.25 2.56 6.25 4.4122707684
AAA 3 5.25 7.36 3.25 5.25 4.1104906439
AAA 5 3.25 6.25 4.25 4.25 3.0550504633
AAA 7 6.25 6.32 6.35 6.32 0.1026320288
AA 1 7.23 8.52 7.35 7.35 1.4253420642
AA 3 7.83 7.01 6.52 7.01 1.3237824595
AA 5 7.2 7.03 4.52 7.03 3.0012663994
AA 7 7.14 5.03 6.32 6.32 2.1273771018