Stuart McLachlan
stuart at lexacorp.com.pg
Thu Oct 23 01:48:41 CDT 2008
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