(if you used z=2, you should get an area of 0.97724 or in other words, more than 97% of the population have scores lower then your z. a) Pick a cell and enter a z score into it (for example 2), don�t forget to add a label so you�ll know what you put in this cell.ī) In a cell next to it, enter the function NORMSDIST(Z), use the address of the cell where you placed the z score as your z value.Use this function in place of a table of standard normal curve areas. The distribution has a mean of 0 (zero) and a standard deviation of one. Returns the standard normal cumulative distribution function. Z is the value for which you want the distribution.

Excel Basics � Finding areas under the normal distributionĮxcel Basics � Finding areas under the normal distribution.Įxcel has some very useful functions for finding areas under the normal distribution.