Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To: Get a better average
Message
 
 
À
02/02/2010 16:14:36
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:
01447176
Vues:
31
>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform