WorksheetFunction.Norm_S_Inv(Double) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.
public:
double Norm_S_Inv(double Arg1);
public double Norm_S_Inv (double Arg1);
Public Function Norm_S_Inv (Arg1 As Double) As Double
Parameters
- Arg1
- Double
Probability - A probability corresponding to the normal distribution.
Returns
Remarks
If probability is non-numeric, Norm_S_Inv returns the #VALUE! error value.
If probability < 0 or if probability > 1, Norm_S_Inv returns the #NUM! error value.
Given a value for probability, Norm_S_Inv seeks that value z such that NORM_S_DIST(z) = probability. Thus, precision of Norm_S_Invdepends on precision of Norm_S_Dist(Double, Boolean). Norm_S_Inv uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기