Bug 86645 - Data Analysis Toolkit - Descriptive Statistics : Add Geometric mean,Harmonic mean etc
Data Analysis Toolkit - Descriptive Statistics : Add Geometric mean,Harmonic ...
 Status: NEW None LibreOffice Unclassified Calc (show other bugs) unspecified Other All medium enhancement Not Assigned Data-Statistics Show dependency tree / graph

 Reported: 2014-11-24 00:58 UTC by zaxebo zaxebo 2017-11-28 06:08 UTC (History) 3 users (show) jmadero.dev quikee suokunlong

Attachments

 Note You need to log in before you can comment on or make changes to this bug.
 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"``` zaxebo zaxebo 2014-11-24 01:13:03 UTC ```interquartile range(IQR) means quartile3 - quartile 1 http://en.wikipedia.org/wiki/Interquartile_range``` 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``` zaxebo zaxebo 2014-11-24 01:20:28 UTC ```Trimean http://en.wikipedia.org/wiki/Trimean``` 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```