• Hide

      Change the description of 5.18.38 INTERCEPT to:

      Summary: Returns the y-intercept of the linear regression line for the given data.
      Syntax: INTERCEPT( ForceArray NumberSequence Data_Y ; ForceArray NumberSequence
      Data_X )
      Returns: Number
      Constraints: COLUMNS(DATA_X) = COLUMNS(DATA_Y), ROWS(DATA_X) = ROWS(DATA_Y), COUNT(DATA_X)=COUNT(DATA_Y)
      Semantics:
      INTERCEPT returns the intercept (a) calculated as described in 5.18.41for the function call LINEST(DATA_Y,DATA_X,FALSE()).

      Show
      Change the description of 5.18.38 INTERCEPT to: Summary: Returns the y-intercept of the linear regression line for the given data. Syntax: INTERCEPT( ForceArray NumberSequence Data_Y ; ForceArray NumberSequence Data_X ) Returns: Number Constraints: COLUMNS(DATA_X) = COLUMNS(DATA_Y), ROWS(DATA_X) = ROWS(DATA_Y), COUNT(DATA_X)=COUNT(DATA_Y) Semantics: INTERCEPT returns the intercept (a) calculated as described in 5.18.41for the function call LINEST(DATA_Y,DATA_X,FALSE()).

      == 6.17.37 INTERCEPT ==

      Only some editorial remarks to the text "Calculates the point at which a
      line will intersect the y-values by using known x-values and y-values."
      1. It calculates no point but a single value. 2. The line does not
      intersect the y-values but the y-axis. 3. It does not say, that the line
      is the linear regression of the known values.

            Assignee:
            Andreas Guelzow (Inactive)
            Reporter:
            Robert Weir (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: