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)