Sigma Calculation in Access

[Diana]

I have been using the following standard Sigma calculation formula in Excel:
=(NORMSINV(1-DPMO#/1000000)+1.5). I have been trying to find a similar
formula in Access, since the "normsinv" function does not exist, and found
the following:

=0.8406+SQRT(29.37-2.221*(LN(DPMO#)))

However, when I use a DPMO of 55,5555 the result is 3.09 in Excel and 3.10
in Access.

Does anyone know a better or more exact formula to use in Access? Or, is
can the numbers in the Access formula be expanded to further decimal points
to be more exact (i.e. the "0.8406", "29.37", or "2.221")?

 

[Jim Burke in Novi]

You can invoke the Excel functions themselves. Here's a link on how to do
that...

http://support.microsoft.com/kb/198571

Not sure why your Access version of the calculation comes out different.

 

[Diana]

Thanks, Jim. Do you know if this calling of Excel functions works
differently in different versions of Access?

 

[Jim Burke in Novi]

Just include a reference to Excel. In VBA, go to Tools, References, find the
entry for Excel and check the checkbox. I wouldn't think there would be any
differences from verison to version in how you call the functions.