Statistical =LINEST(known_y's, [known_x's], [const], [stats])

Quiz =LINEST — 10 Questions

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

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

← LINEST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =LINEST?

Question 2 of 10 2/10

What is the type of argument “known_x's” in =LINEST?

Question 3 of 10 3/10

Is argument “known_x's” required in =LINEST?

Question 4 of 10 4/10

Since which Excel version is =LINEST available?

Question 5 of 10 5/10

In =LINEST, which is argument #3?

Question 6 of 10 6/10

How many optional arguments does =LINEST have?

Question 7 of 10 7/10

Which statement about =LINEST is correct?

Question 8 of 10 8/10

What is the type of argument “stats” in =LINEST?

Question 9 of 10 9/10

How many arguments does =LINEST have in total?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. What is the output type of =LINEST?

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

Explanation: Output is “Array”.

2. What is the type of argument “known_x's” in =LINEST?

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

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

3. Is argument “known_x's” required in =LINEST?

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

Explanation: “known_x's” is optional.

4. Since which Excel version is =LINEST available?

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

Explanation: Version: “All versions”.

5. In =LINEST, which is argument #3?

A. known_y's
B. criteria
C. known_x's
D. const ✓

Explanation: Argument #3 is “const”.

6. How many optional arguments does =LINEST have?

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

Explanation: =LINEST has 1 required, 3 optional (4 total).

7. Which statement about =LINEST is correct?

A. The accuracy of the line calculated by the LINEST function depends on the degree of scatter in your data. The more linear the data, the more accurate the LINEST model. LINEST uses the method of least squares for determining the best fit for the data. When you have only one independent x-variable, the calculations for m and b are based on the following formulas: where x and y are sample means; that is, x = AVERAGE(known x's) and y = AVERAGE(known_y's⁠)⁠.
B. Output is always a dynamic array
C. You can describe any straight line with the slope and the y-intercept: Slope (m): To find the slope of a line, often written as m, take two points on the line, (x1,y1) and (x2,y2); the slope is equal to (y2 - y1)/(x2 - x1). Y-intercept (b): The y-intercept of a line, often written as b, is the value of y at the point where the line crosses the y-axis. The equation of a straight line is y = mx + b. Once you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function. ✓
D. The F-test value that is returned by the LINEST function differs from the F-test value that is returned by the FTEST function. LINEST returns the F statistic, whereas FTEST returns the probability.

Explanation: Correct: You can describe any straight line with the slope and the y-intercept: Slope (m): To find the slope of a line, often written as m, take two points on the line, (x1,y1) and (x2,y2); the slope is equal to (y2 - y1)/(x2 - x1). Y-intercept (b): The y-intercept of a line, often written as b, is the value of y at the point where the line crosses the y-axis. The equation of a straight line is y = mx + b. Once you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function.

8. What is the type of argument “stats” in =LINEST?

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

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

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

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

Explanation: =LINEST has 1 required, 3 optional (4 total).

10. What is the fix for #DIV/0! in =LINEST?

A. Output is always a dynamic array
B. Only works in old versions
C. اگر با SLOPE یا INTERCEPT خطای #DIV/0! گرفتید، بررسی کنید داده‌ها هم‌خط یا نامعین نباشند و در صورت نیاز از LINEST استفاده کنید. ✓
D. Volatile and recalculates every time

Explanation: SLOPE and INTERCEPT return a #DIV/0! error. — Fix: اگر با SLOPE یا INTERCEPT خطای #DIV/0! گرفتید، بررسی کنید داده‌ها هم‌خط یا نامعین نباشند و در صورت نیاز از LINEST استفاده کنید.