Statistical =STEYX(known_y's, known_x's)

Quiz =STEYX — 10 Questions

10 quiz questions about =STEYX — test syntax, arguments, examples & errors!

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

← STEYX ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =STEYX available?

Question 2 of 10 2/10

Which category does =STEYX belong to?

Question 3 of 10 3/10

Is argument “known_y's” required in =STEYX?

Question 4 of 10 4/10

What is the type of argument “known_y's” in =STEYX?

Question 5 of 10 5/10

Which is the correct syntax of =STEYX?

Question 6 of 10 6/10

Which statement about =STEYX is correct?

Question 7 of 10 7/10

Which use case fits =STEYX?

Question 8 of 10 8/10

Which function is NOT related to =STEYX?

Question 9 of 10 9/10

Does =STEYX return a dynamic array?

Question 10 of 10 10/10

What usually causes #DIV/0! in =STEYX?

Click a question to see the answer.

1. Since which Excel version is =STEYX available?

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

Explanation: Version: “All versions”.

2. Which category does =STEYX belong to?

A. Lookup & Reference
B. Date & Time
C. Information
D. Statistical ✓

Explanation: Category is “Statistical”.

3. Is argument “known_y's” required in =STEYX?

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

Explanation: “known_y's” is required.

4. What is the type of argument “known_y's” in =STEYX?

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

Explanation: Type of “known_y's” is “Range”.

5. Which is the correct syntax of =STEYX?

A. =STEYX(known_y's, known_x's) ✓
B. =STEYX(known_y's, known_x's, 0)
C. STEYX(known_y's, known_x's)
D. =FORECAST-LINEAR(known_y's, known_x's)

Explanation: Correct syntax: =STEYX(known_y's, known_x's)

6. Which statement about =STEYX is correct?

A. The equation for the standard error of the predicted y is: where x and y are the sample means AVERAGE(known_x’s) and AVERAGE(known_y’s), and n is the sample size.
B. Requires add-in
C. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
D. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

7. Which use case fits =STEYX?

A. Reshape Tables
B. Rounding & Numeric
C. Error Handling
D. Forecasting & Trends ✓

Explanation: Use case “Forecasting & Trends” fits STEYX.

8. Which function is NOT related to =STEYX?

A. INTERCEPT ✓
B. LINEST
C. FORECAST-LINEAR
D. RSQ

Explanation: “INTERCEPT” is not related to STEYX.

9. Does =STEYX return a dynamic array?

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

Explanation: STEYX does not spill.

10. What usually causes #DIV/0! in =STEYX?

A. Text is always ignored
B. If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value. ✓
C. Requires add-in
D. اگر known_y's و known_x's تعداد نقاط داده متفاوتی داشته باشند، تابع STEYX خطای #N/A را برمی‌گرداند.

Explanation: If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value. — Fix: حداقل سه جفت نقطه داده معتبر در هر دو محدوده وارد کنید و سلول‌های خالی را پر کنید.