Manuals/calci/FINV

FINV (probability, DegreeOfFreedom1, DegreeOfFreedom2, Accuracy, DivisionMinMaxArray)

• $probability$ is the associated value of F distribution
• $DegreeOfFreedom1$ and $DegreeOfFreedom2$ is the degrees of freedom.

Description

• This function gives the inverse of the F-distribution.
• If $FDIST(Number,DegreeOfFreedom1,DegreeOfFreedom2)=probability$, then $NORMSINV(Probability)=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 $DegreeOfFreedom1$ and $DegreeOfFreedom2$ 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.probability<0 or probability>1.
• 3.$DegreeOfFreedom1$ or $DegreeOfFreedom2<1$ ,and $DegreeOfFreedom1$ or $DegreeOfFreedom2>=10^{10}$

ZOS

• The syntax is to calculate FINV in ZOS is $FINV(probability,DegreeOfFreedom1,DegreeOfFreedom2,Accuracy,DivisionMinMaxArray)$
  • $probability$ is the associated value of F distribution.
• For e.g., FINV(0.293,4,5)

Examples

• FINV(0.01526530981,7,3) = 20.658810208868587
• FINV(0.001,5,1) = 199.9
• FINV(0,4,2) = 199.9
• FINV(-1,7,2) = #ERROR

Related Videos

F Distribution

See Also

• FDIST
• FISHER
• FISHERINV

References

• Inverse distribution

• List of Main Z Functions

• Z3 home