F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
The following article introduces you to the F.DIST.RT function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the right probability distribution F for 2 data sets. Support function from Excel 2010 version.
Syntax: F.DIST (x, deg_freedom1, deg_freedom2)
Inside:
- x: The value of the function, is a required parameter.
- deg_freedom1: The degree of freedom in the numerator, is a required parameter.
- deg_freedom2: The degrees of freedom in the denominator, are required parameters.
Attention:
- If any parameters are not numeric -> the function returns the #VALUE! Error value .
- If x <0 -> the function returns the #NUM! Error value
- If deg_freedom1 , deg_freedom2 are not whole numbers -> they are truncated to integers.
- If deg_freedom1 <1 or deg_freedom2 <1 -> the function returns the #NUM! Error value
- The F.DIST.RT function is calculated as F.DIST.RT = P (F> x) where F is a random variable.
For example:
Calculate the right probability distribution F according to the data in the following data table:
- In the cell to calculate enter the formula : = F.DIST.RT (D6, D7, D8)
- Press Enter -> probability of distribution F is:
- Where the function value is less than 0 -> the function returns the #NUM! Error value
- If the number of degrees of freedom in the numerator and sample is less than 1 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using F.DIST.RT function in Excel.
Good luck!
You should read it
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
- CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel
- T.DIST - The function returns the Student t-distribution on the left in Excel
- T.DIST.2T - The function returns the two-tailed Student distribution in Excel
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
- NEGBINOM.DIST function - Function returns the negative binomial distribution in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
May be interested
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excelt.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excelbinom.dist.range function: the function returns the probability of a test result using binomial distribution. support functions from the excel 2010 version. syntax: binom.dist.range (trials, probability_s, number_s, [number_s2])
- T.INV function - The function returns the inverse value of the Student t distribution in Excelt.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- T.DIST - The function returns the Student t-distribution on the left in Excelt.dist: the function returns the student's t-distribution on the left. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist (x, deg_freedom, cumulative)
- T.DIST.2T - The function returns the two-tailed Student distribution in Excelt.dist.2t: the function returns the two-tailed student's t-distribution. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.2t (x, deg_freedom)
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excelbeta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
- ZTEST function - Returns the probability value on one side of the z test in Excelztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- NEGBINOM.DIST function - Function returns the negative binomial distribution in Excelnegbinom.dist: the function returns the negative binomial distribution, the probability that there will be number_f failures before the number_s th success, with the probability of success being probability_s. support functions from excel 2010 onwards. syntax: negbinom.dist (number_f, number_s, probab
- TTEST - Returns the probability associated with a Student's t-Test in Exceldescription: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excelhypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)