>>I need a short and sweet lesson here. I would like to do some very basic statistics on data. Say the values are: 5,21,26,17,28,31,36,41,29,90. What is an acceptable way to reject highs and lows mathmatically. The extremes throw off an average. What is the difference between mean and average? Any formulas or help would be greatly appreciated.
>
>If you have these values in a cursor, you can use MAX() and MIN() to extract those values.
I understand the MIN & MAX functions, but what is in the above sample of data, you added 6,8. I need to know what is a statistically correct way to reject these low numbers. How far off of the standard deviation is ok? Basically I want to get a reasonable average. These numbers skew things way off.
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