+ Reply to Thread
Results 1 to 4 of 4

=norm.dist function error

  1. #1
    Registered User
    Join Date
    10-25-2019
    Location
    chicago,il
    MS-Off Ver
    microsoft 365
    Posts
    2

    =norm.dist function error

    Hello everyone,

    I'm having issues with the=NORM,DIST() function. This is for a project on hypothesis testing and it's required to use that function to find the p-value. My teacher provided us a data on live births from all 52 states in December of 2009.

    This the analysis of the data from excel.
    excel example.JPG

    We're supposed to find the p-value using the =norm.dist() function
    she said to use this formula to find the p-value:
    =NORM.DIST(sample mean, null value standard deviation/sqrt(size),TRUE)
    so i plug in the the data
    =NORM.DIST(47181.08,6000,47841.45/SQRT(52),TRUE)

    but all I get is 1 and I know that's not the right answer.

    For the other data I'm doing hypothesis testing on, I'll get an actual answer. I know these are all large numbers which I think may be messing up the answer?

    Any help is appreciated.
    Thank You
    Attached Images Attached Images

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

    Re: =norm.dist function error

    I will let you do the leg work, but it appears to me that either you or your instructor have misunderstood the order and meaning of the arguments to the NORM.DIST() function. Compare your proposed formula/arguments to what is described in the help file: https://support.office.com/en-us/art...rs=en-US&ad=US
    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
    10-25-2019
    Location
    chicago,il
    MS-Off Ver
    microsoft 365
    Posts
    2

    Re: =norm.dist function error

    Thanks for replying.

    When I try to remove the /sqrt(size), it gives an actual answer of .805.

    I also tried to compute the test statistic first and use the norm.s.dist (z,cumulative) and the answer excel gives is also 1.
    I'm not sure if there's something with excel or what

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: =norm.dist function error

    I got the same result when I removed the sqrt(n) part of the 3rd argument. Now let's look at the rest of the arguments.

    Your proposed function: =NORM.DIST(sample mean, null value standard deviation/sqrt(size),TRUE) or =NORM.DIST(sample mean, null value standard deviation,TRUE)
    From Excel help file: NORM.DIST(x,mean,standard_dev,cumulative)

    Which argument should be first? Where should the mean go in the argument list?

+ 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 not working
    By targus92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2018, 04:43 PM
  2. Calculate Norm Dist using pivot table
    By ashy_r in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-26-2016, 03:19 PM
  3. 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
  4. [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
  5. Inserting row of values for k into the binomial dist. function
    By Ernst88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2014, 11:58 AM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Replies: 0
    Last Post: 09-20-2011, 11:49 AM

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