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 is the type of argument “standard_dev” in =CONFIDENCE.T?

Question 2 of 10 2/10

What is the fix for #NUM! in =CONFIDENCE.T?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

What usually causes #VALUE! in =CONFIDENCE.T?

Question 5 of 10 5/10

What is the fix for #VALUE! in =CONFIDENCE.T?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What is the type of argument “size” in =CONFIDENCE.T?

Question 8 of 10 8/10

What is the type of argument “alpha” in =CONFIDENCE.T?

Question 9 of 10 9/10

Does =CONFIDENCE.T return a dynamic array?

Question 10 of 10 10/10

Which is the correct syntax of =CONFIDENCE.T?

Click a question to see the answer.

1. What is the type of argument “standard_dev” in =CONFIDENCE.T?

A. Value
B. Number ✓
C. Reference
D. Text

Explanation: Type of “standard_dev” is “Number”.

2. What is the fix for #NUM! in =CONFIDENCE.T?

A. Correct the input value ✓
B. Requires add-in
C. حجم نمونه برابر ‎۱ است.
D. Output is always a dynamic array

Explanation: If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value. If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value. — Fix: Correct the input value

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

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

Explanation: Argument #2 is “standard_dev”.

4. What usually causes #VALUE! in =CONFIDENCE.T?

A. آلفا خارج از ‎۰ تا ۱ یا انحراف معیار صفر/منفی است.
B. If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value. ✓
C. حجم نمونه برابر ‎۱ است.
D. Select entire column for best performance

Explanation: If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value. — Fix: برای هر سه آرگومان مقدار عددی وارد کنید.

5. What is the fix for #VALUE! in =CONFIDENCE.T?

A. Volatile and recalculates every time
B. برای هر سه آرگومان مقدار عددی وارد کنید. ✓
C. Select entire column for best performance
D. Requires add-in

Explanation: If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value. — Fix: برای هر سه آرگومان مقدار عددی وارد کنید.

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

A. If size equals 1, CONFIDENCE.T returns #DIV/0! error value. ✓
B. یکی از آرگومان‌ها غیرعددی است.
C. Output is always a dynamic array
D. Only works in old versions

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

7. What is the type of argument “size” in =CONFIDENCE.T?

A. Number ✓
B. Date
C. Reference
D. Array

Explanation: Type of “size” is “Number”.

8. What is the type of argument “alpha” in =CONFIDENCE.T?

A. Logical
B. Date
C. Value
D. Number ✓

Explanation: Type of “alpha” is “Number”.

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

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

Explanation: CONFIDENCE.T does not spill.

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

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

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