Difference between revisions of "Manuals/calci/FINV"

From ZCubes Wiki
Jump to navigation Jump to search
 
(11 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> df_1</math> and <math> df_2</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 <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.
+
*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.
 
*The calculation of analysis of variance includes the data for F probability for the significance level 0.05.
−
*When the value of <math>df_1</math> and <math>df_2</math> are not integers ,then it is converted in to integers.
+
*When the value of <math>DegreeOfFreedom1</math> and <math>DegreeOfFreedom2</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.probability<0 or probability>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>DegreeOfFreedom1</math> or <math>DegreeOfFreedom2<1</math> ,and  <math>DegreeOfFreedom1</math> or <math>DegreeOfFreedom2>=10^{10}</math>
  
 
==ZOS==
 
==ZOS==
−
*The syntax is to calculate FINV in ZOS is <math>FINV (probability,DegreeOfFreedom1,DegreeOfFreedom2,accuracy)</math>
+
*The syntax is to calculate FINV in ZOS is <math>FINV (probability,DegreeOfFreedom1,DegreeOfFreedom2,Accuracy,DivisionMinMaxArray)</math>
−
**<math>prob</math>  is the associated value of F distribution.
+
**<math>probability</math>  is the associated value of F distribution.
 
*For e.g., FINV(0.293,4,5)
 
*For e.g., FINV(0.293,4,5)
  
Line 24: Line 28:
 
*FINV(0.001,5,1) = 199.9
 
*FINV(0.001,5,1) = 199.9
 
*FINV(0,4,2) = 199.9
 
*FINV(0,4,2) = 199.9
−
*FINV(-1,7,2) = #ERROR
+
*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==
 
==See Also==
Line 34: Line 41:
 
==References==
 
==References==
 
*[http://en.wikipedia.org/wiki/Inverse_distribution Inverse distribution]
 
*[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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FINV&oldid=214808"