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 learn how to use the NORMINV function effectively in Excel with appropriate illustrations.

How to Use NORMINV Function in Excel


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, and 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.

How to Use NORMINV Function in Excel

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)

How to Use NORMINV Function in Excel

Step 2:

  • Now press Enter on your keyboard, and you will get 33 in cell E5 as the return of the function.

How to Use NORMINV Function in Excel

  • After that, place your cursor on the bottom-left of cell E5, and the plus sign (+) pops up and then press the left-click on your mouse and drags it downward.

mean

  • Finally, you will be able to calculate the Cumulative Normal Distribution’s Inverse of these data that is given in the screenshot.

Probability


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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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.


<< Go Back to Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo