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

Quiz =RSQ — 10 Questions

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

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

← RSQ ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

What is the fix for #DIV/0! in =RSQ?

Question 3 of 10 3/10

Which is the correct syntax of =RSQ?

Question 4 of 10 4/10

Is =RSQ volatile?

Question 5 of 10 5/10

Which statement about =RSQ is correct?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is NOT related to =RSQ?

Question 8 of 10 8/10

What is the fix for #N/A in =RSQ?

Question 9 of 10 9/10

How many arguments does =RSQ have in total?

Question 10 of 10 10/10

How many required arguments does =RSQ have?

Click a question to see the answer.

1. Is argument “known_y's” required in =RSQ?

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

Explanation: “known_y's” is required.

2. What is the fix for #DIV/0! in =RSQ?

A. Only works in old versions
B. Requires add-in
C. اگر known_y's و known_x's خالی باشند یا تعداد نقاط داده متفاوتی داشته باشند، تابع RSQ خطای #N/A را برمی‌گرداند.
D. حداقل دو نقطه داده در هر محدوده وارد کنید تا محاسبه همبستگی ممکن باشد. ✓

Explanation: If known_y's and known_x's contain only 1 data point, RSQ returns the #DIV/0! error value. — Fix: حداقل دو نقطه داده در هر محدوده وارد کنید تا محاسبه همبستگی ممکن باشد.

3. Which is the correct syntax of =RSQ?

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

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

4. Is =RSQ volatile?

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

Explanation: RSQ is not volatile.

5. Which statement about =RSQ is correct?

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Arguments that are error values or text that cannot be translated into numbers cause errors.
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.

6. What is the type of argument “known_y's” in =RSQ?

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

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

7. Which function is NOT related to =RSQ?

A. NPV ✓
B. CORREL
C. SLOPE
D. FORECAST-LINEAR

Explanation: “NPV” is not related to RSQ.

8. What is the fix for #N/A in =RSQ?

A. Only works in old versions
B. Select entire column for best performance
C. Make the two ranges the same size ✓
D. اگر known_y's و known_x's فقط یک نقطه داده داشته باشند، تابع RSQ خطای #DIV/0! را برمی‌گرداند.

Explanation: If known_y's and known_x's are empty or have a different number of data points, RSQ returns the #N/A error value. — Fix: Make the two ranges the same size

9. How many arguments does =RSQ have in total?

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

Explanation: =RSQ has 2 required, 0 optional (2 total).

10. How many required arguments does =RSQ have?

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

Explanation: =RSQ has 2 required, 0 optional (2 total).