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

How many arguments does =WEIBULL have in total?

Question 2 of 15 2/15

Which function is NOT related to =WEIBULL?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

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

Question 5 of 15 5/15

In =WEIBULL, which is argument #1?

Question 6 of 15 6/15

Is argument “x” required in =WEIBULL?

Question 7 of 15 7/15

What usually causes #VALUE! in =WEIBULL?

Question 8 of 15 8/15

Which function is related to =WEIBULL?

Question 9 of 15 9/15

Is argument “cumulative” required in =WEIBULL?

Question 10 of 15 10/15

Is argument “beta” required in =WEIBULL?

Question 11 of 15 11/15

How many required arguments does =WEIBULL have?

Question 12 of 15 12/15

Which statement about =WEIBULL is correct?

Question 13 of 15 13/15

In =WEIBULL, which is argument #2?

Question 14 of 15 14/15

How many optional arguments does =WEIBULL have?

Question 15 of 15 15/15

What is the output type of =WEIBULL?

Click a question to see the answer.

1. How many arguments does =WEIBULL have in total?

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

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

2. Which function is NOT related to =WEIBULL?

A. PERCENTILE
B. RANDBETWEEN ✓
C. FORECAST
D. MODE

Explanation: “RANDBETWEEN” is not related to WEIBULL.

3. What is the fix for #NUM! in =WEIBULL?

A. Enter allowed values ✓
B. Text is always ignored
C. Volatile and recalculates every time
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

4. What is the type of argument “alpha” in =WEIBULL?

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

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

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

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

Explanation: Argument #1 is “x”.

6. Is argument “x” required in =WEIBULL?

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

Explanation: “x” is required.

7. What usually causes #VALUE! in =WEIBULL?

A. Requires add-in
B. If x, alpha, or beta is nonnumeric, WEIBULL returns the #VALUE! error value. ✓
C. مقدار x کوچک‌تر از صفر است یا alpha یا beta کوچک‌تر یا مساوی صفر هستند.
D. Select entire column for best performance

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

8. Which function is related to =WEIBULL?

A. FORECAST ✓
B. EOMONTH
C. ERF.PRECISE
D. MIN

Explanation: “FORECAST” is related to WEIBULL.

9. Is argument “cumulative” required in =WEIBULL?

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

Explanation: “cumulative” is required.

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

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

Explanation: “beta” is required.

11. How many required arguments does =WEIBULL have?

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

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

12. Which statement about =WEIBULL is correct?

A. 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. ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
D. The equation for the Weibull probability density function is:

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.

13. In =WEIBULL, which is argument #2?

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

Explanation: Argument #2 is “alpha”.

14. How many optional arguments does =WEIBULL have?

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

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

15. What is the output type of =WEIBULL?

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

Explanation: Output is “Number”.