Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-1132 Public Comment: [office-formula] problems with some functions, most statistical
  3. OFFICE-2290

INTERCEPT

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 2
    • Component/s: OpenFormula
    • Labels:
      None
    • Resolution:
      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()).

      Description

      == 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.

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: