Bug 105032

Summary:	EDITING ENHANCEMENT Add an alias function "mean" for "average"
Product:	LibreOffice	Reporter:	jpeacock29
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	heiko.tietze
Priority:	medium	Keywords:	needsDevAdvice
Version:	3.3.0 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=71111 https://bugs.documentfoundation.org/show_bug.cgi?id=86645
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108827

Description jpeacock29 2017-01-01 18:00:04 UTC

Description:
Much common statistical software uses the name `mean` rather than `average` for the function that returns a arithmetic mean of a collection of numbers (eg, STATA, R, Mathematica). To make using LibreOffice Calc easier for users of other statistical software, I propose adding an alias `mean` for the `average` function. In this way, users could type either `mean()` or `average()` for the same results.

Steps to Reproduce:
Enhancement

Actual Results:  
Enhancement

Expected Results:
Enhancement


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0

Comment 1 Heiko Tietze 2017-01-08 10:17:47 UTC

Sounds reasonable since in bug 86645 harmean() and geomean() is requested not haravg(). There is also a confusion with pivot table labels in bug 71111.