NORMINV SQL EQUVALENT CODE

  • 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..

  • 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

  • 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

  • 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