[Libreoffice-bugs] [Bug 47403] New: Let COVAR calculate sample covariance and add COVARP

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=47403

             Bug #: 47403
           Summary: Let COVAR calculate sample covariance and add COVARP
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.2 release
          Platform: x86-64 (AMD64)
               URL: http://en.wikipedia.org/wiki/Sample_mean_and_sample_co
                    variance#Sample_mean_and_covariance
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: giecrilj at stegny.2a.pl


The current implementation of COVAR fulfills the following identity:

  COVAR (R, R) = VARP (R)

This is obviously inconsistent.  Also, there is no version of COVAR to be equal
to VAR in the same way.

Suggestion:

  1. Redefine COVAR so that COVAR (R, R) = VAR (R).
  2. Provide COVARP so that COVARP (R, R) = VARP (R).

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.