PsiTheoTargetD(cell_or_name, target) PsiTheoXtoQ(cell_or_name, target)
Returns the cumulative descending probability for target for the specified distribution. The cumulative probability returned is the probability of a value greater than or equal to target occurring.
Example: If A1 =PsiNormal(0,1) then
=PsiTheoTargetD(A1, 2) and PsiTheoXtoQ(A1, 2) returns the cumulative descending probability of the target value, 2, of the PsiNormal(0,1) distribution.
Note: Analytic Solver statistics functions that begin with PsiTheo return a statistic on a simulation input distribution.