NORMINV Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is an application that contains calculation, graph tools, and other mathematical and computation functions and formulas. One of the functions found in Excel is the Statistical Function which allows you to perform statistical computations, mean, median and mode, and other simple and complex statistical calculations. However, some of these functions are not present or pre-installed in the older versions of Excel.

One of the Statistical Function in Excel is the NORMINV Function that allows you to compute the contrary of the normal cumulative distribution. It also includes the given value of the mean and the standard deviation.

The syntax of the function or the sequence of arguments is NORMINV(odds,mean,average_dev). The argument probability refers to the normal distribution, the mean argument is the arithmetic mean value of the distribution, and the standard_dev argument refers to the standard deviation.

To test the function, open a black spreadsheet or worksheet and select a blank cell. Input the corresponding values of the mean with 5, average deviation of 2, and with the probability of 0.6. The function will be =NORMINV ( 0.6, 5, 2 ) and the result will be 5.506694206.

You can try another example with the use of source. Input in cell A1 the value 0.908789 which refers to the probability of the normal distribution. In cell A2 input the value 40 which is the value of the mathematics mean of the given distribution. Input in cell A3 the value 1.5 which is the value of the average deviation of the given distribution. The formula will now be inputted in cell A4 as =NORMINV (A2, A3, and A4) and the result will be 42.

The common errors that occur during the usage of this function are the #VALUE! error and the #NUM! error. The #VALUE! error occurs when the given arguments in the syntax are non-numerical values. For the #NUM! error when the given value of the probability is less than 0 or more than 1, If the standard_dev argument is less than or equivalent to 0.

If you would like to view the results from formula you can do this be selecting the cell and pressing Ctrl+` (grave accent). You can also do this by the hitting the Formulas tab and in the Formula Auditing select the Show Formulas

Post comment