- Picture and text skills
- Case
Returns the t-value of the Student's 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's t distribution.
Degrees_freedom The numerical degrees of freedom of the distribution.
Description
￭If any parameter is non-numeric, TINV returns the #VALUE! error value.
￭probability
￭If degrees_freedom is not an integer, it will be truncated.
￭If degrees_freedom < 1, TINV returns the #NUM! error value.
TINV returns the t value, P(|X| > t) = probability, where X is a random variable obeying t distribution, and P(|X| < span style="">> t) = P(X < -t or X > t).
One-tailed t-values are found by replacing the probability with twice the probability. If the probability is 0.05 and the degrees of freedom are 10, the two-tailed value is calculated by TINV(0.05,10)
Get, it returns 2.28139. The one-tailed value for the same probability and 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 accuracy of TINV depends on the accuracy of TDIST. TINV uses an iterative search technique.
If the search does not converge after 100 iterations, the function returns the #N/A error value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/TINV-han-shu-ji-suan-zi-you-du-shuang-wei-gai-lyu-qu-jian-dian.html
支付宝扫一扫 
评论列表（196条）
测试