Excel Function : NORMINV
Category
Statistical
Description
Returns the inverse of the normal cumulative distribution
Microsoft Excel Reference Page
https://support.office.com/en-us/article/NORMINV-function-87981ab8-2de0-4cb0-b1aa-e21d4cb879b8
Syntax and Description of the NORMINV Excel Function
in R?
I am trying to use the NORMINV Excel function in R. I have tried the following:
NORMINV(0.5,0,1)
but I get the following error message:
Error in NORMINV(0.5, 0, 1) : object 'NORMINV' not found
How can I get the NORMINV Excel function to work in R?
A:
Try qnorm(0.5,0,1)
.
qnorm(0.5,0,1)
[1] 0
About NORMINV Excel Function
The NORMINV function returns the inverse of the normal distribution for a given mean and standard deviation.