NORM.S.INV Function
Get the inverse of the normal cumulative distribution for a given probability value
Get the inverse of the normal cumulative distribution for a given probability value
The NORM.S.INV Function is categorized under Statistical functions. It will calculate the inverse normal cumulative distribution for a given probability value. Introduced in MS Excel 2010, the NORM.S.INV function is an updated version of the NORMSINV function.
As a financial analyst, the NORM.S.INV is useful in stock market analysis. We can use the function to understand how a portfolio is affected by any additions or withdrawals made.
Suppose an appliance manufacturer is investigating the failure times of the heating element of the company’s toasters. It wishes to determine the time at which specific proportions of the heating elements fail in order to set the product’s warranty period. Heating element failure times follow a normal distribution, with a mean of 1,500 hours and a standard deviation of 300 hours.
The manufacturer can use the NORM.S.INV function to determine the time by which 5% of the heating elements fail, the times between which 95% of all heating elements fail, and the time at which only 5% of the heating elements continue to function.
If the distribution of the heating element failures follows a normal distribution with a mean of 1,000 and a standard deviation of 300, the time by which 5% of the heating elements are expected to fail is the inverse CDF of 0.05.
=NORM.S.INV(probability)
The NORM.S.INV function uses only one argument:
To understand the uses of the NORM.S.INV function, let us consider an example:
Given a probability of 0.95, to calculate the inverse of the Standard Normal Cumulative Distribution Function, we will use the following formula:
We get the result below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!