Bug 160835 - Unclear meaning of "a basic total population"
Summary: Unclear meaning of "a basic total population"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Wizard
  Show dependency treegraph
 
Reported: 2024-04-26 18:22 UTC by Tuomas Hietala
Modified: 2024-05-13 02:23 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc functions in UI and Help (183.29 KB, image/png)
2024-04-27 16:37 UTC, nutka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tuomas Hietala 2024-04-26 18:22:36 UTC
Description:
In Calc, there's the following UI string: "Value 1; value 2; ... are arguments representing a sample taken from a basic total population."

I have no idea what the expression "a basic total population" means. Nothing seems to come up on a web or Wikipedia search. I assume this is a mistake of some kind, perhaps a mistranslation from another language?

Steps to Reproduce:
1. The string on Weblate: https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/en/?checksum=56d94ade7c12a99c


Actual Results:
The string is confusing.

Expected Results:
The string is using generally accepted English statistics terminology.


Reproducible: Always


User Profile Reset: No

Additional Info:
n/a
Comment 1 Tuomas Hietala 2024-04-26 18:34:54 UTC
Correction: the same string appears in two other places, too:
https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/en/?q=a+basic+total+population&sort_by=-priority%2Cposition&checksum=
Comment 3 Tuomas Hietala 2024-04-26 19:38:21 UTC
(In reply to ady from comment #2)
> <https://en.wikipedia.org/wiki/Statistical_population>

Yes, I know what "population" means in statistics. What I don't know is what "basic total population" is supposed to mean.
Comment 4 ady 2024-04-26 21:50:44 UTC
IMHO, it would help if you could link to the actual Help content (i.e. function) we are talking about. I mean that "Value 1; value 2; ... are arguments representing a sample taken from a basic total population" sounds as the description of a "ValueN" argument of some specific Calc function, probably part of the Statistical Category of functions.
Comment 5 nutka 2024-04-27 16:35:57 UTC
Calc functions: AVERAGEA, STDEVA and VARA - cf. the attached juxtaposition (UI vs Help).
Comment 6 nutka 2024-04-27 16:37:14 UTC
Created attachment 193879 [details]
Calc functions in UI and Help
Comment 7 Stéphane Guillou (stragu) 2024-05-13 02:23:40 UTC
Rafael, what do you think? I feel like this could be simplified to just "population".

The string exists in OOo 3.3, but doesn't mean anything to me either, and an online search seems to confirms that it does not have any special meaning in stats.

Elsewhere:
- MS Excel uses "a sample of a population"[1][2].
- Google Docs only says it's a sample without having to mention "from a population". (Only uses "population" to refer to other functions that consider the whole population instead of a sample.)[2]

[1]: https://support.microsoft.com/en-us/office/stdeva-function-5ff38888-7ea5-48de-9a6d-11ed73b29e9d
[2]: https://support.microsoft.com/en-us/office/vara-function-3de77469-fa3a-47b4-85fd-81758a1e1d07
[3]: https://support.google.com/docs/answer/3094055