General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>>Kirk, depending on the size of your user base, you may want to talk to the business person (or persons) that drives the product functionality, to see what business rules they want.
>>
>>Generally, a calculation of median will minimize the impact of outliers, though some like to use the Mode function as well, which will give you the most common observation point value.
>
>Would be better to talk to the BA there to find out the exact requirements, but in general I think Craig is right - we want to get rid of odd cases before calculating the average.
That's a contradiction of terms! Maybe you don't want the average - but if you do then there's only one way to calculate it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only