March 26, 2012 at 10:53 pm
Hi .. Can u pls say equvalent sql code for NORMINV Excel Function ..
Note I need NORMINV not NORMSINV
Please help me in this regard ..
Thanks in Advance..
March 26, 2012 at 11:05 pm
Are you trying to do it in T-SQL, or MDX/DAX/DMX?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 27, 2012 at 12:47 pm
Well,
NORMINV(p, mu, sigma) = mu + sigma*NORMSINV(p)
So all you need to do is get a NORMSINV(p) UDF (one can be found at: SqlServerCentral[/url]) and implement the formula above in SQL.
More about the NORMINV equation can be found at: microsoft support
Goodluck!
/>L
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 11:14 pm
Thanks so much . gt it 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply