NORM.S.INV Function:
In this article, we are going to see how to use Excel NORM.S.INV Function in Office 365 with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
NORM.S.INV Function – Description:
- This function returns the inverse of the standard normal cumulative distribution.
- This distribution considers the mean value as 0 and the standard deviation value as 1.
Syntax:
=NORM.S.INV(probability)
Parameter Description:
*Probability – * It is the probability corresponding to the normal distribution.
Note:
- If probability is non-numeric values such as letters or special characters , then it returns#VALUE! Error.
- If the probability is less than or equal to 0 or greater than or equal to 1 , then this function returns #NUM! Error.
Examples:
Let see some examples to understand how this function works.
Example 1:
- In the below example image, you can see the input numbers are given in Column B , and its output values are displayed in Column C.
Example 2:
- If probability is non-numeric values such as letters or special characters , then it returns#VALUE! Error.
Example 3:
- If the probability is less than or equal to 0 or greater than or equal to 1 , then this function returns #NUM! Error.
From the above examples, you can learn how to use the NORM.S.INV Function.
Summary:
In the above article, you can understand the usage of Excel NORM.S.INV Function in Office 365 with its syntax, explanation, and examples. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!
Top comments (0)