OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: LINEST


I was asked to review the LINEST description with a special view of the correct use of the subscripts. I have attached the changes as an odf file containing the LINEST description with the required changes. I have enabled track changes so that the changes are easier viewable.

I have made one, likely controversial, change:

knownX is optional and we currently just say that by default it is the sequence 1 through k. Since knownX has to be a correctly sized array for the rest of the description to make sense, there are two natural possibilities: the entries could be given in column-major or row-major order. I have specified them as row-major. That is what Excel 2016 and Gnumeric  1.12.40 are doing. Libreoffice appears to use column major order instead.

Alternatively we could specify "column-major or row-major order with the choice being implementation defined".



Andreas J. Guelzow, PhD FTICA

Registrar & Director of Enrolment Services

Professor, Mathematical & Computing Sciences

Direct: +1 780 479 9290
Toll-Free: +1 866 479 5200

Concordia University of


Concordia University of
                                      Edmonton Twitter Concordia University of
                                      Edmonton Instagram Concordia University of
                                      Edmonton Facebook

Attachment: LINEST-changes.odt
Description: application/vnd.oasis.opendocument.text

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]