[AccessD] z score to percentile calculator

Perfect.  Exactly what I was looking for. I think.  I'll give it a test. But
it looks right.

I had read in MSDN about this technique but didn't know what the Excel
function was or if there was one.  That I couldn't find in the Excel help.  

Interesting app, BTW.  Pediatric endocrinologist at Children's Hospital
treating diabetics primarily, wants to put together a db to slice and dice
data with the objective of doing various kinds of studies.  Big 'what if'
kind of database.  So he needs the Z (which I can calculate) and percentile
on things like height vs. Age, weight vs. Age, head circumference, etc.

Thank you.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, October 22, 2008 11:49 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] z score to percentile calculator

Simplest way is to set a reference to Excel and then use the NormSDist()
function:

Function NormSDist(ZScore As Double) As Double 'Dim xlapp  As New
Excel.Application 'NormSDist = xlapp.NormSDist(ZScore) 'xlapp.Quit 'Set
xlapp = Nothing

NormSDist = 1/2
End Function



--
Stuart

On 22 Oct 2008 at 22:04, Rocky Smolin at Beach Access  wrote:

> Dear List:
>  
> I need a z score to percentile calculator.  Does anyone have a link to 
> such a routine?  Or is there a built in function for this in Access or
VBA?
>  
> MTIA
>  
> 
> 
>  	
> 	
>  
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/>
> 
> www.bchacc.com <http://www.bchacc.com/>
> 
>  
> 
>  
> 
>  
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com