NORMSDIST Excel Formula

Zaheer

Microsoft Excel has been partly included in most of the computation activities in the office, school, or for personal businesses. This is because Excel offers a range of functions such as Text Functions, Statistical Functions, Engineering Functions, and many others.

In the Statistical Functions, you can do a lot of computations with it. This function allows the user to do complex and common statistical calculations such as the mode, median, mean, and, to probability tests. On the other hand, some of these functions are not pre-integrated or offered in earlier version of Microsoft Excel.

The sub-group distribution and test of probability includes Excel NORMSDIST function. The function enables you to easily compute Standard Normal Cumulative Distribution Function for a particular given value. This distribution function has a standard mean of zero and an average deviation of one wherein you can use the function to replace a table of the areas of the standard normal curves.

The syntax of the function NORMSDIST is =NORMSDIST (z). The arguments z in the function refers to the value which you would like to compute the function.

You need to open up a blank Excel spreadsheet or worksheet and try to input the sample values and function. Select the cell A1 and input the function =NORMSDIST (2.3) and the outcome of the function will be 0.98927589. Another example, select the cell A2 and input the formula =NORMSDIST (0) and the result will be 0.5. Lastly, input the formula =NORMSDIST (1.333333) and the result of the function will be 0.908789.

To change views from the result to formula and vice versa, select first the cell containing the formula and hit the keys Ctrl+` (grave accent). In addition, you can easily do this by selecting the cell, and then hitting on the required Formulas tab select the Formula Auditing group, and select the Show Formula button.

If an error #VALUE! Occurs while using the function, this occurs when the given argument in the function is non-numeric values.