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

Quiz =WEIBULL — 10 Questions

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

Question 1 of 10 1/10

Which use case fits =WEIBULL?

Question 2 of 10 2/10

Which statement about =WEIBULL is correct?

Question 3 of 10 3/10

What is the output type of =WEIBULL?

Question 4 of 10 4/10

How many optional arguments does =WEIBULL have?

Question 5 of 10 5/10

Is argument “x” required in =WEIBULL?

Question 6 of 10 6/10

Which is the correct syntax of =WEIBULL?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Since which Excel version is =WEIBULL available?

Question 9 of 10 9/10

Which function is related to =WEIBULL?

Question 10 of 10 10/10

Which function is NOT related to =WEIBULL?

Click a question to see the answer.

1. Which use case fits =WEIBULL?

A. Text Manipulation
B. Securities & Bonds
C. Reshape Tables
D. Reporting ✓

Explanation: Use case “Reporting” fits WEIBULL.

2. Which statement about =WEIBULL is correct?

A. Select entire column for best performance
B. The equation for the Weibull probability density function is:
C. 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. ✓
D. When alpha = 1, WEIBULL returns the exponential distribution with:

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. What is the output type of =WEIBULL?

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

Explanation: Output is “Number”.

4. How many optional arguments does =WEIBULL have?

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

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

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

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

Explanation: “x” is required.

6. Which is the correct syntax of =WEIBULL?

A. WEIBULL(x,alpha,beta,cumulative)
B. =WEIBULL(x,alpha,beta,cumulative, 0)
C. =FORECAST(x,alpha,beta,cumulative)
D. =WEIBULL(x,alpha,beta,cumulative) ✓

Explanation: Correct syntax: =WEIBULL(x,alpha,beta,cumulative)

7. What is the type of argument “x” in =WEIBULL?

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

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

8. Since which Excel version is =WEIBULL available?

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

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

9. Which function is related to =WEIBULL?

A. FORECAST ✓
B. ISPMT
C. YEAR
D. SQRTPI

Explanation: “FORECAST” is related to WEIBULL.

10. Which function is NOT related to =WEIBULL?

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

Explanation: “PI” is not related to WEIBULL.