[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