Difference between revisions of "Manuals/calci/FINV"
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
==Description== | ==Description== | ||
*This function gives the inverse of the F-distribution. | *This function gives the inverse of the F-distribution. | ||
− | *If FDIST(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 | + | *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== |
Revision as of 13:08, 8 May 2015
FINV(prob,df1,df2)
- is the associated value of F distribution
- and is the degrees of freedom.
Description
- This function gives the inverse of the F-distribution.
- If , then .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 and 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. or ,and or
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