Difference between revisions of "Manuals/calci/FINV"

Revision as of 10:23, 8 June 2015

FINV(prob,df1,df2)

$prob$ is the associated value of F distribution
$df_{1}$ and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_2} is the degrees of freedom.

This function gives the inverse of the F-distribution.
If $FDIST(x,df_{1},df_{2})=prob$ , then $NORMSINV(prob,df_{1},df_{2})=x$ .FINV using the iterating method to find the value of x.
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
FINV can be used to return critical values from the F distribution
The calculation of analysis of variance includes the data for F probability for the significance level 0.05.
When the value of $df_{1}$ and $df_{2}$ are not integers ,then it is converted in to integers.
This function will return the result as error when
1. any one of the argument is nonnumeric.
2.prob<0 or prob>1.
3. $df_{1}$ or $df_{2}<1$ ,and $df_{1}$ or $df_{2}>=10^{10}$

The syntax is to calculate FINV in ZOS is
- $prob$ is the associated value of F distribution.
For e.g., FINV(0.293,4,5)

@@ Line 14: / Line 14: @@
 *2.prob<0 or prob>1.
 *3.<math>df_1</math> or <math>df_2<1</math> ,and  <math>df_1</math> or <math>df_2>=10^{10}</math>
+==ZOS==
+*The syntax is to calculate FINV in ZOS is <math>FINV (probability,DegreeOfFreedom1,DegreeOfFreedom2,accuracy)</math>
+**<math>prob</math>  is the associated value of F distribution.
+*For e.g., FINV(0.293,4,5)
 ==Examples==