Difference between revisions of "Manuals/calci/FINV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FINV'''('''prob''','''DF1''','''DF2''') '''Where prob''' is a probability associated with the F cumulative d...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''FINV(prob,df1,df2)'''</div><br/> |
| + | *<math>prob</math> is the associated value of F distribution | ||
| + | *<math> df1</math> and <math> df2</math>is the degrees of freedom. | ||
| − | + | ==Description== | |
| − | + | *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. | |
| − | + | *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 df1 and df2 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. df1 or df2<1 ,and df1 ordf2>=10^10 | |
| − | + | where , and df2 '''FINV'''('''prob''','''DF1''','''DF2''') | |
| − | |||
| − | This function | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | < | ||
| − | |||
| − | < | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | FINV(prob,DF1, | ||
| − | |||
| − | ''' | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:27, 7 January 2014
FINV(prob,df1,df2)
- is the associated value of F distribution
- and is the degrees of freedom.
is the associated value of F distribution
and 
is the degrees of freedom.Description
- 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.
- 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 df1 and df2 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. df1 or df2<1 ,and df1 ordf2>=10^10
where , and df2 FINV(prob,DF1,DF2)