Non-central t functions in the Stochastic DuckDB extension
Function category
Non-central t
23 functionsNon-central Student's t — t statistic under a shifted mean. Power and sample-size calculations for t-tests.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative distribution function (CDF) of the non-central Student's t distribution, P(X <= x).
SELECT dist_non_central_t_cdf(10.0, 1.0, 1.5);
Output
| dist_non_central_t_cdf(10.0, 1.0, 1.5) |
|---|
| 0.6695168482153548 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary cumulative distribution function (survival function) of the non-central Student's t distribution, P(X > x).
SELECT round(dist_non_central_t_cdf_complement(20.0, 2.5, dist_students_t_quantile(20.0, 0.95)), 4) AS power;
Output
| power |
|---|
| 0.7791 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative hazard function of the non-central Student's t distribution at x.
SELECT dist_non_central_t_chf(10.0, 1.0, 1.5);
Output
| dist_non_central_t_chf(10.0, 1.0, 1.5) |
|---|
| 1.1071995989485302 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the hazard function of the non-central Student's t distribution at x.
SELECT dist_non_central_t_hazard(10.0, 1.0, 1.5);
Output
| dist_non_central_t_hazard(10.0, 1.0, 1.5) |
|---|
| 0.9826333533821514 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
One-sample Kolmogorov-Smirnov test of whether x follows the non-central Student's t distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
SELECT dist_non_central_t_ks_test(x, 10.0, 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.27688821529635366, 'p_value': 0.42729006642351897} |
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_kurtosis(10.0, 1.0);
Output
| dist_non_central_t_kurtosis(10.0, 1.0) |
|---|
| 4.249941318141372 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_kurtosis_excess(10.0, 1.0);
Output
| dist_non_central_t_kurtosis_excess(10.0, 1.0) |
|---|
| 1.2499413181413717 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
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 non-central Student's t distribution.
SELECT dist_non_central_t_log_cdf(10.0, 1.0, 1.5);
Output
| dist_non_central_t_log_cdf(10.0, 1.0, 1.5) |
|---|
| -0.4011989487973436 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the survival function of the non-central Student's t distribution, log P(X > x).
SELECT dist_non_central_t_log_cdf_complement(10.0, 1.0, 1.5);
Output
| dist_non_central_t_log_cdf_complement(10.0, 1.0, 1.5) |
|---|
| -1.1071995989485302 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
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 non-central Student's t distribution at x. Useful for numerical stability when dealing with very small probabilities.
SELECT dist_non_central_t_log_pdf(10.0, 1.0, 1.5);
Output
| dist_non_central_t_log_pdf(10.0, 1.0, 1.5) |
|---|
| -1.1247188147643155 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_mean(10.0, 1.0);
Output
| dist_non_central_t_mean(10.0, 1.0) |
|---|
| 1.0837223079391436 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_median(10.0, 1.0);
Output
| dist_non_central_t_median(10.0, 1.0) |
|---|
| 1.0257209228280026 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_mode(10.0, 1.0);
Output
| dist_non_central_t_mode(10.0, 1.0) |
|---|
| 0.932910364582629 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the probability density function (PDF) of the non-central Student's t distribution at x.
SELECT dist_non_central_t_pdf(10.0, 1.0, 1.5);
Output
| dist_non_central_t_pdf(10.0, 1.0, 1.5) |
|---|
| 0.32474376767444835 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the quantile function (inverse CDF) of the non-central Student's t distribution. Returns the smallest x such that P(X <= x) >= p.
SELECT dist_non_central_t_quantile(10.0, 1.0, 0.95);
Output
| dist_non_central_t_quantile(10.0, 1.0, 0.95) |
|---|
| 3.041741814969764 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary quantile function of the non-central Student's t distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
SELECT dist_non_central_t_quantile_complement(10.0, 1.0, 0.95);
Output
| dist_non_central_t_quantile_complement(10.0, 1.0, 0.95) |
|---|
| -0.679790188182627 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the non-central Student's t distribution as [min, max].
SELECT dist_non_central_t_range(10.0, 1.0);
Output
| dist_non_central_t_range(10.0, 1.0) |
|---|
| [-inf, inf] |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the non-central Student's t distribution with the specified parameters.
SELECT dist_non_central_t_sample(10.0, 1.0);
Output
| dist_non_central_t_sample(10.0, 1.0) |
|---|
| 0.4732519667112593 |
Related functions
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
n
|
Type
BIGINT
|
Mode Positional | Description |
Description
Generates a list of n random samples from the non-central Student's t distribution with the specified parameters.
SELECT dist_non_central_t_samples(10.0, 1.0, 5);
Output
| dist_non_central_t_samples(10.0, 1.0, 5) |
|---|
| [-0.7195017947251241, 2.2701647642103597, 2.2283614126465077, 1.3524459348010482, -0.29590941855257846] |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_skewness(10.0, 1.0);
Output
| dist_non_central_t_skewness(10.0, 1.0) |
|---|
| 0.3999297299058122 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_stddev(10.0, 1.0);
Output
| dist_non_central_t_stddev(10.0, 1.0) |
|---|
| 1.1513235684528724 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the non-central Student's t distribution as [min, max].
SELECT dist_non_central_t_support(10.0, 1.0);
Output
| dist_non_central_t_support(10.0, 1.0) |
|---|
| [-inf, inf] |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the non-central Student's t distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_non_central_t_variance(10.0, 1.0);
Output
| dist_non_central_t_variance(10.0, 1.0) |
|---|
| 1.325545959275056 |
Related functions
- dist_non_central_t_sample() — Generates a random sample from the non-central Student's t distribution with the specified parameters
- dist_non_central_t_pdf() — Computes the probability density function (PDF) of the non-central Student's t distribution at x
- dist_non_central_t_quantile() — Computes the quantile function (inverse CDF) of the non-central Student's t distribution
- dist_non_central_t_mean() — Returns the mean of the non-central Student's t distribution
- dist_non_central_t_stddev() — Returns the standard deviation of the non-central Student's t distribution