Difference between revisions of "Manuals/calci/FINV"

From ZCubes Wiki
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...")
 
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"> 
+
<div style="font-size:23px">'''FINV (probability, DegreeOfFreedom1, DegreeOfFreedom2, Accuracy, DivisionMinMaxArray)'''</div><br/>
 +
*<math>probability</math>  is the associated value of F distribution 
 +
*<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.
  
−
'''FINV'''('''prob''','''DF1''','''DF2''')
+
==Description==
 +
*This function gives the inverse of the F-distribution.
 +
*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.
 +
*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 <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
 +
*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>
  
−
'''Where prob''' is a probability associated with the F cumulative distribution.
+
==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)
  
−
'''DF1'''  is the numerator degrees of freedom and '''DF2''' is the denominator degrees of freedom.
+
==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)
  
−
</div>
+
==Related Videos==
−
----
+
{{#ev:youtube|7rGAh_XDvY8|280|center|F Distribution}}
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
This function returns the inverse of the F probability distribution.
+
==See Also==
  
−
</div>
+
*[[Manuals/calci/FDIST | FDIST]]
−
----
+
*[[Manuals/calci/FISHER | FISHER]]
−
<div id="7SpaceContent" class="zcontent" align="left"> 
+
*[[Manuals/calci/FISHERINV| FISHERINV]]
  
−
·          Arguments should be numeric.
+
==References==
 +
*[http://en.wikipedia.org/wiki/Inverse_distribution Inverse distribution]
  
−
·          Prob must be between 0 and 1
 
  
−
·          When DF1is less than 1 or DF1is less than or equal to 10^10, and  DF2 is less than 1 or DF2 is less than or equal to 10^10, FINV shows error value.
 
  
−
</div>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
FINV
+
*[[ Z3 |  Z3 home ]]
−
 
 
−
</div></div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example,
 
−
 
 
−
FINV(prob,DF1,DF2)
 
−
 
 
−
'''B'''
 
−
 
 
−
0.01
 
−
 
 
−
8
 
−
 
 
−
6
 
−
 
 
−
<nowiki>=FINV(B2,B3,B4)</nowiki>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="  " | Column2
 
−
| class="   " | Column3
 
−
| class="                                                          " |
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 0.01
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 8
 
−
| class="SelectTD" |
 
−
| class="sshl_f    " |
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f " | 6
 
−
| class="sshl_f  " |
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="    " |
 
−
| class="sshl_f  " |
 
−
| class=" " |
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" |
 
−
| class="sshl_f  " |
 
−
| class=" " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f  " |
 
−
| class=" " |
 
−
|
 
−
|}
 
−
 
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 

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"