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

Quiz =CONFIDENCE.T — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Which use case fits =CONFIDENCE.T?

Question 3 of 15 3/15

Which function is related to =CONFIDENCE.T?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Does =CONFIDENCE.T return a dynamic array?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

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

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Which statement about =CONFIDENCE.T is correct?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What is the output type of =CONFIDENCE.T?

Question 13 of 15 13/15

How many arguments does =CONFIDENCE.T have in total?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which function is NOT related to =CONFIDENCE.T?

Click a question to see the answer.

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

A. Output is always a dynamic array
B. Requires add-in
C. Select entire column for best performance
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. Which use case fits =CONFIDENCE.T?

A. Dynamic Ranges & Dashboards
B. Conditional Aggregation
C. Daily Tasks
D. Probability & Hypothesis Testing ✓

Explanation: Use case “Probability & Hypothesis Testing” fits CONFIDENCE.T.

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

A. NPER
B. STDEV-S ✓
C. DEVSQ
D. BAHTTEXT

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

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

A. If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value. ✓
B. Volatile and recalculates every time
C. Requires add-in
D. Output is always a dynamic array

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

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

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

Explanation: CONFIDENCE.T does not spill.

6. In =CONFIDENCE.T, which is argument #1?

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

Explanation: Argument #1 is “alpha”.

7. Is argument “alpha” required in =CONFIDENCE.T?

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

Explanation: “alpha” is required.

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

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

9. Which statement about =CONFIDENCE.T is correct?

A. Requires add-in
B. If size is not an integer, it is truncated. ✓
C. Select entire column for best performance
D. Text is always ignored

Explanation: Correct: If size is not an integer, it is truncated.

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

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

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

11. What usually causes #NUM! in =CONFIDENCE.T?

A. If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value. If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Requires add-in
D. حجم نمونه برابر ‎۱ است.

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

12. What is the output type of =CONFIDENCE.T?

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

Explanation: Output is “Number”.

13. How many arguments does =CONFIDENCE.T have in total?

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

Explanation: =CONFIDENCE.T has 3 required, 0 optional (3 total).

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

A. standard_dev ✓
B. range
C. lookup_value
D. criteria

Explanation: Argument #2 is “standard_dev”.

15. Which function is NOT related to =CONFIDENCE.T?

A. STDEV-S
B. WORKDAY.INTL ✓
C. CONFIDENCE-NORM
D. T-INV-2T

Explanation: “WORKDAY.INTL” is not related to CONFIDENCE.T.