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

            Bug ID: 86409
           Summary: Clarification about mean of f(x)
           Product: LibreOffice
           Version: 4.2.7.2 rc
          Hardware: Other
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

I'd like a clarification of this comportment:

In this example     
    x    mean(x)    f(x)    mean f(x)
A    2        6    
B    2    2    6    6
C    2        6    

mean(x) is the arithmetic mean of A,B and C value of x
f(x) is A,B or C *3 and
mean f(x) is the arithmetic mean of A,B and C value of f(x)

If B value of x is 0 correctly:
    x    mean(x)    f(x)    mean f(x)
A    2        6    
B    0    1,33    0    4
C    2        6    

If I remove B value of x I expected this:
    x    mean(x)    f(x)    mean f(x)
A    2        6    
B        2        6
C    2        6    

But happens this:
    x    mean(x)    f(x)    mean f(x)
A    2        6    
B        2    0    4
C    2        6    

Is it a bug? Or is it expected?

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to