Bug 86645 - Data Analysis Toolkit - Descriptive Statistics : Add Geometric mean,Harmonic mean etc
Summary: Data Analysis Toolkit - Descriptive Statistics : Add Geometric mean,Harmonic ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Statistics
  Show dependency treegraph
 
Reported: 2014-11-24 00:58 UTC by zaxebo zaxebo
Modified: 2017-11-28 06:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description zaxebo zaxebo 2014-11-24 00:58:05 UTC
in Data->Statistics->Descriptive statistics add the following fields too:

A) Gemetric mean
=geomean(myrange)
refer
https://help.libreoffice.org/Calc/Statistical_Functions_Part_Two#GEOMEAN

B) Harmonic mean
=harmean(myrange)
https://help.libreoffice.org/Calc/Statistical_Functions_Part_Two#HARMEAN

C) 10% TrimMean, 20% TrimMean
10% trimmean
  =TRIMMEAN(myrange, 0.1)
20% trimmean
  =TRIMMEAN(myrange, 0.2)
refer:
https://help.libreoffice.org/Calc/Statistical_Functions_Part_Two#TRIMMEAN

D)
also, just below the "range" field in descriptive statistics; please add "interquartile range"
Comment 1 zaxebo zaxebo 2014-11-24 01:13:03 UTC
interquartile range(IQR) means quartile3 - quartile 1
http://en.wikipedia.org/wiki/Interquartile_range
Comment 2 zaxebo zaxebo 2014-11-24 01:15:42 UTC
midhinge is the average of the first and third quartiles and is thus a measure of location.
http://en.wikipedia.org/wiki/Midhinge
Comment 3 zaxebo zaxebo 2014-11-24 01:20:28 UTC
Trimean
http://en.wikipedia.org/wiki/Trimean
Comment 4 Joel Madero 2014-11-25 16:03:05 UTC
Thank you for reporting this enhancement request! I can confirm that this is a valid enhancement request on:
Version: 4.3.2.2 release
Platform: Ubuntu Linux 14.10 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm the enhancement request I am marking as:

New (confirmed)
Enhancement

Note: This only confirms that it is a valid enhancement request and in no way guarantees that the enhancement will be implemented. Enhancements are completed by volunteers who implement it if they themselves want to. That being said we provide no guarantee or ETA.

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
Feel free to come say hi to QA at http://webchat.freenode.net/?channels=libreoffice-qa

LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free.

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material