Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To: Get a better average
Message
De
02/02/2010 16:32:02
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01447163
Message ID:
01447181
Vues:
43
>>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
Fil
Voir

Click here to load this message in the networking platform