writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − + +
→Description
==Description==
==Description==
*This function gives the inverse of the F-distribution.
*This function gives the inverse of the F-distribution.
*If <math>FDIST (Number,DegreeOfFreedom1,DegreeOfFreedom2)=probability </math>, then <math>NORMSINV (Probability)=x</math>.FINV using the iterating method to find the value of x.
*If <math>FDIST (Number,DegreeOfFreedom1,DegreeOfFreedom2)=probability </math>, then <math>NORMSINV (Probability)=x</math>.
*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.
*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
*FINV can be used to return critical values from the F distribution