Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > FDIST
 

FDIST(x, degrees_freedom1, degrees_freedom2)

 
 Returns the F probability distribution.

 xThe value at which to evaluate the function.
 degrees_freedom1The numerator degrees of freedom.
 degrees_freedom2The denominator degrees of freedom.

 REMARKS
 
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "x" is negative, then #NUM! is returned.
     
  		• If "degrees_freedom1" is not an integer, it is truncated.
     
  		• If "degrees_freedom1" < 1, then #NUM! is returned.
     
  		• If "degrees_freedom1" = 10^10, then #NUM! is returned.
     
  		• If "degrees_freedom2" is not an integer, it is truncated.
     
  		• If "degrees_freedom2" < 1, then #NUM! is returned.
     
  		• If "degrees_freedom2" = 10^10, then #NUM! is returned.
     
  		• This function uses the following formula ( F < x ), where F is a random variable that has an F distribution.

     EXAMPLES
     
     A
    1=FDIST(15.207,6,4) = 0.01
    2=FDIST(5,1,2) = 0.155
    3=FDIST(1,1,1) = 0.5
    4=FDIST(5,1,0.5) = #NUM!
    5=FDIST(5,0.5,2) = #NUM!
    6=FDIST(5,"some text",2) = #VALUE!
    		 
     Functions - F | Index - F | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top