PsiTheoTarget/PsiTheoXtoP

PsiTheoTarget(cell_or_name, target)

PsiTheoXtoP(cell_or_name, target)

Returns the cumulative probability for "target" for the specified distribution. The cumulative probability returned is the probability of a value less than or equal to "target" occurring.

Example: If A1 =PsiNormal(0,1) then

=PsiTheoTarget(A1, 500) and PsiTheoXtoP(A1, 500) returns the cumulative probability of the target value, 500, of the PsiNormal(0,1) distribution.

Note: Analytic Solver statistics functions that begin with PsiTheo return a statistic on a simulation input distribution.