median/95%-percentil on Access?

[Misha]

Hi!

I was just asking me if it is possible on Access get out
the median and the 95%-percentil from a table of data doing
a query?
Is there a simply way, without needing to code?

Thanks,
Misha.

 

[M.L. Sco Scofield]

Short answer - No.

It's going to take some code or purchase a third party program from someone
like FMS.

I haven't seen any code for percentile, however, there is some code for
median at http://support.microsoft.com/default.aspx?scid=kb;en-us;210581.

The FMS product mentions percentiles, median, and *much* more. Take a look
at
http://www.fmsinc.com/products/statistics/productguide.htm#DataAnalysisFunctions.

Good luck.

Sco

 

[Guest]

Thanks for the fast answer!

Now, I tried to follow the instruction for the 'median
code', but while trying to set the expression =Median
("<TableName>", "<FieldName>") in the ControlSource Line
in the textbox properties, I got an error messagge about
(it's in german) missing operators, wrong signs, etc.

Anybody knows what's wrong?

Bye,
Misha.

 

[M.L. Sco Scofield]

I've used this code before and it works just fine.

I hate to ask a question like this, but, in the line, =Median
("<TableName>", "<FieldName>"), you did replace <TableName> and <FieldName>
with the names of *your* table and field names, didn't you?

So, if you were going to find the median of the Freight field in the Orders
table in the Northwind database, the line should read:

=Median("Orders","Freight")

If this isn't the problem, you might try posting the error message in the
Deutsch Access group at microsoft.public.de.access.

Sco