# How to Use NORMINV Function in Excel

Get FREE Advanced Excel Exercises with Solutions!

In real life, statistical calculation is our quotidian work. By using  Microsoft Excel, we can easily perform these statistical calculations. The NORMINV Function in Excel is useful for us to calculate the inverse of the Cumulative Normal Distribution for a supplied value and a supplied distribution mean & standard deviation. In this article, we’ll get to learn how we can use the NORMINV function effectively in Excel with appropriate illustrations. ## Introduction to NORMINV Function in Excel

👉 Function Objective

NORMINV returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

👉 Syntax

=NORMINV(probability,mean,standard_dev)

👉 Arguments Explanation

Argument Required/Optional Explanation
probability Required A probability corresponding to the normal distribution.
mean Required The distribution’s arithmetic mean.
standard_dev Required The distribution’s standard deviation.

## Use of NORMINV Function in Excel

Let’s say, we have a dataset where Probability, Mean, and Standard Deviation are given in Column B, Column C, Column D respectively. We want to calculate the Cumulative Normal Distribution’s Inverse of these data that has been given in our Excel Worksheet by using the NORMINV Function. Now, we will calculate the inverse of the Cumulative Normal Distribution for the values that have been given in Row 5 and the value of Probability, Mean, and Standard Deviation is 0.25, 50, and 1 respectively. For this, let’s follow the instructions

Step 1:

• First, select cell E5 and type the NORMINV Function in the Formula Bar. The formula is
`=NORMINV(B5,C5,D5)` Step 2:

• Now press Enter on your keyboard and you will get 33 in cell E5 as the return of the function. • After that, place your Cursor on the Bottom-Left on Cell E5, and the Plus sign(+) pops up and then press the Left-Click on your Mouse and drag it downward. • Finally, you will be able to calculate the Cumulative Normal Distribution’s Inverse of these data that is given in the screenshot. ## Things to Remember

⏩ NORMINV Function is used to calculate the inverse of the Cumulative Normal Distribution

#VALUE error – happens when

• Probability is not numeric
• Mean is not numeric
• Standard_dev is not numeric

#NUM error – happens when

• “Probability” < 0
• “Probability” > 1
• “Standard_dev” = 0

#N/A error – happens when

• The function does not converge after 100 iterations

## Conclusion

I hope the method that has been mentioned above to use the NORMINV function will now provoke you to apply it in your Excel spreadsheets with more productivity. You are most welcome to comment if you have any questions or queries.

## Related Articles #### Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  