Difference between revisions of "Manuals/calci/FDIST"
Jump to navigation
Jump to search
(2 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 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. | + | #=FDIST(10,1.3,1.5) = 0.12923064798773362 |
− | #=FDIST(-28,4,6) = | + | #=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
- =FDIST(20.6587,7,3) = 0.01526530981
- =FDIST(70.120045,12.2,6.35) = 0.000011229898
- =FDIST(10,1.3,1.5) = 0.12923064798773362
- =FDIST(-28,4,6) = #N/A (NUMBER > 0)
Related Videos
See Also
References