Talk:Documentation/Calc Functions/INTERCEPT

SF Comments

 * (1) Summary. Suggest insert “regression” before “line”. Should first occurrence of “y-values” be changed to “y-axis”?
 * (2) Arguments, 1st bullet. The statement “Numbers can also be entered directly” warrants clarification. Explain that you are referring to entering an argument as a list of values enclosed in curly braces { and }.
 * (3) Arguments, 2nd bullet. Can I suggest the following potentially simpler text – “The function ignores any cell that is empty, contains text or contains a logical value”? However please could you check whether it really does ignore logical values of TRUE and FALSE (I suspect that it converts them to 1 and 0 respectively). Perhaps also worth mentioning that when a cell is ignored, corresponding X and Y values are ignored?
 * (4) Arguments, 3rd bullet. Suggest change “has” to “contains” and “considers” to “includes”.
 * (5) Arguments, 4th bullet. Change “If length of DataX and DataY is not” to “If the dimensions of DataX and DataY are not the”.
 * (6) Additional details, 1st sentence. Change “is” to “calculates the”.
 * (7) Additional details. Would it be worth including a link to the Wikipedia page entitled “Simple linear regression”?
 * (8) Examples, 1st example. Error in formula – should be “B1:B6”
 * (9) Examples. “parameter” spelt incorrectly (two occurrences).

--Stevefanning (talk) 2020-10-24T10:12:12 (UTC)

Ronnie
all points addressed.

--Ronnie rg8888 (talk) 2020-11-15T21:26:22 (UTC)