math - High value among some values disturbs the average.....How to avoid the effect? -



math - High value among some values disturbs the average.....How to avoid the effect? -

i have 12 instances client usage i.e 1200,1220,1230,1190,1250,1180,1270,1210,1240,1300,1290,1280.

the simplest way calculate average no.of instances/12. if 1 of instance has abnormaly high value e.g. 6000. causes overall average deviate greatly.

what best way cater kind of situation without excluding high number?

i know 1 solution define threshold , compare value of each instance before average calculation , other solution take business relationship standard deviation. both of these solutions somehow not feasible data.

if has improve solution please share. thanks

the classical solution kind of problem using median instead of average. can combine these 2 ideas: discard amount of values (e.g. upper , lower 25%) , compute mean of remainder. called truncated mean.

math statistics discrete-mathematics moving-average usage-statistics

Comments

Popular posts from this blog

model view controller - MVC Rails Planning -

ruby on rails - Devise Logout Error in RoR -

html - Submenu setup with jquery and effect 'fold' -