Thanks, everyone, for the great advice. Much appreciated. I should
be able to tackle this now with more confidence. James

On Jul 9, 10:56?pm, Tom Ogilvy
wrote:
mean median mode quartiles variance, standard deviations are not specific to
the normal distribution nor do they have any implicit assumption of
normality. They are called descriptive statistics and are used to describe
and analyze your data.

If you have faith in your friend, then it is unclear why you are posting
here.

You have been give suggestions on how you could "trim" you data none of
which require code and you could have completed them in less than 1% of the
time this thread has existed.

--
Regards,
Tom Ogilvy



"Zone" wrote:
Gimme (Tom and John),
You're absolutely right. If the dataset is not a normal
distribution, then Excel's built-in functions Average, StdDev and
Quartiles are of no use whatsoever. What I didn't mention is that my
friend is an amateur mathematician. He created a model that can take
gamma distributions into account. I have very litlte idea of what
that means except that the program's model includes special functions
which can derive Average, StdDev and Quartiles based on a model that
morphs from normal to chi-squared.

I basically want to speed up his calculations using built-in Excel
functions where possible. I think I understand now why his algorithm
is so complicated. Thanks, guys. If you care to continue this
thread, please post any thoughts you might have. Best regards, James

Indeed, as you brought up,

On Jul 9, 5:14?pm, "
wrote:
These numbers aren't normally distributed so STDs are the wrong too
for the job.

Say I have these numbers:

0.2
1
3.25
5
17
50
125
500
1250
1500
32505
50000

You need to filter the data - just like John lined out.

If you want a no code solution ask the client to filter the data on
his end.

I still don't understand why you think filtering the data requires
hundreds of lines of VBA.- Hide quoted text -

- Show quoted text -