Difference between revisions of "Manuals/calci/FDIST"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
*<math>Number</math> is the value of the function
 
*<math>Number</math> is the value of the function
 
*<math>DegreeOfFreedom1</math> and <math>DegreeOfFreedom2</math> are numbers of degrees of freedom.
 
*<math>DegreeOfFreedom1</math> and <math>DegreeOfFreedom2</math> are numbers of degrees of freedom.
 +
**FDIST(), returns the F probability distribution.
  
 
==Description==
 
==Description==
Line 17: Line 18:
 
   1. any one of the argument is non-numeric.
 
   1. any one of the argument is non-numeric.
 
   2. Number is negative
 
   2. Number is negative
   3. If DegreeOfFreedom1<1  or DegreeOfFreedom2>10^{10} and  DegreeOfFreedom2<1 or DegreeOfFreedom2> 10^{10}
+
   3. If DegreeOfFreedom1<1  or DegreeOfFreedom2><math>10^{10}</math> and  DegreeOfFreedom2<1 or DegreeOfFreedom2> <math>10^{10}</math>
  
 
==ZOS==
 
==ZOS==
Line 29: Line 30:
 
#=FDIST(20.6587,7,3) = 0.01526530981
 
#=FDIST(20.6587,7,3) = 0.01526530981
 
#=FDIST(70.120045,12.2,6.35) = 0.000011229898
 
#=FDIST(70.120045,12.2,6.35) = 0.000011229898
#=FDIST(10,1.3,1.5) = 0.134947329626
+
#=FDIST(10,1.3,1.5) = 0.12923064798773362
#=FDIST(-28,4,6) = NAN
+
#=FDIST(-28,4,6) = #N/A (NUMBER > 0)
  
 
==Related Videos==
 
==Related Videos==

Latest revision as of 09:10, 2 June 2020

FDIST (Number,DegreeOfFreedom1,DegreeOfFreedom2)


  • is the value of the function
  • and are numbers of degrees of freedom.
    • FDIST(), returns the F probability distribution.

Description

  • This function gives the value of F probability distribution.
  • This distribution is continuous probability distribution and it is called Fisher-Snedecor distribution.
  • The F distribution is an asymmetric distribution that has a minimum value of 0, but no maximum value.
  • In is the value of the function , is the numerator degrees of freedom and is the denominator degrees of freedom.
  • This distribution is the ratio of two chi-square distributions with degrees of freedom r1 and r2, respectively, where each chi-square has first been divided by its degrees of freedom.
  • The Probability density function of the F distribution is:

where is the Gamma Function.

  • The gamma function is defined by .

When the value of DegreeOfFreedom1 and DegreeOfFreedom2 are not integers ,then it is converted in to integers.

  • This function will give the result as error when
 1. any one of the argument is non-numeric.
 2. Number is negative
 3. If DegreeOfFreedom1<1  or DegreeOfFreedom2> and  DegreeOfFreedom2<1 or DegreeOfFreedom2> 

ZOS

  • The syntax is to find FDIST in ZOS is .
    • is the value of the function.
  • For e.g.,FDIST(85.2,22,18)
  • FDIST(67..70,6,8)

Examples

  1. =FDIST(20.6587,7,3) = 0.01526530981
  2. =FDIST(70.120045,12.2,6.35) = 0.000011229898
  3. =FDIST(10,1.3,1.5) = 0.12923064798773362
  4. =FDIST(-28,4,6) = #N/A (NUMBER > 0)

Related Videos

F Distribution

See Also

References

F-Distribution