Bug 105032 - EDITING ENHANCEMENT Add an alias function "mean" for "average"
Summary: EDITING ENHANCEMENT Add an alias function "mean" for "average"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsDevAdvice
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2017-01-01 18:00 UTC by jpeacock29
Modified: 2017-07-23 22:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description jpeacock29 2017-01-01 18:00:04 UTC
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:

Actual Results:  

Expected Results:

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.