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

Quiz =LINEST — 15 Questions

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

Question 1 of 15 1/15

Since which Excel version is =LINEST available?

Question 2 of 15 2/15

Is argument “const” required in =LINEST?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Does =LINEST return a dynamic array?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What is the output type of =LINEST?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which statement about =LINEST is correct?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which formula is a valid example of =LINEST?

Question 11 of 15 11/15

How many optional arguments does =LINEST have?

Question 12 of 15 12/15

In =LINEST, which is argument #1?

Question 13 of 15 13/15

How many required arguments does =LINEST have?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Which function is related to =LINEST?

Click a question to see the answer.

1. Since which Excel version is =LINEST available?

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

Explanation: Version: “All versions”.

2. Is argument “const” required in =LINEST?

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

Explanation: “const” is optional.

3. What is the type of argument “known_y's” in =LINEST?

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

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

4. Does =LINEST return a dynamic array?

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

Explanation: LINEST does not spill.

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

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Requires add-in
D. اگر با SLOPE یا INTERCEPT خطای #DIV/0! گرفتید، بررسی کنید داده‌ها هم‌خط یا نامعین نباشند و در صورت نیاز از LINEST استفاده کنید. ✓

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

6. What is the output type of =LINEST?

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

Explanation: Output is “Array”.

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

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

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

8. Which statement about =LINEST is correct?

A. 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. ✓
B. In regression analysis, Excel calculates for each point the squared difference between the y-value estimated for that point and its actual y-value. The sum of these squared differences is called the residual sum of squares, ssresid. Excel then calculates the total sum of squares, sstotal. When the const argument = TRUE or is omitted, the total sum of squares is the sum of the squared differences between the actual y-values and the average of the y-values. When the const argument = FALSE, the total sum of squares is the sum of the squares of the actual y-values (without subtracting the average y-value from each individual y-value). Then regression sum of squares, ssreg, can be found from: ssreg = sstotal - ssresid. The smaller the residual sum of squares is, compared with the total sum of squares, the larger the value of the coefficient of determination, r2, which is an indicator of how well the equation resulting from the regression analysis explains the relationship among the variables. The value of r2 equals ssreg/sstotal.
C. Volatile and recalculates every time
D. In some cases, one or more of the X columns (assume that Y’s and X’s are in columns) may have no additional predictive value in the presence of the other X columns. In other words, eliminating one or more X columns might lead to predicted Y values that are equally accurate. In that case these redundant X columns should be omitted from the regression model. This phenomenon is called “collinearity” because any redundant X column can be expressed as a sum of multiples of the non-redundant X columns. The LINEST function checks for collinearity and removes any redundant X columns from the regression model when it identifies them. Removed X columns can be recognized in LINEST output as having 0 coefficients in addition to 0 se values. If one or more columns are removed as redundant, df is affected because df depends on the number of X columns actually used for predictive purposes. For details on the computation of df, see Example 4. If df is changed because redundant X columns are removed, values of sey and F are also affected. Collinearity should be relatively rare in practice. However, one case where it is more likely to arise is when some X columns contain only 0 and 1 values as indicators of whether a subject in an experiment is or is not a member of a particular group. If const = TRUE or is omitted, the LINEST function effectively inserts an additional X column of all 1 values to model the intercept. If you have a column with a 1 for each subject if male, or 0 if not, and you also have a column with a 1 for each subject if female, or 0 if not, this latter column is redundant because entries in it can be obtained from subtracting the entry in the “male indicator” column from the entry in the additional column of all 1 values added by the LINEST function.

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.

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

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

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

10. Which formula is a valid example of =LINEST?

A. =SUM(LINEST(B1:B6, A1:A6)*{9,1}) ✓
B. =SUM(LINEST(B1:B6, A1:A6)*{9,1}, 0)
C. =SUM(INDEX(B1:B6, A1:A6)*{9,1})
D. SUM(LINEST(B1:B6, A1:A6)*{9,1})

Explanation: Correct example: =SUM(LINEST(B1:B6, A1:A6)*{9,1})

11. How many optional arguments does =LINEST have?

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

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

12. In =LINEST, which is argument #1?

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

Explanation: Argument #1 is “known_y's”.

13. How many required arguments does =LINEST have?

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

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

14. Is argument “known_y's” required in =LINEST?

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

Explanation: “known_y's” is required.

15. Which function is related to =LINEST?

A. GCD
B. ASIN
C. INDEX ✓
D. FVSCHEDULE

Explanation: “INDEX” is related to LINEST.