![what is the standard normal table for z score excel what is the standard normal table for z score excel](https://conversion-uplift.co.uk/wp-content/uploads/2020/06/Z-Score-Table-for-Standard-Normal-Distribtion-to-the-left-of-a-positive-score.png)
NORMSINV and NORMSDIST are related functions.
![what is the standard normal table for z score excel what is the standard normal table for z score excel](https://sphweb.bumc.bu.edu/otlt/MPH-Modules/PH717-QuantCore/PH717-Module6-RandomError/Z%20score%20table.png)
Because p corresponds to a probability, it must be greater than 0 and less than 1. A standard normal random variable has mean 0 and standard deviation 1 (and also variance 1 because variance = standard deviation squared). NORMSINV(p) returns the value z such that, with probability p, a standard normal random variable takes on a value that is less than or equal to z. To compare results of the function for Excel 2003 and later versions of Excel with results of the function when it is used in earlier versions of Excel To describe the NORMSINV function in Microsoft Office Excel 2003 and in later versions of Excel The purposes of this article are as follows: