Results 1 to 4 of 4

=norm.dist function error

Threaded View

belle_ =norm.dist function error 10-25-2019, 11:58 AM
MrShorty Re: =norm.dist function error 10-25-2019, 01:24 PM
belle_ Re: =norm.dist function error 10-25-2019, 02:31 PM
MrShorty Re: =norm.dist function error 10-25-2019, 02:43 PM
  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

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