Excel NORM.DIST Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to get the values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF), you can use NORM.DIST function.
In this tutorial, we will guide you to learn how to use Excel NORM.DIST Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Explanation of NORM.DIST Function
- It is one of the built-in functions in Microsoft Excel.
- This function returns the normal distribution for the specified mean and standard deviation.
- NORM.DIST Function returns values for the normal probability density function (PDF), and normal cumulative distribution function (CDF).
- You can find the mean using the AVERAGE Function and find the standard deviation using the STDEV Function.
Syntax
- Here, you will see the syntax of the NORM.DIST function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=NORM.DIST(x, mean, standard_dev, cumulative)
Arguments Explanation:
- x – It is the input value to which you want to find the distribution.
- Mean – The arithmetic mean of the distribution.
- Standard_dev – It is the standard deviation of the distribution.
- Cumulative – The boolean value that represents the form of the function. If it is TRUE, this function returns the cumulative distribution function (CDF). If it is FALSE, it returns the probability density function (PDF).
Note:
1) If the argument mean or standard_dev is non-numeric values such as letters, and symbols, then this function returns #VALUE! Error.
2) If standard_dev is less than or equal to 0, then it returns #NUM! Error.
Examples
Let’s see some examples to understand this concept easily.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- In the below screenshot, you can see the input ranges in Columns B & E their mean value is given in Cell I4, and the standard deviation is given in Cell I5.
- The CDF values are displayed in Column C, PDF values are printed in Column F. Apply the above-mentioned formula to get the result, as shown in the following screenshot.
- Finally, we need to click on the Enter button to get the result.
- If the argument mean or standard_dev is non-numeric values such as letters, and symbols, then this function returns #VALUE! Error.
- If standard_dev is less than or equal to 0, then it returns #NUM! Error.
From the above examples, you can clearly learn how to find CDF and PDF values using NORM.DIST Function.
Summary
In this tutorial, you can understand the usage of Excel NORM.DIST Function with its syntax, explanation, and examples. Leave your suggestions in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
Use the following video to know how to apply the Excel NORM.DIST function in the spreadsheet with examples.
See Also:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
