Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Sigma numbers?! -- NORMSINV Dilemma

Author  Topic  nstout Starting Member 8 Posts Posted - 2001-05-21 : 17:56:02 I need a SQL equivalent to Excel's NORMSINV function. The defintion for the NORMSINV function is provided here on Microsoft's website: [url]http://support.microsoft.com/support/kb/articles/Q87/8/66.ASP[/url] I'm trying to calculate sigma numbers within SQL, but when I try to replicate the NORMSINV function within SQL my numbers come out wrong. In EXCEL, the formula: NORMSINV(.9)+1.5 = 2.781550794 ...but my SQL recreate equals 0.701624 so I've done something wrong, but can't figure it out. A stored procedure would be ok, but a formula in a select statement would be better. Any ideas? Edited by - nstout on 05/21/2001 17:56:54