turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- Z-score

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

11-29-2012 08:35 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

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

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

Regards