topic Re: Z-score in SAS Procedures

Z-score

robertrao — Fri, 30 Nov 2012 01:35:48 GMT

Z Score

7.711357

0.826565

-0.48562

-1.55803

I have the following Z scores

To find the P-value in Excel I am using

=1-NORMSDIST(Z location)

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

Regards

Re: Z-score

ballardw — Fri, 30 Nov 2012 16:08:07 GMT

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.

Re: Z-score

robertrao — Fri, 30 Nov 2012 16:12:42 GMT

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

https://communities.sas.com/message/146263#146263

Regards