PERCENTILE() - Arguments?

[(PeteCresswell)]

Suppose I feed an array of 20 values to PERCENTILE()

Some of these values are numeric, others are non-numerics like "NA11".

Now suppose I feed it the same array of values, except that the non-numerics
like "NA11" are replaced by "0".

Should I always get the same results?

 

[(PeteCresswell)]

Per (PeteCresswell):

Now suppose I feed it the same array of values, except that the non-numerics
like "NA11" are replaced by "0".

Should I always get the same results?

Upon reflection, I guess that what I'm really asking is whether or not I should
create a middle-man array that is shorter than the original by virtue of having
those non-numeric values dropped.

Seems possible that maybe the Excel UI automagically strips these values out
behind the scenes because when I try to feed the same array (of
..DataType=Variant) to Excel.WorksheetFunction.Percentile(), it abends on a data
type mismatch.

 

[Mike Middleton]

Pete -

No, I don't think so.

Non-numeric entries effectively change the number of numeric values used in
the percentile calculations. That is, in the Help description of the
function, the value of n is being changed.

- Mike
www.mikemiddleton.com