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

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

Question 2 of 10 2/10

How many required arguments does =CONFIDENCE.NORM have?

Question 3 of 10 3/10

What is the output type of =CONFIDENCE.NORM?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which use case fits =CONFIDENCE.NORM?

Question 7 of 10 7/10

Which statement about =CONFIDENCE.NORM is correct?

Question 8 of 10 8/10

Which is the correct syntax of =CONFIDENCE.NORM?

Question 9 of 10 9/10

Which function is NOT related to =CONFIDENCE.NORM?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

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

2. How many required arguments does =CONFIDENCE.NORM have?

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

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

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

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

Explanation: Output is “Number”.

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

A. Text is always ignored
B. Correct the input 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

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

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

Explanation: Argument #3 is “size”.

6. Which use case fits =CONFIDENCE.NORM?

A. Data Cleaning
B. Sort, Filter & Dedupe
C. External Data, Web & Cube
D. Probability & Hypothesis Testing ✓

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

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

A. 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:
B. If size is not an integer, it is truncated. ✓
C. Text is always ignored
D. Only works in old versions

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

8. Which is the correct syntax of =CONFIDENCE.NORM?

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

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

9. Which function is NOT related to =CONFIDENCE.NORM?

A. CONFIDENCE-T
B. RANK ✓
C. STDEV-S
D. NORM-S-INV

Explanation: “RANK” is not related to CONFIDENCE.NORM.

10. Is argument “alpha” required in =CONFIDENCE.NORM?

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

Explanation: “alpha” is required.