Difference between revisions of "Manuals/calci/FINV"

From ZCubes Wiki
Jump to navigation Jump to search
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''FINV(prob,df1,df2)'''</div><br/>
+
<div style="font-size:23px">'''FINV (probability, DegreeOfFreedom1, DegreeOfFreedom2, Accuracy, DivisionMinMaxArray)'''</div><br/>
*<math>prob</math>  is the associated value of F distribution   
+
*<math>probability</math>  is the associated value of F distribution   
*<math> df1</math> and <math> df2</math>is the degrees of freedom.
+
*<math> DegreeOfFreedom1 </math> and <math> DegreeOfFreedom2 </math> is the degrees of freedom.
 +
*<math>Accuracy</math> gives accurate value of the solution.
 +
*<math>DivisionMinMaxArray</math> value of the division.
 +
**FINV(), returns the inverse of the F probability distribution.
  
 
==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 (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
*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.
+
*The calculation of analysis of variance includes the data for F probability for the significance level 0.05.
2.prob<0 or prob>1.
+
*When the value of <math>DegreeOfFreedom1</math> and <math>DegreeOfFreedom2</math> are not integers ,then it is converted in to integers.
3. df1 or df2<1 ,and  df1 ordf2>=10^10
+
*This function will return the result as error  when  
  where  , and df2 '''FINV'''('''prob''','''DF1''','''DF2''')
+
*1. any one of the argument is nonnumeric.
 +
*2.probability<0 or probability>1.
 +
*3.<math>DegreeOfFreedom1</math> or <math>DegreeOfFreedom2<1</math> ,and  <math>DegreeOfFreedom1</math> or <math>DegreeOfFreedom2>=10^{10}</math>
 +
 
 +
==ZOS==
 +
*The syntax is to calculate FINV in ZOS is <math>FINV (probability,DegreeOfFreedom1,DegreeOfFreedom2,Accuracy,DivisionMinMaxArray)</math>
 +
**<math>probability</math> 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) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)
 +
 
 +
==Related Videos==
 +
{{#ev:youtube|7rGAh_XDvY8|280|center|F Distribution}}
 +
 
 +
==See Also==
 +
 
 +
*[[Manuals/calci/FDIST | FDIST]]
 +
*[[Manuals/calci/FISHER | FISHER]]
 +
*[[Manuals/calci/FISHERINV| FISHERINV]]
 +
 
 +
==References==
 +
*[http://en.wikipedia.org/wiki/Inverse_distribution Inverse distribution]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 03:21, 12 August 2020

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


  • is the associated value of F distribution
  • and is the degrees of freedom.
  • gives accurate value of the solution.
  • value of the division.
    • FINV(), returns the inverse of the F probability distribution.

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.probability<0 or probability>1.
  • 3. or ,and or

ZOS

  • The syntax is to calculate FINV in ZOS is
    • 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) = #N/A (PROBABILITY IN BETWEEN 0 AND 1 REQUIRED)

Related Videos

F Distribution

See Also

References