Statistical =CONFIDENCE.T(alpha,standard_dev,size)

Quiz =CONFIDENCE.T — 10 Questions

10 quiz questions about =CONFIDENCE.T — test syntax, arguments, examples & errors!

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

← CONFIDENCE.T ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #DIV/0! in =CONFIDENCE.T?

Question 2 of 10 2/10

Since which Excel version is =CONFIDENCE.T available?

Question 3 of 10 3/10

Does =CONFIDENCE.T return a dynamic array?

Question 4 of 10 4/10

What is the fix for #DIV/0! in =CONFIDENCE.T?

Question 5 of 10 5/10

In =CONFIDENCE.T, which is argument #2?

Question 6 of 10 6/10

Which category does =CONFIDENCE.T belong to?

Question 7 of 10 7/10

Which function is related to =CONFIDENCE.T?

Question 8 of 10 8/10

Is argument “standard_dev” required in =CONFIDENCE.T?

Question 9 of 10 9/10

Is =CONFIDENCE.T volatile?

Question 10 of 10 10/10

Which is the correct syntax of =CONFIDENCE.T?

Click a question to see the answer.

1. What usually causes #DIV/0! in =CONFIDENCE.T?

A. آلفا خارج از ‎۰ تا ۱ یا انحراف معیار صفر/منفی است.
B. Text is always ignored
C. یکی از آرگومان‌ها غیرعددی است.
D. If size equals 1, CONFIDENCE.T returns #DIV/0! error value. ✓

Explanation: If size equals 1, CONFIDENCE.T returns #DIV/0! error value. — Fix: حجم نمونه را حداقل ‎۲ وارد کنید، چون با یک نمونه فاصلهٔ اطمینان t قابل محاسبه نیست.

2. Since which Excel version is =CONFIDENCE.T available?

A. Excel 365
B. All versions
C. Excel 2007 (Compatibility)
D. Excel 2010 ✓

Explanation: Version: “Excel 2010”.

3. Does =CONFIDENCE.T return a dynamic array?

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

Explanation: CONFIDENCE.T does not spill.

4. What is the fix for #DIV/0! in =CONFIDENCE.T?

A. Select entire column for best performance
B. Only works in old versions
C. حجم نمونه را حداقل ‎۲ وارد کنید، چون با یک نمونه فاصلهٔ اطمینان t قابل محاسبه نیست. ✓
D. Volatile and recalculates every time

5. In =CONFIDENCE.T, which is argument #2?

A. size
B. value
C. standard_dev ✓
D. lookup_value

Explanation: Argument #2 is “standard_dev”.

6. Which category does =CONFIDENCE.T belong to?

A. Math & Trig
B. Date & Time
C. Logical
D. Statistical ✓

Explanation: Category is “Statistical”.

7. Which function is related to =CONFIDENCE.T?

A. ATAN2
B. BASE
C. CONVERT
D. STDEV-S ✓

Explanation: “STDEV-S” is related to CONFIDENCE.T.

8. Is argument “standard_dev” required in =CONFIDENCE.T?

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

Explanation: “standard_dev” is required.

9. Is =CONFIDENCE.T volatile?

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

Explanation: CONFIDENCE.T is not volatile.

10. Which is the correct syntax of =CONFIDENCE.T?

A. CONFIDENCE.T(alpha,standard_dev,size)
B. =CONFIDENCE.T(alpha,standard_dev,size) ✓
C. =CONFIDENCE.T(alpha,standard_dev,size, 0)
D. =STDEV-S(alpha,standard_dev,size)

Explanation: Correct syntax: =CONFIDENCE.T(alpha,standard_dev,size)