Skip to content

Skew Normal functions in the Stochastic DuckDB extension

Function category

Skew Normal

23 functions

dist_skew_normal_cdf

Scalar function Skew Normal
Signature
dist_skew_normal_cdf( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 CDF of a right-skewed normal
SELECT round(dist_skew_normal_cdf(0.0, 1.0, 4.0, 0.5), 6) AS cdf;

Output

cdf
0.38435

dist_skew_normal_cdf_complement

Scalar function Skew Normal
Signature
dist_skew_normal_cdf_complement( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_cdf_complement(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_cdf_complement(0.0, 1.0, 4.0, 0.5)
0.6156503214118628

dist_skew_normal_chf

Scalar function Skew Normal
Signature
dist_skew_normal_chf( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_chf(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_chf(0.0, 1.0, 4.0, 0.5)
0.4850761366742581

dist_skew_normal_hazard

Scalar function Skew Normal
Signature
dist_skew_normal_hazard( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_hazard(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_hazard(0.0, 1.0, 4.0, 0.5)
1.1176987395605162

dist_skew_normal_ks_test

Aggregate function Hypothesis Tests Skew Normal
Signature
dist_skew_normal_ks_test( x: DOUBLE, location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Test a sample against a skew normal distribution
SELECT dist_skew_normal_ks_test(x, 0.0, 1.0, 4.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.4318846771995842, 'p_value': 0.047961623466389075}

dist_skew_normal_kurtosis

Scalar function Skew Normal
Signature
dist_skew_normal_kurtosis( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_kurtosis(0.0, 1.0, 4.0);

Output

dist_skew_normal_kurtosis(0.0, 1.0, 4.0)
3.63278475482118

dist_skew_normal_kurtosis_excess

Scalar function Skew Normal
Signature
dist_skew_normal_kurtosis_excess( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_kurtosis_excess(0.0, 1.0, 4.0);

Output

dist_skew_normal_kurtosis_excess(0.0, 1.0, 4.0)
0.6327847548211799

dist_skew_normal_log_cdf

Scalar function Skew Normal
Signature
dist_skew_normal_log_cdf( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_log_cdf(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_log_cdf(0.0, 1.0, 4.0, 0.5)
-0.9562025194352001

dist_skew_normal_log_cdf_complement

Scalar function Skew Normal
Signature
dist_skew_normal_log_cdf_complement( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_log_cdf_complement(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_log_cdf_complement(0.0, 1.0, 4.0, 0.5)
-0.4850761366742581

dist_skew_normal_log_pdf

Scalar function Skew Normal
Signature
dist_skew_normal_log_pdf( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_log_pdf(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_log_pdf(0.0, 1.0, 4.0, 0.5)
-0.3738042619736908

dist_skew_normal_mean

Scalar function Skew Normal
Signature
dist_skew_normal_mean( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_mean(0.0, 1.0, 4.0);

Output

dist_skew_normal_mean(0.0, 1.0, 4.0)
0.774061722644652

dist_skew_normal_median

Scalar function Skew Normal
Signature
dist_skew_normal_median( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_median(0.0, 1.0, 4.0);

Output

dist_skew_normal_median(0.0, 1.0, 4.0)
0.6742354765650023

dist_skew_normal_mode

Scalar function Skew Normal
Signature
dist_skew_normal_mode( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_mode(0.0, 1.0, 4.0);

Output

dist_skew_normal_mode(0.0, 1.0, 4.0)
0.4169729949738887

dist_skew_normal_pdf

Scalar function Skew Normal
Signature
dist_skew_normal_pdf( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_pdf(0.0, 1.0, 4.0, 0.5);

Output

dist_skew_normal_pdf(0.0, 1.0, 4.0, 0.5)
0.6881115882520658

dist_skew_normal_quantile

Scalar function Skew Normal
Signature
dist_skew_normal_quantile( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_quantile(0.0, 1.0, 4.0, 0.95);

Output

dist_skew_normal_quantile(0.0, 1.0, 4.0, 0.95)
1.9599639845400536

dist_skew_normal_quantile_complement

Scalar function Skew Normal
Signature
dist_skew_normal_quantile_complement( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_quantile_complement(0.0, 1.0, 4.0, 0.95);

Output

dist_skew_normal_quantile_complement(0.0, 1.0, 4.0, 0.95)
-0.08044114414902861

dist_skew_normal_range

Scalar function Skew Normal
Signature
dist_skew_normal_range( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_range(0.0, 1.0, 4.0);

Output

dist_skew_normal_range(0.0, 1.0, 4.0)
[-inf, inf]

dist_skew_normal_sample

Scalar function Skew Normal
Signature
dist_skew_normal_sample( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_sample(0.0, 1.0, 4.0);

Output

dist_skew_normal_sample(0.0, 1.0, 4.0)
0.5325138208924837

dist_skew_normal_samples

Scalar function Skew Normal
Signature
dist_skew_normal_samples( location: DOUBLE, scale: DOUBLE, shape: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_samples(0.0, 1.0, 4.0, 5);

Output

dist_skew_normal_samples(0.0, 1.0, 4.0, 5)
[1.0629935498493754, 1.7824770689549554, 0.9947780698541152, 0.5646496904620448, -0.17703381047561761]

dist_skew_normal_skewness

Scalar function Skew Normal
Signature
dist_skew_normal_skewness( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_skewness(0.0, 1.0, 4.0);

Output

dist_skew_normal_skewness(0.0, 1.0, 4.0)
0.7844267553823127

dist_skew_normal_stddev

Scalar function Skew Normal
Signature
dist_skew_normal_stddev( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_stddev(0.0, 1.0, 4.0);

Output

dist_skew_normal_stddev(0.0, 1.0, 4.0)
0.6331101401307627

dist_skew_normal_support

Scalar function Skew Normal
Signature
dist_skew_normal_support( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_support(0.0, 1.0, 4.0);

Output

dist_skew_normal_support(0.0, 1.0, 4.0)
[-inf, inf]

dist_skew_normal_variance

Scalar function Skew Normal
Signature
dist_skew_normal_variance( location: DOUBLE, scale: DOUBLE, shape: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument location Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_skew_normal_variance(0.0, 1.0, 4.0);

Output

dist_skew_normal_variance(0.0, 1.0, 4.0)
0.400828449536394