ufno.blogg.se

(if you used p=0.975, you should get a z score of 1.95996. a) Pick a cell and enter a probability into it (for example 0.975), 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 NORMSINV(probability), use the address of the cell where you placed the probability.NORMSINV will return a z score that corresponds to an area under the curve. The distribution has a mean of zero and a standard deviation of one. Returns the inverse of the standard normal cumulative distribution. Probability is a probability corresponding to the normal distribution. Try other values of z in order to get a better feeling for the use of this function, for example 0,1,5,-1,-3) (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.