Is the erfcinv() function defined in cuda/include/math_functions.h
equivalent of NORMSINV in excel?
Is the erfcinv() function defined in cuda/include/math_functions.h
equivalent of NORMSINV in excel?
Is the erfcinv() function defined in cuda/include/math_functions.h
equivalent of NORMSINV in excel?
I am not familiar with Excel and its NORMSINV function, but Google search results seem to indicate that the two functions are related as follows:
erfcinv(p) = -NORMSINV(p/2)/SQRT(2)
As with all internet search results, it would be best to double-check using a reputable source (e.g. a book on statistics) before proceeding with the above formula.
I am not familiar with Excel and its NORMSINV function, but Google search results seem to indicate that the two functions are related as follows:
erfcinv(p) = -NORMSINV(p/2)/SQRT(2)
As with all internet search results, it would be best to double-check using a reputable source (e.g. a book on statistics) before proceeding with the above formula.