+ Reply to Thread
Results 1 to 2 of 2

Unusual NORMSDIST Function

  1. 02-15-2016, 12:56 AM #1
    gimann421
    gimann421 is offline
    Registered User
    Join Date
    08-02-2015
    Location
    Charlotte, NC
    MS-Off Ver
    2013
    Posts
    2

    Unusual NORMSDIST Function

    So NORMDIST(x, mean, std dev, cumulative)=NORMSDIST((x - mean)/std dev).....

    However, I have come across some work (correct work) by someone who solved the probability that something DID NOT happen before x, where they solved NORMSDIST((mean - x)/std dev).... basically 1-(normal)NORMDIST...

    Is that the explanation the reason why? That he/she was looking at the probability that something DID NOT happen?
    Reply With QuoteRegister To Reply
  2. 02-15-2016, 04:04 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,617

    Re: Unusual NORMSDIST Function

    If I understood well -> probablility that something did or didn't happen is equal 1 (you are 100% sure that something happened or not happened)
    so if probability that something happened is X, then probability that something did not happen has to be 1-X

    Having this in mind 1-NORMDIST... is a good equation to asses probability that something did not happen if the distribution of probablility of happening is normal one.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with NORMSDIST and distribution of hours
    By RE_NERO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2014, 10:29 PM
  2. The formula for NORMSDIST is wrong?
    By SyBorg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-07-2011, 04:57 PM
  3. NORMSDIST function solving
    By Paulo Rodrigues in forum Excel General
    Replies: 1
    Last Post: 10-23-2010, 03:31 AM
  4. Using Existing NORMSDIST() Function in VBA
    By glade in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2009, 03:07 AM
  5. [SOLVED] Unusual Request...
    By LewisAire in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 08:38 AM
  6. NORMSDIST() and NORMSINV()
    By Schizoid Man in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2006, 01:55 PM
  7. [SOLVED] NORMSDIST
    By crapatmath in forum Excel General
    Replies: 2
    Last Post: 01-05-2006, 10:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1