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 FDIST(x,df1,df2)=prob, then NORMSINV(prob,df1,df2)=x.FINV using the iterating method to find the value of x.
*If <math>FDIST(x,df_1,df_2)=prob</math>, then <math>NORMSINV(prob,df_1,df_2)=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
*The calculation of analysis of variance includes the data for F probability for the significance level 0.05.
*The calculation of analysis of variance includes the data for F probability for the significance level 0.05.
*When the value of df1 and df2 are not integers ,then it is converted in to integers.
*When the value of <math>df_1</math> and <math>df_2</math> are not integers ,then it is converted in to integers.
*This function will return the result as error when
*This function will return the result as error when
*1. any one of the argument is nonnumeric.
*1. any one of the argument is nonnumeric.
*2.prob<0 or prob>1.
*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>
*3.<math>df_1</math> or <math>df_2<1</math> ,and <math>df_1</math> or <math>df_2>=10^{10}</math>
==Examples==
==Examples==