![]() NORM.S.DIST expects standardized input in the form of a z-score value. A z-score value represents how far a value is from the mean of a distribution in terms of the standard deviation of the distribution. ![]() =NORM.S.DIST(1,FALSE)=0.2420 // Returns the standard normal PDF =NORM.S.DIST(1,TRUE)=0.8413 // Returns the standard normal CDF The parameter, z, represents the output we are interested in and cumulative flag indicates whether the CDF or PDF function is used. ![]() For example, NORM.S.DIST(1,TRUE) returns the value 0.8413 and NORM.S.DIST(1,FALSE) returns the value 0.2420. The NORM.S.DIST function returns values for the standard normal cumulative distribution function (CDF) and the standard normal probability density function (PDF).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |