Manuals/calci/TINV

From ZCubes Wiki
Jump to navigation Jump to search
TINV (Probability,DegreeOfFreedom)


  • 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 Probability } is the probability value for the two tailed T-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 DegreeOfFreedom } is the degrees of freedom.
    • TINV(), returns the inverse of the Students t-distribution.

Description

  • This function gives the 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 t} value of the T-distribution.
  • This function is called the inverse function of the T-distribution.
  • 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 TINV(Probability,DegreeOfFreedom)} , 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 Probability} is the probability value related with the two tailed distribution 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 DegreeOfFreedom } is the number of degrees of freedom which is characterize the distribution.
  • i.e., This function is the inverse 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 TDIST (Number,DegreeOfFreedom,2)} .
  • Suppose we want to find the inverse value of one tailed distribution, then we have to multiply 2 with the prob value.
  • For e.g., TINV(0.078,20) = 1.857683 which is the inverse value of two tailed T-distribution.
  • TINV(2*0.078,20)=1.474181542 which is the inverse value of one tailed T-distribution.
  • Suppose 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 DegreeOfFreedom} value is decimal then it is converted in to integers.
  • 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 TDIST (Number,DegreeOfFreedom,Tail)=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 TINV (Probability,DegreeOfFreedom)=x} for the two tailed T-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 TINV } using 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 result as error when
    1.Any one of the argument is non-numeric. 
    2.Probability<0 or Probability>1 or DegreeOfFreedom<1.

Examples

  1. =TINV(0.0742,55) = 1.820015422
  2. =TINV(2*0.0371,55) = 1.820015422
  3. =TINV(0.65482,29) = 0.451735616
  4. =TINV(0.5,5) = 0.726686844

Related Videos

TINV

See Also

References