Compatibility =TINV(probability,deg_freedom)

Quiz =TINV — 10 Questions

10 quiz questions about =TINV — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← TINV ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =TINV?

Question 2 of 10 2/10

Which formula is a valid example of =TINV?

Question 3 of 10 3/10

Which use case fits =TINV?

Question 4 of 10 4/10

Which statement about =TINV is correct?

Question 5 of 10 5/10

How many arguments does =TINV have in total?

Question 6 of 10 6/10

What usually causes #N/A in =TINV?

Question 7 of 10 7/10

Is argument “deg_freedom” required in =TINV?

Question 8 of 10 8/10

Is =TINV volatile?

Question 9 of 10 9/10

What is the fix for #NUM! in =TINV?

Question 10 of 10 10/10

What usually causes #VALUE! in =TINV?

Click a question to see the answer.

1. Which function is NOT related to =TINV?

A. PERCENTILE
B. MODE
C. FORECAST.ETS ✓
D. FORECAST

Explanation: “FORECAST.ETS” is not related to TINV.

2. Which formula is a valid example of =TINV?

A. =TINV(A2,A3) ✓
B. TINV(A2,A3)
C. =FORECAST(A2,A3)
D. =TINV(A2,A3, 0)

Explanation: Correct example: =TINV(A2,A3)

3. Which use case fits =TINV?

A. Forecasting & Trends
B. Text Manipulation
C. Reporting ✓
D. Daily Tasks

Explanation: Use case “Reporting” fits TINV.

4. Which statement about =TINV is correct?

A. If deg_freedom is not an integer, it is truncated.
B. Select entire column for best performance
C. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new functions, see T.INV.2T function or T.INV function. ✓
D. TINV returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new functions, see T.INV.2T function or T.INV function.

5. How many arguments does =TINV have in total?

A. 3
B. 1
C. 4
D. 2 ✓

Explanation: =TINV has 2 required, 0 optional (2 total).

6. What usually causes #N/A in =TINV?

A. If the search has not converged after 100 iterations, the function returns the #N/A error value. ✓
B. Select entire column for best performance
C. Requires add-in
D. اگر هر آرگومانی غیرعددی باشد، تابع TINV خطای #VALUE! را برمی‌گرداند.

Explanation: If the search has not converged after 100 iterations, the function returns the #N/A error value. — Fix: مقادیر ورودی را بررسی کنید و با مقادیر معتبر دوباره امتحان کنید؛ در صورت تکرار، احتمال یا درجات آزادی را کمی تغییر دهید.

7. Is argument “deg_freedom” required in =TINV?

A. Yes ✓
B. No
C. —
D. Yes

Explanation: “deg_freedom” is required.

8. Is =TINV volatile?

A. No ✓
B. —
C. Yes
D. No

Explanation: TINV is not volatile.

9. What is the fix for #NUM! in =TINV?

A. Select entire column for best performance
B. اگر جستجو پس از ۱۰۰ تکرار همگرا نشود، تابع خطای #N/A را برمی‌گرداند.
C. Between 0 and 1 ✓
D. Text is always ignored

Explanation: If probability <= 0 or if probability > 1, TINV returns the #NUM! error value. If deg_freedom < 1, TINV returns the #NUM! error value. — Fix: Between 0 and 1

10. What usually causes #VALUE! in =TINV?

A. اگر probability کوچک‌تر یا مساوی ۰ یا بزرگ‌تر از ۱ باشد، یا deg_freedom کوچک‌تر از ۱ باشد، تابع TINV خطای #NUM! را برمی‌گرداند.
B. اگر جستجو پس از ۱۰۰ تکرار همگرا نشود، تابع خطای #N/A را برمی‌گرداند.
C. If either argument is nonnumeric, TINV returns the #VALUE! error value. ✓
D. Output is always a dynamic array

Explanation: If either argument is nonnumeric, TINV returns the #VALUE! error value. — Fix: بررسی کنید Probability و Deg_freedom هر دو عددی باشند.