NORMSDIST Excel Formula
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.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro