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

ProbabilityGeometric_CDF Method

Function [float] Geometric_CDF([int] k, [float] P)
(Discrete Probability)

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

Parameters

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

Return Value

Type: SqlDouble
[float]
Remarks
Geometric cumulative distribution function.
Support: [0,+∞)
Examples
SQL
Copy
declare @P float = 0.6
select Value
, sqx.Geometric_PMF(Value, @P) PMF
, sqx.Geometric_CDF(Value, @P) CDF
, sqx.Geometric_QDF(Value, @P) QDF
, sqx.Geometric_PPF(sqx.Geometric_CDF(Value, @P), @P) PPF
from sqx.NTable(0,40)
See Also