11-29-2012 08:35 PM
I have the following Z scores
To find the P-value in Excel I am using
Is this usage right????
When I use this I get values like 1.00253E-13 for a z score of 7.348469
for some Z scores I am getting a p-value of zero
Please help me get this right
11-30-2012 11:08 AM
It looks right but I would wonder if my data is actually normally distributed if I get values that are getting Z scores in the 7 range unless there are more than 1.E13 observations. When you get 7 standard deviations from the mean in a normal distributions there is not much left in the tails.
11-30-2012 11:12 AM
Thanks a lot for the reply.
I have posted the same question on several places in the SAS Forum. Sorry about that. steve posted a detailed discussion on this topic