Arcsine functions in the Stochastic DuckDB extension
Function category
Arcsine
23 functionsArcsine distribution on [min, max] — U-shaped density with most mass near the ends. Random walks and the time a walk spends positive.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative distribution function (CDF) of the arcsine distribution, P(X <= x).
SELECT dist_arcsine_cdf(0.0, 1.0, 0.25) AS cdf;
Output
| cdf |
|---|
| 0.3333333333333333 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary cumulative distribution function (survival function) of the arcsine distribution, P(X > x).
SELECT dist_arcsine_cdf_complement(0.0, 1.0, 0.25);
Output
| dist_arcsine_cdf_complement(0.0, 1.0, 0.25) |
|---|
| 0.6666666666666666 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative hazard function of the arcsine distribution at x.
SELECT dist_arcsine_chf(0.0, 1.0, 0.25);
Output
| dist_arcsine_chf(0.0, 1.0, 0.25) |
|---|
| 0.40546510810816444 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the hazard function of the arcsine distribution at x.
SELECT dist_arcsine_hazard(0.0, 1.0, 0.25);
Output
| dist_arcsine_hazard(0.0, 1.0, 0.25) |
|---|
| 1.1026577908435844 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
One-sample Kolmogorov-Smirnov test of whether x follows the arcsine distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
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} |
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_kurtosis(0.0, 1.0);
Output
| dist_arcsine_kurtosis(0.0, 1.0) |
|---|
| 1.5 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_kurtosis_excess(0.0, 1.0);
Output
| dist_arcsine_kurtosis_excess(0.0, 1.0) |
|---|
| -1.5 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the cumulative distribution function (CDF) of the arcsine distribution.
SELECT dist_arcsine_log_cdf(0.0, 1.0, 0.25);
Output
| dist_arcsine_log_cdf(0.0, 1.0, 0.25) |
|---|
| -1.0986122886681098 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the survival function of the arcsine distribution, log P(X > x).
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 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the probability density function (PDF) of the arcsine distribution at x. Useful for numerical stability when dealing with very small probabilities.
SELECT dist_arcsine_log_pdf(0.0, 1.0, 0.25);
Output
| dist_arcsine_log_pdf(0.0, 1.0, 0.25) |
|---|
| -0.30774166906356426 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_mean(0.0, 1.0);
Output
| dist_arcsine_mean(0.0, 1.0) |
|---|
| 0.5 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_median(0.0, 1.0);
Output
| dist_arcsine_median(0.0, 1.0) |
|---|
| 0.5 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_mode(0.0, 1.0);
Output
| dist_arcsine_mode(0.0, 1.0) |
|---|
| NULL |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the probability density function (PDF) of the arcsine distribution at x.
SELECT dist_arcsine_pdf(0.0, 1.0, 0.25);
Output
| dist_arcsine_pdf(0.0, 1.0, 0.25) |
|---|
| 0.7351051938957228 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the quantile function (inverse CDF) of the arcsine distribution. Returns the smallest x such that P(X <= x) >= p.
SELECT dist_arcsine_quantile(0.0, 1.0, 0.95);
Output
| dist_arcsine_quantile(0.0, 1.0, 0.95) |
|---|
| 0.9938441702975689 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary quantile function of the arcsine distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
SELECT dist_arcsine_quantile_complement(0.0, 1.0, 0.95);
Output
| dist_arcsine_quantile_complement(0.0, 1.0, 0.95) |
|---|
| 0.006155829702431145 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the arcsine distribution as [min, max].
SELECT dist_arcsine_range(0.0, 1.0);
Output
| dist_arcsine_range(0.0, 1.0) |
|---|
| [0.0, 1.0] |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the arcsine distribution with the specified parameters.
SELECT dist_arcsine_sample(0.0, 1.0);
Output
| dist_arcsine_sample(0.0, 1.0) |
|---|
| 0.9377133000799597 |
Related functions
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
n
|
Type
BIGINT
|
Mode Positional | Description |
Description
Generates a list of n random samples from the arcsine distribution with the specified parameters.
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] |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_skewness(0.0, 1.0);
Output
| dist_arcsine_skewness(0.0, 1.0) |
|---|
| 0.0 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_stddev(0.0, 1.0);
Output
| dist_arcsine_stddev(0.0, 1.0) |
|---|
| 0.3535533905932738 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the arcsine distribution as [min, max].
SELECT dist_arcsine_support(0.0, 1.0);
Output
| dist_arcsine_support(0.0, 1.0) |
|---|
| [0.0, 1.0] |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
min
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
max
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the arcsine distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_arcsine_variance(0.0, 1.0);
Output
| dist_arcsine_variance(0.0, 1.0) |
|---|
| 0.125 |
Related functions
- dist_arcsine_sample() — Generates a random sample from the arcsine distribution with the specified parameters
- dist_arcsine_pdf() — Computes the probability density function (PDF) of the arcsine distribution at x
- dist_arcsine_quantile() — Computes the quantile function (inverse CDF) of the arcsine distribution
- dist_arcsine_mean() — Returns the mean of the arcsine distribution
- dist_arcsine_stddev() — Returns the standard deviation of the arcsine distribution