# =norm.dist function error

1. ## =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

2. ## 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

3. ## Re: =norm.dist function error

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. ## 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?

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

#### 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