Skip to content

Triangular functions in the Stochastic DuckDB extension

Function category

Triangular

23 functions

dist_triangular_cdf

Scalar function Triangular
Signature
dist_triangular_cdf( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_cdf(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_cdf(0.0, 0.5, 1.0, 0.25)
0.125

dist_triangular_cdf_complement

Scalar function Triangular
Signature
dist_triangular_cdf_complement( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_cdf_complement(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_cdf_complement(0.0, 0.5, 1.0, 0.25)
0.875

dist_triangular_chf

Scalar function Triangular
Signature
dist_triangular_chf( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_chf(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_chf(0.0, 0.5, 1.0, 0.25)
0.13353139262452263

dist_triangular_hazard

Scalar function Triangular
Signature
dist_triangular_hazard( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_hazard(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_hazard(0.0, 0.5, 1.0, 0.25)
1.1428571428571428

dist_triangular_ks_test

Aggregate function Hypothesis Tests Triangular
Signature
dist_triangular_ks_test( x: DOUBLE, lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Test a sample against a triangular distribution
SELECT dist_triangular_ks_test(x, 0.0, 0.5, 1.0) AS ks
FROM (VALUES (1.2), (0.7), (2.9), (1.8), (0.4), (3.6), (1.1), (2.2), (5.3), (0.9)) t(x);

Output

ks
{'statistic': 0.78, 'p_value': 1.0388066948005695e-05}

dist_triangular_kurtosis

Scalar function Triangular
Signature
dist_triangular_kurtosis( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_kurtosis(0.0, 0.5, 1.0);

Output

dist_triangular_kurtosis(0.0, 0.5, 1.0)
2.4

dist_triangular_kurtosis_excess

Scalar function Triangular
Signature
dist_triangular_kurtosis_excess( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_kurtosis_excess(0.0, 0.5, 1.0);

Output

dist_triangular_kurtosis_excess(0.0, 0.5, 1.0)
-0.6

dist_triangular_log_cdf

Scalar function Triangular
Signature
dist_triangular_log_cdf( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_log_cdf(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_log_cdf(0.0, 0.5, 1.0, 0.25)
-2.0794415416798357

dist_triangular_log_cdf_complement

Scalar function Triangular
Signature
dist_triangular_log_cdf_complement( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_log_cdf_complement(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_log_cdf_complement(0.0, 0.5, 1.0, 0.25)
-0.13353139262452263

dist_triangular_log_pdf

Scalar function Triangular
Signature
dist_triangular_log_pdf( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_log_pdf(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_log_pdf(0.0, 0.5, 1.0, 0.25)
0.0

dist_triangular_mean

Scalar function Triangular
Signature
dist_triangular_mean( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_mean(0.0, 0.5, 1.0);

Output

dist_triangular_mean(0.0, 0.5, 1.0)
0.5

dist_triangular_median

Scalar function Triangular
Signature
dist_triangular_median( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_median(0.0, 0.5, 1.0);

Output

dist_triangular_median(0.0, 0.5, 1.0)
0.5

dist_triangular_mode

Scalar function Triangular
Signature
dist_triangular_mode( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_mode(0.0, 0.5, 1.0);

Output

dist_triangular_mode(0.0, 0.5, 1.0)
0.5

dist_triangular_pdf

Scalar function Triangular
Signature
dist_triangular_pdf( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_pdf(0.0, 0.5, 1.0, 0.25);

Output

dist_triangular_pdf(0.0, 0.5, 1.0, 0.25)
1.0

dist_triangular_quantile

Scalar function Triangular
Signature
dist_triangular_quantile( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Median of a PERT-style estimate: minimum 2, most likely 3, maximum 7 days
SELECT round(dist_triangular_quantile(2.0, 3.0, 7.0, 0.5), 4) AS median_days;

Output

median_days
3.8377

dist_triangular_quantile_complement

Scalar function Triangular
Signature
dist_triangular_quantile_complement( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_quantile_complement(0.0, 0.5, 1.0, 0.95);

Output

dist_triangular_quantile_complement(0.0, 0.5, 1.0, 0.95)
0.15811388300841903

dist_triangular_range

Scalar function Triangular
Signature
dist_triangular_range( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_range(0.0, 0.5, 1.0);

Output

dist_triangular_range(0.0, 0.5, 1.0)
[-inf, inf]

dist_triangular_sample

Scalar function Triangular
Signature
dist_triangular_sample( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_sample(0.0, 0.5, 1.0);

Output

dist_triangular_sample(0.0, 0.5, 1.0)
0.27740823005395016

dist_triangular_samples

Scalar function Triangular
Signature
dist_triangular_samples( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_samples(0.0, 0.5, 1.0, 5);

Output

dist_triangular_samples(0.0, 0.5, 1.0, 5)
[0.33890389769605667, 0.5094722624361524, 0.4987536254128971, 0.4689277423200763, 0.5005507275035932]

dist_triangular_skewness

Scalar function Triangular
Signature
dist_triangular_skewness( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_skewness(0.0, 0.5, 1.0);

Output

dist_triangular_skewness(0.0, 0.5, 1.0)
0.0

dist_triangular_stddev

Scalar function Triangular
Signature
dist_triangular_stddev( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_stddev(0.0, 0.5, 1.0);

Output

dist_triangular_stddev(0.0, 0.5, 1.0)
0.2041241452319315

dist_triangular_support

Scalar function Triangular
Signature
dist_triangular_support( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_support(0.0, 0.5, 1.0);

Output

dist_triangular_support(0.0, 0.5, 1.0)
[0.0, 1.0]

dist_triangular_variance

Scalar function Triangular
Signature
dist_triangular_variance( lower: DOUBLE, mode: DOUBLE, upper: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument lower Type DOUBLE Mode Positional Description
Argument mode Type DOUBLE Mode Positional Description
Argument upper Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_triangular_variance(0.0, 0.5, 1.0);

Output

dist_triangular_variance(0.0, 0.5, 1.0)
0.041666666666666664