Hi
I would ask this question in the Access newsgroup :-)

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
Hi Tom:

Thank you so much. I know how to do this on Excel now.
But could I ask you if I can use these code for Access
report? Or if we cannot, could you tell me how we can
export this results to Acess report? Thank you very much.

Charles



-----Original Message-----
no.

If a range/worksheet formula

=Percentile(A1:A1000,0.3)


If we are talking code: (from the immediate window)

? application.Percentile(Range("A1:A1000"),0.3)
292.7

to show use of an array, I will pick up the values from
A1:A1000, but the
array could be populated other ways.
varr = Range("a1:a1000").Value
? APPLICATION.Percentile(varr,0.3)
292.7

--
Regards,
Tom Ogilvy



"Charles Deng"
wrote in message
...
Hi Tom:

Thanks a lot. I did find that instruction but I still
have a question.

The example given in the instrction is

percentile({1,2,3,4}, 0.3) equals 1.9.

It seems that I have to enter all number of array. But I
would like to use the array of numbers in the data set.
Suppose I have a variable which contains numbers from
1.00
(min) to 9.25 (max) and there are 1000 numbers there.
Can
I just type in min and max rather than all different
numbers in the array? Thanks.

Charles



-----Original Message-----
Look in Excel help at the percentile worksheet
function.

--
Regards,
Tom Ogilvy


"Charles Deng"
wrote in message
...
Hi All:

Is there any formula I can use to calculate
percentile
value? Suppose I want to know top 75 percentile
value
of
a varialbe, can I just write a formula to obtain that
value as we do for mean, max, min, frequency, etc.?
Any
advice will be highly appreciated.

If this question is stupid or impossible, please let
me
know, too. Thanks.


Charles





.



.