Help using Base SAS procedures

Z-score

Reply
Super Contributor
Posts: 1,040

Z-score


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

Super User
Posts: 10,500

Re: Z-score

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.

Super Contributor
Posts: 1,040

Re: Z-score

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

Ask a Question
Discussion stats
  • 2 replies
  • 258 views
  • 3 likes
  • 2 in conversation