+ Reply to Thread
Results 1 to 4 of 4

What is the formula behind NORM.S.DIST(x,TRUE) function?

  1. #1
    Registered User
    Join Date
    07-12-2020
    Location
    Russia, Moscow
    MS-Off Ver
    10
    Posts
    1

    What is the formula behind NORM.S.DIST(x,TRUE) function?

    Hi,

    what is the 'real' formula of norm.s.dist(x,TRUE) ?

    on the microsoft help page I can only find the formula for norm.s.dist(WRONG)
    The given example there: =NORM.S.DIST(1.333333,TRUE) Example: 0.908788726 (description: Normal cumulative distribution function at 1.333333)

    Could someone please let me know how I can calculate the 0,908.. on my own?

    Thanks in advance,

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,552

    Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

    Wikipedia has a better discussion than Microsoft: https://en.wikipedia.org/wiki/Normal...ution_function

    Basically, the cumulative distribution function (CDF) is the definite integral of the probability density function (PDF) from negative infinity to x. Wikipedia talks about some of the ways this integral can be calculated, or you can use your favorite algorithm for numerical integration on the PDF.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    07-12-2020
    Location
    Baden Baden
    MS-Off Ver
    200
    Posts
    2

    Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

    mrshorty

    This dont answer the question what exactly is the calculating path or the formula for the true value in his example!!!


    So do you know the answer or not?

  4. #4
    Registered User
    Join Date
    07-12-2020
    Location
    Baden Baden
    MS-Off Ver
    200
    Posts
    2

    Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

    so how do you calculate the given example The given example there: = NORM.S.DIST 1.333333,TRUE Example: 0.908788726 (description: Normal cumulative distribution function at 1.333333

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. =norm.dist function error
    By belle_ in forum Excel General
    Replies: 3
    Last Post: 10-25-2019, 02:43 PM
  2. Norm.Dist not working
    By targus92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2018, 04:43 PM
  3. Calculate Norm Dist using pivot table
    By ashy_r in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-26-2016, 03:19 PM
  4. Norm.Dist on Test Scores for a Curve
    By jsraadt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2014, 04:24 PM
  5. [SOLVED] Calling Application.NORM.S.DIST issue???
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2014, 12:15 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Replies: 0
    Last Post: 09-20-2011, 11:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1