Skip to content

Non-central F functions in the Stochastic DuckDB extension

Function category

Non-central F

23 functions

dist_non_central_f_cdf

Scalar function Non-central F
Signature
dist_non_central_f_cdf( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_cdf(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_cdf(5.0, 10.0, 2.0, 1.5)
0.5640340505917344

dist_non_central_f_cdf_complement

Scalar function Non-central F
Signature
dist_non_central_f_cdf_complement( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Power of an F-test: P(F > critical value) under the alternative
SELECT round(dist_non_central_f_cdf_complement(3.0, 20.0, 8.0, dist_fisher_f_quantile(3.0, 20.0, 0.95)), 4) AS power;

Output

power
0.5611

dist_non_central_f_chf

Scalar function Non-central F
Signature
dist_non_central_f_chf( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_chf(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_chf(5.0, 10.0, 2.0, 1.5)
0.8301911363703502

dist_non_central_f_hazard

Scalar function Non-central F
Signature
dist_non_central_f_hazard( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_hazard(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_hazard(5.0, 10.0, 2.0, 1.5)
0.7747070165238954

dist_non_central_f_ks_test

Aggregate function Hypothesis Tests Non-central F
Signature
dist_non_central_f_ks_test( x: DOUBLE, d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Test a sample against a non central f distribution
SELECT dist_non_central_f_ks_test(x, 5.0, 10.0, 2.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.15463195317398948, 'p_value': 0.9705537878269356}

dist_non_central_f_kurtosis

Scalar function Non-central F
Signature
dist_non_central_f_kurtosis( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_kurtosis(5.0, 10.0, 2.0);

Output

dist_non_central_f_kurtosis(5.0, 10.0, 2.0)
54.64872617990574

dist_non_central_f_kurtosis_excess

Scalar function Non-central F
Signature
dist_non_central_f_kurtosis_excess( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_kurtosis_excess(5.0, 10.0, 2.0);

Output

dist_non_central_f_kurtosis_excess(5.0, 10.0, 2.0)
51.64872617990574

dist_non_central_f_log_cdf

Scalar function Non-central F
Signature
dist_non_central_f_log_cdf( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_log_cdf(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_log_cdf(5.0, 10.0, 2.0, 1.5)
-0.5726406559168778

dist_non_central_f_log_cdf_complement

Scalar function Non-central F
Signature
dist_non_central_f_log_cdf_complement( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_log_cdf_complement(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_log_cdf_complement(5.0, 10.0, 2.0, 1.5)
-0.8301911363703502

dist_non_central_f_log_pdf

Scalar function Non-central F
Signature
dist_non_central_f_log_pdf( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_log_pdf(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_log_pdf(5.0, 10.0, 2.0, 1.5)
-1.0854615006704573

dist_non_central_f_mean

Scalar function Non-central F
Signature
dist_non_central_f_mean( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_mean(5.0, 10.0, 2.0);

Output

dist_non_central_f_mean(5.0, 10.0, 2.0)
1.75

dist_non_central_f_median

Scalar function Non-central F
Signature
dist_non_central_f_median( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_median(5.0, 10.0, 2.0);

Output

dist_non_central_f_median(5.0, 10.0, 2.0)
1.3221924774916403

dist_non_central_f_mode

Scalar function Non-central F
Signature
dist_non_central_f_mode( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_mode(5.0, 10.0, 2.0);

Output

dist_non_central_f_mode(5.0, 10.0, 2.0)
0.7373059385581967

dist_non_central_f_pdf

Scalar function Non-central F
Signature
dist_non_central_f_pdf( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_pdf(5.0, 10.0, 2.0, 1.5);

Output

dist_non_central_f_pdf(5.0, 10.0, 2.0, 1.5)
0.33774587997208494

dist_non_central_f_quantile

Scalar function Non-central F
Signature
dist_non_central_f_quantile( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_quantile(5.0, 10.0, 2.0, 0.95);

Output

dist_non_central_f_quantile(5.0, 10.0, 2.0, 0.95)
4.585656276068195

dist_non_central_f_quantile_complement

Scalar function Non-central F
Signature
dist_non_central_f_quantile_complement( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_quantile_complement(5.0, 10.0, 2.0, 0.95);

Output

dist_non_central_f_quantile_complement(5.0, 10.0, 2.0, 0.95)
0.30915859459142164

dist_non_central_f_range

Scalar function Non-central F
Signature
dist_non_central_f_range( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_range(5.0, 10.0, 2.0);

Output

dist_non_central_f_range(5.0, 10.0, 2.0)
[0.0, inf]

dist_non_central_f_sample

Scalar function Non-central F
Signature
dist_non_central_f_sample( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_sample(5.0, 10.0, 2.0);

Output

dist_non_central_f_sample(5.0, 10.0, 2.0)
0.9724070872056085

dist_non_central_f_samples

Scalar function Non-central F
Signature
dist_non_central_f_samples( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 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_f_samples(5.0, 10.0, 2.0, 5);

Output

dist_non_central_f_samples(5.0, 10.0, 2.0, 5)
[1.711157002613222, 0.44684025807641736, 1.5751898327370633, 0.6790872267949067, 5.274442715076101]

dist_non_central_f_skewness

Scalar function Non-central F
Signature
dist_non_central_f_skewness( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_skewness(5.0, 10.0, 2.0);

Output

dist_non_central_f_skewness(5.0, 10.0, 2.0)
3.776417312971361

dist_non_central_f_stddev

Scalar function Non-central F
Signature
dist_non_central_f_stddev( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_stddev(5.0, 10.0, 2.0);

Output

dist_non_central_f_stddev(5.0, 10.0, 2.0)
1.5877132402714709

dist_non_central_f_support

Scalar function Non-central F
Signature
dist_non_central_f_support( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_support(5.0, 10.0, 2.0);

Output

dist_non_central_f_support(5.0, 10.0, 2.0)
[0.0, inf]

dist_non_central_f_variance

Scalar function Non-central F
Signature
dist_non_central_f_variance( d1: DOUBLE, d2: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument d1 Type DOUBLE Mode Positional Description
Argument d2 Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_f_variance(5.0, 10.0, 2.0);

Output

dist_non_central_f_variance(5.0, 10.0, 2.0)
2.5208333333333335