Post reply

NORMSDIST Excel function for SQL Server 2008

  • October 7, 2014 at 6:46 pm

    #397472

    Hello,

    I'm trying to program the NORMSDIST Excel function in SQL Server 2008, can you help me?

    Thanks in advance.

  • October 7, 2014 at 7:18 pm

    #1750810

    According to Wikipedia, the following should give the result but it doesn't according to this.

    DECLARE @Var float = 2.3

    SELECT POWER( 2.71828182845904523536, -.5 * SQUARE(@Var))/ SQRT(PI() * 2)

    If you have the formula, we can work on that. 😉

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply