Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement