Compatibility =WEIBULL(x,alpha,beta,cumulative)

Quiz =WEIBULL — 15 Questions

15 quiz questions about =WEIBULL — test syntax, arguments, examples & errors!

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

← WEIBULL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “cumulative” in =WEIBULL?

Question 2 of 15 2/15

Which statement about =WEIBULL is correct?

Question 3 of 15 3/15

Is argument “alpha” required in =WEIBULL?

Question 4 of 15 4/15

In =WEIBULL, which is argument #3?

Question 5 of 15 5/15

How many optional arguments does =WEIBULL have?

Question 6 of 15 6/15

Since which Excel version is =WEIBULL available?

Question 7 of 15 7/15

Does =WEIBULL return a dynamic array?

Question 8 of 15 8/15

Is argument “beta” required in =WEIBULL?

Question 9 of 15 9/15

What is the fix for #VALUE! in =WEIBULL?

Question 10 of 15 10/15

What is the output type of =WEIBULL?

Question 11 of 15 11/15

Which function is related to =WEIBULL?

Question 12 of 15 12/15

What usually causes #NUM! in =WEIBULL?

Question 13 of 15 13/15

Is =WEIBULL volatile?

Question 14 of 15 14/15

How many required arguments does =WEIBULL have?

Question 15 of 15 15/15

In =WEIBULL, which is argument #1?

Click a question to see the answer.

1. What is the type of argument “cumulative” in =WEIBULL?

A. Logical ✓
B. Text
C. Array
D. Value

Explanation: Type of “cumulative” is “Logical”.

2. Which statement about =WEIBULL is correct?

A. Only works in old versions
B. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new function, see WEIBULL.DIST function. ✓
C. The equation for the Weibull probability density function is:
D. Requires add-in

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new function, see WEIBULL.DIST function.

3. Is argument “alpha” required in =WEIBULL?

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

Explanation: “alpha” is required.

4. In =WEIBULL, which is argument #3?

A. beta ✓
B. cumulative
C. lookup_value
D. range

Explanation: Argument #3 is “beta”.

5. How many optional arguments does =WEIBULL have?

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

Explanation: =WEIBULL has 4 required, 0 optional (4 total).

6. Since which Excel version is =WEIBULL available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

7. Does =WEIBULL return a dynamic array?

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

Explanation: WEIBULL does not spill.

8. Is argument “beta” required in =WEIBULL?

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

Explanation: “beta” is required.

9. What is the fix for #VALUE! in =WEIBULL?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. Only works in old versions
D. برای x و alpha و beta مقادیر عددی وارد کنید و بررسی کنید سلول مرجع خالی یا متنی نباشد. ✓

Explanation: If x, alpha, or beta is nonnumeric, WEIBULL returns the #VALUE! error value. — Fix: برای x و alpha و beta مقادیر عددی وارد کنید و بررسی کنید سلول مرجع خالی یا متنی نباشد.

10. What is the output type of =WEIBULL?

A. Number ✓
B. Mixed
C. Logical
D. Array

Explanation: Output is “Number”.

11. Which function is related to =WEIBULL?

A. AVERAGE
B. PDURATION
C. FORECAST ✓
D. WEIBULL

Explanation: “FORECAST” is related to WEIBULL.

12. What usually causes #NUM! in =WEIBULL?

A. Requires add-in
B. Text is always ignored
C. If x < 0, WEIBULL returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, WEIBULL returns the #NUM! error value. ✓
D. Output is always a dynamic array

Explanation: If x < 0, WEIBULL returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, WEIBULL returns the #NUM! error value. — Fix: Enter allowed values

13. Is =WEIBULL volatile?

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

Explanation: WEIBULL is not volatile.

14. How many required arguments does =WEIBULL have?

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

Explanation: =WEIBULL has 4 required, 0 optional (4 total).

15. In =WEIBULL, which is argument #1?

A. value
B. x ✓
C. lookup_value
D. beta

Explanation: Argument #1 is “x”.