SQX Structured Query Matrix for SQL Server
SQX for SQL Server
sqx
Probability Class
Probability Methods
BernoulliD_CDF Method
BernoulliD_Kurtosis Method
BernoulliD_Mean Method
BernoulliD_PMF Method
BernoulliD_PPF Method
BernoulliD_QDF Method
BernoulliD_Skewness Method
BernoulliD_Variance Method
Exponential_CDF Method
Exponential_Kurtosis Method
Exponential_Mean Method
Exponential_PDF Method
Exponential_PPF Method
Exponential_Rate_MLE Method
Exponential_Skewness Method
Exponential_Variance Method
Geometric_CDF Method
Geometric_Kurtosis Method
Geometric_Mean Method
Geometric_P_MLE Method
Geometric_PMF Method
Geometric_PPF Method
Geometric_QDF Method
Geometric_Skewness Method
Geometric_Variance Method
GeometricShifted_CDF Method
GeometricShifted_Kurtosis Method
GeometricShifted_Mean Method
GeometricShifted_P_MLE Method
GeometricShifted_PMF Method
GeometricShifted_PPF Method
GeometricShifted_QDF Method
GeometricShifted_Skewness Method
GeometricShifted_Variance Method
Poisson_CDF Method
Poisson_Kurtosis Method
Poisson_Mean Method
Poisson_ModeMax Method
Poisson_ModeMin Method
Poisson_PMF Method
Poisson_PPF Method
Poisson_QDF Method
Poisson_Skewness Method
Poisson_Variance Method
StdLogistic_CDF Method
StdLogistic_PDF Method
StdLogistic_PPF Method
StdLogistic_QDF Method
TruncatedPoisson_CDF Method
TruncatedPoisson_PMF Method
TruncatedPoisson_PPF Method
TruncatedPoisson_QDF Method
UniformC_CDF Method
UniformC_Kurtosis Method
UniformC_Mean Method
UniformC_PDF Method
UniformC_PPF Method
UniformC_Variance Method
UniformD_CDF Method
UniformD_Kurtosis Method
UniformD_Mean Method
UniformD_PMF Method
UniformD_PPF Method
UniformD_QDF Method
UniformD_Variance Method
Click or drag to resize
sqx

ProbabilityPoisson_CDF Method

Function [float] Poisson_CDF([int] k, [float] Lambda)
(Discrete Probability)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static SqlDouble Poisson_CDF(
	SqlInt32 k,
	SqlDouble Lambda
)

Parameters

k
Type: System.Data.SqlTypesSqlInt32
[int]
Lambda
Type: System.Data.SqlTypesSqlDouble
[float]

Return Value

Type: SqlDouble
[float]
Remarks
Poisson cumulative distribution function.
Support: [0,+∞)
Examples
SQL
Copy
declare @Lambda float = 188.6
select Value
, sqx.Poisson_PMF(Value, @Lambda) PMF
, sqx.Poisson_CDF(Value, @Lambda) CDF
, sqx.Poisson_QDF(Value, @Lambda) QDF
, sqx.Poisson_PPF(sqx.Poisson_CDF(Value, @Lambda), @Lambda) PPF
from sqx.NTable(0,310)
See Also