:Calculate the FINV function value in less than 0.1 seconds-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the inverse function value of the F probability distribution. If p = FDIST(x,…), then FINV(p,…) = x.

In an F-test, you can use the F-distribution to compare the degree of change in two data sets.

For example, you can analyze the income distribution of the United States and Canada to determine whether the two countries/regions have similar income changes.

Syntax
FINV(probability,degrees_freedom1,degrees_freedom2)
Probability Probability value related to F cumulative distribution.
Degrees_freedom1 Degrees of freedom of the molecule.
Degrees_freedom2 Degrees of freedom in the denominator.

Description

￭If any parameter is non-numeric type, FINV returns the error value #VALUE!.

￭ If any of the following situations occur, Then FINV returns the error value #NUM!.

1. probability

￭If degrees_freedom1 or degrees_freedom2 is not an integer, Will be truncated.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/bu-dao-1-miao-suan-chu-FINV-han-shu-zhi.html