Difference between revisions of "Manuals/calci/FINV"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''FINV(prob,df1,df2)'''</div><br/> | <div style="font-size:30px">'''FINV(prob,df1,df2)'''</div><br/> | ||
*<math>prob</math> is the associated value of F distribution | *<math>prob</math> is the associated value of F distribution | ||
| − | *<math> | + | *<math> df_1</math> and <math> df_2</math>is the degrees of freedom. |
==Description== | ==Description== | ||
| Line 8: | Line 8: | ||
*Suppose the iteration has not converged after 100 searches, then the function gives the error result. | *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 | *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 df1 and df2 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. | + | *The calculation of analysis of variance includes the data for F probability for the significance level 0.05. |
| − | 2.prob<0 or prob>1. | + | *When the value of df1 and df2 are not integers ,then it is converted in to integers. |
| − | 3. | + | *This function will return the result as error when |
| − | + | *1. any one of the argument is nonnumeric. | |
| + | *2.prob<0 or prob>1. | ||
| + | *3.<math>df_1</math> or <math>df_2<1</math> ,and <math>df_1</math> or <math>df_2>=10^10</math> | ||
| + | |||
| + | ==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) = #ERROR | ||
| + | |||
| + | ==See Also== | ||
| + | |||
| + | *[[Manuals/calci/FDIST | FDIST]] | ||
| + | *[[Manuals/calci/FISHER | FISHER]] | ||
| + | *[[Manuals/calci/FISHERINV| FISHERINV]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://en.wikipedia.org/wiki/Inverse_distribution Inverse distribution] | ||
Revision as of 13:03, 8 May 2015
FINV(prob,df1,df2)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle prob} is the associated value of F distribution
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_2} is the degrees of freedom.
Description
- This function gives the inverse of the F-distribution.
- If FDIST(x,df1,df2)=prob, then NORMSINV(prob,df1,df2)=x.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 df1 and df2 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.prob<0 or prob>1.
- 3.Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_1} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_2<1} ,and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df_1} or Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle df_{2}>=10^{1}0}
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) = #ERROR