[AccessD] z score to percentile calculator

Stuart McLachlan stuart at lexacorp.com.pg
Thu Oct 23 01:57:14 CDT 2008


Oops, try this:

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
 End Function
-- 
 Stuart




More information about the AccessD mailing list