Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Statistics Question
Message
De
23/01/1997 18:37:47
 
 
À
23/01/1997 16:25:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00018260
Message ID:
00018273
Vues:
41
>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.

you can use standard deviation if you have normal distribution (I am not sure of the term in english) of the data (ie the data basically fits the gauss bell)
then you can calculate the mean and standard deviation
and you can set the limits for your query as
x between mean-n*deviation, mean+n*deviation)

n=1 about 33 percent of the data
n=2 about 67 percent
n=3 97 percent
n=3.5 99.something
if my memory serves me right :)

Arnon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform