Sigma Calculation in Access

  • Thread starter Thread starter Diana
  • Start date Start date
D

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")?
 
Thanks, Jim. Do you know if this calling of Excel functions works
differently in different versions of Access?
 
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.
 
Back
Top