[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2290) INTERCEPT
[ http://tools.oasis-open.org/issues/browse/OFFICE-2290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andreas Guelzow updated OFFICE-2290: ------------------------------------- Resolution: 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()). was: 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: 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()). > INTERCEPT > --------- > > Key: OFFICE-2290 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-2290 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Sub-task > Components: OpenFormula > Reporter: Robert Weir > Assignee: Andreas Guelzow > Fix For: ODF 1.2 Part 2 CD 2 > > > == 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]