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

Quiz =CONFIDENCE.NORM — 10 Questions

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

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

← CONFIDENCE.NORM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =CONFIDENCE.NORM is correct?

Question 2 of 10 2/10

Which function is related to =CONFIDENCE.NORM?

Question 3 of 10 3/10

Since which Excel version is =CONFIDENCE.NORM available?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What is the output type of =CONFIDENCE.NORM?

Question 8 of 10 8/10

How many optional arguments does =CONFIDENCE.NORM have?

Question 9 of 10 9/10

Which category does =CONFIDENCE.NORM belong to?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which statement about =CONFIDENCE.NORM is correct?

A. If size is not an integer, it is truncated. ✓
B. Output is always a dynamic array
C. If we assume alpha equals 0.05, we need to calculate the area under the standard normal curve that equals (1 - alpha), or 95 percent. This value is ± 1.96. The confidence interval is therefore:
D. Only works in old versions

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

2. Which function is related to =CONFIDENCE.NORM?

A. STDEV-S ✓
B. DEGREES
C. SLN
D. NORM.INV

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

3. Since which Excel version is =CONFIDENCE.NORM available?

A. Excel 365
B. All versions
C. Excel 2010 ✓
D. Excel 2019

Explanation: Version: “Excel 2010”.

4. Is argument “standard_dev” required in =CONFIDENCE.NORM?

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

Explanation: “standard_dev” is required.

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

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

Explanation: Argument #2 is “standard_dev”.

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

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

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

7. What is the output type of =CONFIDENCE.NORM?

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

Explanation: Output is “Number”.

8. How many optional arguments does =CONFIDENCE.NORM have?

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

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

9. Which category does =CONFIDENCE.NORM belong to?

A. Text
B. Compatibility
C. Engineering
D. Statistical ✓

Explanation: Category is “Statistical”.

10. What usually causes #NUM! in =CONFIDENCE.NORM?

A. Requires add-in
B. If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.NORM returns the #NUM! error value. If standard_dev ≤ 0, CONFIDENCE.NORM returns the #NUM! error value. If size < 1, CONFIDENCE.NORM returns the #NUM! error value. ✓
C. Select entire column for best performance
D. Output is always a dynamic array

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