Difference between revisions of "Manuals/calci/GAMMAINV"
Jump to navigation
Jump to search
| Line 21: | Line 21: | ||
#=GAMMAINV(1,9,3) = 82.51739521528073 | #=GAMMAINV(1,9,3) = 82.51739521528073 | ||
#=GAMMAINV(1.1,9,3) = NAN, because <math> prob>1 </math> | #=GAMMAINV(1.1,9,3) = NAN, because <math> prob>1 </math> | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|SAMTXAAKeug|280|center|GAMMA Distribution}} | ||
==See Also== | ==See Also== | ||
Revision as of 13:21, 7 June 2015
GAMMAINV(prob,alpha,beta)
- is the probability value associated with gamma distribution
- & are the values of the shape and rate parameters
Description
- This function gives the inverse value of Cumulative Gamma Probability Distribution.
- This distribution is the Continuous Probability Distribution on the positive real line and it is of the reciprocal of a variable distributed according to the gamma distribution with two parameters & .
- It is used in Bayesian statistics.
- In 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 GAMMAINV(prob,alpha,beta)} , 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 probability value associated with Gamma 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 alpha} is called shape parameter 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 beta} is the rate parameter of the distribution.
- If 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 GAMMADIST(x,alpha,beta,TRUE)=prob} , then 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 GAMMAINV(prob,alpha,beta)= x} .
- GAMMAINV use the iterating method to find the value of 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 x} .
- Suppose the iteration has not converged after 100 searches, then the function gives the error result.
- This function will give the error result when
1.Any one of the arguments are non-numeric
2.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 alpha \le 0 }
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 beta \le 0 }
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 prob < 0}
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 prob > 1 }
Examples
- =GAMMAINV(0.65189,2,5) = 11.1335534510
- =GAMMAINV(0.006867292,5,7) = 8.155481331
- =GAMMAINV(0.1543869,9,3) = 18.0467153645
- =GAMMAINV(1,9,3) = 82.51739521528073
- =GAMMAINV(1.1,9,3) = NAN, because 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>1 }