Description: All the documentation I found on how to use LO Calc for ANOVA always refers to 1-way ANOVA (1 factor ANOVA). While Calc has the option for 2 factors, there is no official guide on how to do that. Steps to Reproduce: I chose enhancement but I am not sure, it might be a borderline bug or simply a matter of lack of documentation. To answer this I should know how to use 2-factor ANOVA in Calc properly. This is especially relevant because there is more than 1 way of structuring the data to perform the analysis, therefore it is not enough to read the documentation referring to 1-way ANOVA and simply "extending" to the case of 2 factors. Actual Results: For example, the data could be expected in 'wide' format, such as a table with one factor as columns and another one as rows, with each cell being a single observation Think of a table with 'warehouse location' as columns (say 3 columns: London, Paris, Buenos Aires) and sellers as rows (say J. Smith, R. Gomez, L. Lee), and each cell is the yearly revenue (eg. 3234.55 USD). Or, the data may be expected in 'long' format, eg only 3 columns (Warehouse location, Seller, Revenue) where all the combinations are listed below. What is the structure expected by calc? This is unresolved (at least the documentation I could find), and therefore the 2-factor ANOVA is kind of unusable or cumbersome at least. Expected Results: This should be well documented, just as the single-factor case is currently documented. The best way is to include example data so the user can clearly see how to structure the input. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 24; OS: Linux 6.5; UI render: default; VCL: qt5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.2.5~rc2-0ubuntu0.22.04.1~lo1 Calc: threaded
for reference : https://help.libreoffice.org/latest/en-US/text/scalc/01/statistics_anova.html
(In reply to fpy from comment #1) > for reference : > https://help.libreoffice.org/latest/en-US/text/scalc/01/statistics_anova.html Yes, that is the documentation, as I mentioned in my OP. The example is for 1-factor. In this case, the factor being investigated is the school subject (or discipline), the levels being compared are 'Maths', 'Physics', and 'Biology'. There is no mention to, or example of, a 2-factors case.
If needed, I can contribute with an example. Who should I contact for this?