Skip to content

Kolmogorov-Smirnov functions in the Stochastic DuckDB extension

Function category

Kolmogorov-Smirnov

23 functions

dist_kolmogorov_smirnov_cdf

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_cdf(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_cdf(10.0, 0.3);

Output

dist_kolmogorov_smirnov_cdf(10.0, 0.3)
0.6708952109021851

dist_kolmogorov_smirnov_cdf_complement

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_cdf_complement(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Asymptotic p-value for D = 0.3 with 10 observations
SELECT round(dist_kolmogorov_smirnov_cdf_complement(10.0, 0.3), 6) AS p_value;

Output

p_value
0.329105

dist_kolmogorov_smirnov_chf

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_chf(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_chf(10.0, 0.3);

Output

dist_kolmogorov_smirnov_chf(10.0, 0.3)
1.1113790710335432

dist_kolmogorov_smirnov_hazard

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_hazard(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_hazard(10.0, 0.3);

Output

dist_kolmogorov_smirnov_hazard(10.0, 0.3)
11.836719215333597

dist_kolmogorov_smirnov_ks_test

Aggregate function Hypothesis Tests Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_ks_test(x: DOUBLE, sample_size: DOUBLE) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Test a sample against a kolmogorov smirnov distribution
SELECT dist_kolmogorov_smirnov_ks_test(x, 10.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.9184811135877904, 'p_value': 9.409095277317957e-08}

dist_kolmogorov_smirnov_kurtosis

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_kurtosis(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_kurtosis(10.0);

Output

dist_kolmogorov_smirnov_kurtosis(10.0)
3.8816189679105526

dist_kolmogorov_smirnov_kurtosis_excess

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_kurtosis_excess(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_kurtosis_excess(10.0);

Output

dist_kolmogorov_smirnov_kurtosis_excess(10.0)
0.8816189679105526

dist_kolmogorov_smirnov_log_cdf

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_log_cdf(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_log_cdf(10.0, 0.3);

Output

dist_kolmogorov_smirnov_log_cdf(10.0, 0.3)
-0.39914232275717315

dist_kolmogorov_smirnov_log_cdf_complement

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_log_cdf_complement(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_log_cdf_complement(10.0, 0.3);

Output

dist_kolmogorov_smirnov_log_cdf_complement(10.0, 0.3)
-1.1113790710335432

dist_kolmogorov_smirnov_log_pdf

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_log_pdf(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_log_pdf(10.0, 0.3);

Output

dist_kolmogorov_smirnov_log_pdf(10.0, 0.3)
1.3598274267253476

dist_kolmogorov_smirnov_mean

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_mean(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_mean(10.0);

Output

dist_kolmogorov_smirnov_mean(10.0)
0.27471691419718736

dist_kolmogorov_smirnov_median

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_median(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_median(10.0);

Output

dist_kolmogorov_smirnov_median(10.0)
0.2617017365723168

dist_kolmogorov_smirnov_mode

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_mode(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_mode(10.0);

Output

dist_kolmogorov_smirnov_mode(10.0)
0.23257537378566176

dist_kolmogorov_smirnov_pdf

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_pdf(sample_size: DOUBLE, x: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_pdf(10.0, 0.3);

Output

dist_kolmogorov_smirnov_pdf(10.0, 0.3)
3.8955209809724165

dist_kolmogorov_smirnov_quantile

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_quantile(sample_size: DOUBLE, p: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_quantile(10.0, 0.95);

Output

dist_kolmogorov_smirnov_quantile(10.0, 0.95)
0.4294684987434775

dist_kolmogorov_smirnov_quantile_complement

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_quantile_complement(sample_size: DOUBLE, p: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_quantile_complement(10.0, 0.95);

Output

dist_kolmogorov_smirnov_quantile_complement(10.0, 0.95)
0.16431522940365562

dist_kolmogorov_smirnov_range

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_range(sample_size: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_range(10.0);

Output

dist_kolmogorov_smirnov_range(10.0)
[0.0, inf]

dist_kolmogorov_smirnov_sample

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_sample(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_sample(10.0);

Output

dist_kolmogorov_smirnov_sample(10.0)
0.22466382330476758

dist_kolmogorov_smirnov_samples

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_samples(sample_size: DOUBLE, n: BIGINT) → DOUBLE[]
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_samples(10.0, 5);

Output

dist_kolmogorov_smirnov_samples(10.0, 5)
[0.15764652246379984, 0.26399605587854785, 0.32562247285590434, 0.39898758277240526, 0.311093631259076]

dist_kolmogorov_smirnov_skewness

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_skewness(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_skewness(10.0);

Output

dist_kolmogorov_smirnov_skewness(10.0)
0.8604261371436726

dist_kolmogorov_smirnov_stddev

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_stddev(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_stddev(10.0);

Output

dist_kolmogorov_smirnov_stddev(10.0)
0.08232448236330737

dist_kolmogorov_smirnov_support

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_support(sample_size: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_support(10.0);

Output

dist_kolmogorov_smirnov_support(10.0)
[0.0, inf]

dist_kolmogorov_smirnov_variance

Scalar function Kolmogorov-Smirnov
Signature
dist_kolmogorov_smirnov_variance(sample_size: DOUBLE) → DOUBLE
Arguments (Positional)
Argument sample_size Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_kolmogorov_smirnov_variance(10.0);

Output

dist_kolmogorov_smirnov_variance(10.0)
0.006777320396386508