Skip to content

Non-central t functions in the Stochastic DuckDB extension

Function category

Non-central t

23 functions

dist_non_central_t_cdf

Scalar function Non-central t
Signature
dist_non_central_t_cdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_cdf_complement

Scalar function Non-central t
Signature
dist_non_central_t_cdf_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Power of a one-sided t-test with effect size 2.5 and df 20
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

dist_non_central_t_chf

Scalar function Non-central t
Signature
dist_non_central_t_chf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_hazard

Scalar function Non-central t
Signature
dist_non_central_t_hazard( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_ks_test

Aggregate function Hypothesis Tests Non-central t
Signature
dist_non_central_t_ks_test( x: DOUBLE, degrees_of_freedom: DOUBLE, noncentrality: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Test a sample against a non central t distribution
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}

dist_non_central_t_kurtosis

Scalar function Non-central t
Signature
dist_non_central_t_kurtosis(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_kurtosis(10.0, 1.0);

Output

dist_non_central_t_kurtosis(10.0, 1.0)
4.249941318141372

dist_non_central_t_kurtosis_excess

Scalar function Non-central t
Signature
dist_non_central_t_kurtosis_excess(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_kurtosis_excess(10.0, 1.0);

Output

dist_non_central_t_kurtosis_excess(10.0, 1.0)
1.2499413181413717

dist_non_central_t_log_cdf

Scalar function Non-central t
Signature
dist_non_central_t_log_cdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_log_cdf_complement

Scalar function Non-central t
Signature
dist_non_central_t_log_cdf_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_log_pdf

Scalar function Non-central t
Signature
dist_non_central_t_log_pdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_mean

Scalar function Non-central t
Signature
dist_non_central_t_mean(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_mean(10.0, 1.0);

Output

dist_non_central_t_mean(10.0, 1.0)
1.0837223079391436

dist_non_central_t_median

Scalar function Non-central t
Signature
dist_non_central_t_median(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_median(10.0, 1.0);

Output

dist_non_central_t_median(10.0, 1.0)
1.0257209228280026

dist_non_central_t_mode

Scalar function Non-central t
Signature
dist_non_central_t_mode(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_mode(10.0, 1.0);

Output

dist_non_central_t_mode(10.0, 1.0)
0.932910364582629

dist_non_central_t_pdf

Scalar function Non-central t
Signature
dist_non_central_t_pdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_quantile

Scalar function Non-central t
Signature
dist_non_central_t_quantile( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_quantile_complement

Scalar function Non-central t
Signature
dist_non_central_t_quantile_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
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

dist_non_central_t_range

Scalar function Non-central t
Signature
dist_non_central_t_range(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_range(10.0, 1.0);

Output

dist_non_central_t_range(10.0, 1.0)
[-inf, inf]

dist_non_central_t_sample

Scalar function Non-central t
Signature
dist_non_central_t_sample(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_sample(10.0, 1.0);

Output

dist_non_central_t_sample(10.0, 1.0)
0.4732519667112593

dist_non_central_t_samples

Scalar function Non-central t
Signature
dist_non_central_t_samples( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
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]

dist_non_central_t_skewness

Scalar function Non-central t
Signature
dist_non_central_t_skewness(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_skewness(10.0, 1.0);

Output

dist_non_central_t_skewness(10.0, 1.0)
0.3999297299058122

dist_non_central_t_stddev

Scalar function Non-central t
Signature
dist_non_central_t_stddev(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_stddev(10.0, 1.0);

Output

dist_non_central_t_stddev(10.0, 1.0)
1.1513235684528724

dist_non_central_t_support

Scalar function Non-central t
Signature
dist_non_central_t_support(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_support(10.0, 1.0);

Output

dist_non_central_t_support(10.0, 1.0)
[-inf, inf]

dist_non_central_t_variance

Scalar function Non-central t
Signature
dist_non_central_t_variance(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_t_variance(10.0, 1.0);

Output

dist_non_central_t_variance(10.0, 1.0)
1.325545959275056