ExcelBanter - Z Score probibility

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Z Score probibility (https://www.excelbanter.com/excel-discussion-misc-queries/95296-z-score-probibility.html)

MABeatty

Z Score probibility

Using excel I've standardized some data to get a Z score of 1.197. To
determine the probability this value I can look it up in a table, but
there has
to be a function in excel to do it. Any help would be appreciated

--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=554256

Barb Reinhardt

Z Score probibility

Try using NORMDIST.

"MABeatty" wrote:

Using excel I've standardized some data to get a Z score of 1.197. To
determine the probability this value I can look it up in a table, but
there has
to be a function in excel to do it. Any help would be appreciated

--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=554256

All times are GMT +1. The time now is 10:39 AM.