75 percentile value

C

Charles Deng

Hi All:

Is there any formula I can use to calculate value? I know
can calculate average, sum, and total count. There should
be a formula to calculate 75 percentile value. Am I right?
Thanks for any advice.


Charles
 
G

Guest

Charles,

To my knowledge there is no formula to calculate the 75th
percentile. Could you just multiply the number by .75?

M. Wilson
 
G

Guest

Hi Wilson:

I asked this question to Excel News group and got a
formula like

=Percentile (A1:A1000, 0.75)

If in code:

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

to show use of an array, we can pick up the values from
A1:A1000, but the array could be populated other ways.
varr = Range("a1:a1000").value
?application.Percentile (varr, 0.75)
292.7

Since this formula and code for this calculation can be
found in excel, I guess they should be in Access. Just my
guess.

Charles
 
M

Marshall Barton

Charles said:
Is there any formula I can use to calculate value? I know
can calculate average, sum, and total count. There should
be a formula to calculate 75 percentile value. Am I right?
Click to expand...


No such aggregate (or built-in function) function in Access.

You can use an SQL statment to find the value. This should
be close to what you want:

SELECT TOP 1 field
FROM [SELECT TOP 25 PERCENT field
FROM table
ORDER BY field DESC]. AS T
ORDER BY field

If you also want a function to encapsulate it then just Open
a recordset on the query and return the value.
 
Top