Returns the T-value of the student t distribution as a function of probability and degrees of freedom.
grammar
TINV(probability,degrees_freedom)
Probability corresponds to the probability of a two-tailed student t distribution.
Degrees_freedom Number of degrees of freedom in a distribution.
Instructions
■ If any of the parameters is non-numeric, TINV returns the #VALUE! Error value. .
■ If probability
■ If degrees_freedom is not an integer, it will be rounded by truncation.
■ If degrees_freedom < 1, TINV returns the #NUM! Error value .
TINV returns the value t, P(|X| > t) = probability, where X is a random variable subject to t distribution, and P(|X| > t) = P(X < -t or X > t).
The single-tailed T-value can be obtained by replacing the probability with twice the probability. If the probability is 0.05 and the degree of freedom is 10, the two-tailed value is calculated by TINV(0.05,10)
Get, it returns 2.28139. The same probability and the single tail of degrees of freedom can be calculated by TINV(2*0.05,10), which returns 1.812462.
Note: In some tables, the probability is described as (1-p).
■ If a probability value is given, TINV solves for the value x using TDIST(x, degrees_freedom, 2) = probability.
Therefore, the precision of TINV depends on the precision of TDIST. TINV uses an iterative search technique.
If the search does not converge after 100 iterations, the function returns the error value #N/A.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/