LINEST

Hi,

    
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 5.1.6.2 appears to use column major order
      instead.

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

    
Andreas

    

    
-- 

      

        

          

            

              

                
                  
                    

                       
                        
                          
                            

                              
                                

                                  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.ab.ca
                                

                              
                            

                            

                              
                                

                                     

                              
                            

                          
                        
                      
                    

                  
                
              

            

          

        

      

    

  

Attachment:
LINEST-changes.odt

Description: application/vnd.oasis.opendocument.text