Talk:Documentation/Calc Functions/INTERCEPT

    From The Document Foundation Wiki

    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)