https://bugs.documentfoundation.org/show_bug.cgi?id=166665
Bug ID: 166665
Summary: Error in the statistic file provided in the
documentation
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The dataset and the analysis to demonstrate how to perform ANOVA in Calc are
contained in the following link:
Link 1:
https://help.libreoffice.org/latest/en-US/text/scalc/01/statistics_anova.html
On that webpage, a file is offered, which is located at the following link:
Link 2:
https://help.libreoffice.org/latest/media/files/scalc/statistics_data.ods
The problem is that both the dataset and the analysis in the provided file are
different from those shown on the website.
The file is wrong, the website is right.
What is wrong with the file?
The ANOVA tab has a dataset (B3:D15). For some reason, the last number of the
'Maths' column is not a number but a text. You can confirm this by seeing how
many numbers are counted in G6:G9. The last number (B15) is formatted as text.
And because of that, the whole ANOVA analysis is wrong. (Also, for some reason,
there is a space in that column as well (B8), although this is not relevant for
the analysis at this stage).
The dataset is correctly shown on the website (link 1). If you edit the
statistics_data.ods file and change cell B15 to a number, then the 'ANOVA -
Single Factor' output (F3:L14) is updated and shows correct results, which are
the same as on the website.
Steps to Reproduce:
It's all written in the description.
Actual Results:
.
Expected Results:
.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
.
--
You are receiving this mail because:
You are the assignee for the bug.
