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
Bookmarks