BIVAR

Updated 2023-11-02 20:47:41.757000

Syntax

SELECT [westclintech].[wct].[BIVAR](
  <@z1, float,>
 ,<@z2, float,>
 ,<@rho, float,>)

Description

Use the scalar function BIVAR to calculate bivariate normal probabilities. BIVAR calculates the probability that x < z1 and x < z2.

Arguments

@z1

the first upper integration limit. @z1 is an expression of type float or of a type that can be implicitly converted to float.

@z2

the second upper integration limit. @z2 is an expression of type float or of a type that can be implicitly converted to float.

@rho

the correlation coefficient. @rho is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Examples

SELECT wct.BIVAR(6.1572, 5.9186, -0.16) as BIVAR;

This produces the following result.

{"columns":[{"field":"BIVAR","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"BIVAR":"0.999999998006321"}]}