Skip to content

Arcsine functions in the Stochastic DuckDB extension

Function category

Arcsine

23 functions

dist_arcsine_cdf

Scalar function Arcsine
Signature
dist_arcsine_cdf( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 CDF of the standard arcsine distribution
SELECT dist_arcsine_cdf(0.0, 1.0, 0.25) AS cdf;

Output

cdf
0.3333333333333333

dist_arcsine_cdf_complement

Scalar function Arcsine
Signature
dist_arcsine_cdf_complement( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_cdf_complement(0.0, 1.0, 0.25);

Output

dist_arcsine_cdf_complement(0.0, 1.0, 0.25)
0.6666666666666666

dist_arcsine_chf

Scalar function Arcsine
Signature
dist_arcsine_chf( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_chf(0.0, 1.0, 0.25);

Output

dist_arcsine_chf(0.0, 1.0, 0.25)
0.40546510810816444

dist_arcsine_hazard

Scalar function Arcsine
Signature
dist_arcsine_hazard( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_hazard(0.0, 1.0, 0.25);

Output

dist_arcsine_hazard(0.0, 1.0, 0.25)
1.1026577908435844

dist_arcsine_ks_test

Aggregate function Hypothesis Tests Arcsine
Signature
dist_arcsine_ks_test( x: DOUBLE, min: DOUBLE, max: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Test a sample against a arcsine distribution
SELECT dist_arcsine_ks_test(x, 0.0, 1.0) AS ks
FROM (VALUES (0.12), (0.34), (0.27), (0.51), (0.18), (0.42), (0.09), (0.63), (0.31), (0.22)) t(x);

Output

ks
{'statistic': 0.41627743252839533, 'p_value': 0.06249796055213297}

dist_arcsine_kurtosis

Scalar function Arcsine
Signature
dist_arcsine_kurtosis(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_kurtosis(0.0, 1.0);

Output

dist_arcsine_kurtosis(0.0, 1.0)
1.5

dist_arcsine_kurtosis_excess

Scalar function Arcsine
Signature
dist_arcsine_kurtosis_excess(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_kurtosis_excess(0.0, 1.0);

Output

dist_arcsine_kurtosis_excess(0.0, 1.0)
-1.5

dist_arcsine_log_cdf

Scalar function Arcsine
Signature
dist_arcsine_log_cdf( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_log_cdf(0.0, 1.0, 0.25);

Output

dist_arcsine_log_cdf(0.0, 1.0, 0.25)
-1.0986122886681098

dist_arcsine_log_cdf_complement

Scalar function Arcsine
Signature
dist_arcsine_log_cdf_complement( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_log_cdf_complement(0.0, 1.0, 0.25);

Output

dist_arcsine_log_cdf_complement(0.0, 1.0, 0.25)
-0.40546510810816444

dist_arcsine_log_pdf

Scalar function Arcsine
Signature
dist_arcsine_log_pdf( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_log_pdf(0.0, 1.0, 0.25);

Output

dist_arcsine_log_pdf(0.0, 1.0, 0.25)
-0.30774166906356426

dist_arcsine_mean

Scalar function Arcsine
Signature
dist_arcsine_mean(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_mean(0.0, 1.0);

Output

dist_arcsine_mean(0.0, 1.0)
0.5

dist_arcsine_median

Scalar function Arcsine
Signature
dist_arcsine_median(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_median(0.0, 1.0);

Output

dist_arcsine_median(0.0, 1.0)
0.5

dist_arcsine_mode

Scalar function Arcsine
Signature
dist_arcsine_mode(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_mode(0.0, 1.0);

Output

dist_arcsine_mode(0.0, 1.0)
NULL

dist_arcsine_pdf

Scalar function Arcsine
Signature
dist_arcsine_pdf( min: DOUBLE, max: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_pdf(0.0, 1.0, 0.25);

Output

dist_arcsine_pdf(0.0, 1.0, 0.25)
0.7351051938957228

dist_arcsine_quantile

Scalar function Arcsine
Signature
dist_arcsine_quantile( min: DOUBLE, max: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_quantile(0.0, 1.0, 0.95);

Output

dist_arcsine_quantile(0.0, 1.0, 0.95)
0.9938441702975689

dist_arcsine_quantile_complement

Scalar function Arcsine
Signature
dist_arcsine_quantile_complement( min: DOUBLE, max: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_quantile_complement(0.0, 1.0, 0.95);

Output

dist_arcsine_quantile_complement(0.0, 1.0, 0.95)
0.006155829702431145

dist_arcsine_range

Scalar function Arcsine
Signature
dist_arcsine_range(min: DOUBLE, max: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_range(0.0, 1.0);

Output

dist_arcsine_range(0.0, 1.0)
[0.0, 1.0]

dist_arcsine_sample

Scalar function Arcsine
Signature
dist_arcsine_sample(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_sample(0.0, 1.0);

Output

dist_arcsine_sample(0.0, 1.0)
0.9377133000799597

dist_arcsine_samples

Scalar function Arcsine
Signature
dist_arcsine_samples( min: DOUBLE, max: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_samples(0.0, 1.0, 5);

Output

dist_arcsine_samples(0.0, 1.0, 5)
[0.9887307950638774, 0.26437271006214874, 0.006988404211557709, 0.10864946874537328, 0.805189851761353]

dist_arcsine_skewness

Scalar function Arcsine
Signature
dist_arcsine_skewness(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_skewness(0.0, 1.0);

Output

dist_arcsine_skewness(0.0, 1.0)
0.0

dist_arcsine_stddev

Scalar function Arcsine
Signature
dist_arcsine_stddev(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_stddev(0.0, 1.0);

Output

dist_arcsine_stddev(0.0, 1.0)
0.3535533905932738

dist_arcsine_support

Scalar function Arcsine
Signature
dist_arcsine_support(min: DOUBLE, max: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_support(0.0, 1.0);

Output

dist_arcsine_support(0.0, 1.0)
[0.0, 1.0]

dist_arcsine_variance

Scalar function Arcsine
Signature
dist_arcsine_variance(min: DOUBLE, max: DOUBLE) → DOUBLE
Arguments (Positional)
Argument min Type DOUBLE Mode Positional Description
Argument max Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_arcsine_variance(0.0, 1.0);

Output

dist_arcsine_variance(0.0, 1.0)
0.125