Non-central F functions in the Stochastic DuckDB extension
Function category
Non-central F
23 functionsNon-central F — F ratio under the alternative hypothesis. Power analysis for ANOVA and regression F-tests.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the cumulative distribution function (CDF) of the non-central F distribution, P(X <= x).
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the complementary cumulative distribution function (survival function) of the non-central F distribution, P(X > x).
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the cumulative hazard function of the non-central F distribution at x.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the hazard function of the non-central F distribution at x.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
One-sample Kolmogorov-Smirnov test of whether x follows the non-central F distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
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} |
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the natural logarithm of the cumulative distribution function (CDF) of the non-central F distribution.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the natural logarithm of the survival function of the non-central F distribution, log P(X > x).
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the natural logarithm of the probability density function (PDF) of the non-central F distribution at x. Useful for numerical stability when dealing with very small probabilities.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the probability density function (PDF) of the non-central F distribution at x.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the quantile function (inverse CDF) of the non-central F distribution. Returns the smallest x such that P(X <= x) >= p.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Computes the complementary quantile function of the non-central F distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the non-central F distribution as [min, max].
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] |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the non-central F distribution with the specified parameters.
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 |
Related functions
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
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
Generates a list of n random samples from the non-central F distribution with the specified parameters.
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] |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the non-central F distribution as [min, max].
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] |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
d1
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
d2
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
noncentrality
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the non-central F distribution. Returns NULL when it is undefined for the given parameters.
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 |
Related functions
- dist_non_central_f_sample() — Generates a random sample from the non-central F distribution with the specified parameters
- dist_non_central_f_pdf() — Computes the probability density function (PDF) of the non-central F distribution at x
- dist_non_central_f_quantile() — Computes the quantile function (inverse CDF) of the non-central F distribution
- dist_non_central_f_mean() — Returns the mean of the non-central F distribution
- dist_non_central_f_stddev() — Returns the standard deviation of the non-central F distribution