Bug 140549 - Rows per sample always deactivated
Summary: Rows per sample always deactivated
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Statistics
  Show dependency treegraph
 
Reported: 2021-02-20 05:48 UTC by Simran
Modified: 2024-09-18 19:12 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Simran 2021-02-20 05:48:36 UTC
Description:
In data when anova 2 factor test is applied using statistics,  rows per sample is always deactivated . Thwo factor anova with m observations per cell cannot be performed with the function 

Actual Results:
MAKE A TWO WAY ANOVA DATA 
GO TO DATA IN TOOLBAR
GO TO STATISTICS 
GO TO ANOVA 
SELECT TWO FACTOR 
SELECT THE DATA 
SELECT THE CELL FOR RESULT 
 BUT YOU WILL SEE THAT YOU ARE UNABLE TO SELECT ROWS PER SAMPLE 

Expected Results:
UNABLE TWO SELECT ROWS PER SAMPLE (WHICH REMAINS 1 BY DEFAULT) MAKING THE OBSERVATIONS FOR TWO WAY ANOVA WITH ONE FACTOR PER CELL.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
ALLOW TO SLECT NUMBER OF ROWS PER SAMPLE SO THAT ANOVA TWO WAY CLASSIFICATION WITH M OBSERVATIONS PER CELL CAN BE PERFORMED.
Comment 1 Buovjaga 2022-03-07 08:16:10 UTC
Please attach an example document.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 2 Hossein 2022-03-07 08:30:09 UTC
Going to "Data > Statistics > Analysis of Variance (ANOVA)", and select "Type: Two factor", the "Rows per sample is disabled". But is this the correct behavior?

Let's see what happens in MSO:

Two Way ANOVA in Excel With Replication / Without Replication
https://www.statisticshowto.com/perform-two-way-anova-excel-with-without-replication/
Comment 3 Hossein 2022-03-07 08:51:33 UTC
As can be seen here:

How to do Two-Way ANOVA in Excel
https://statisticsbyjim.com/anova/two-way-anova-excel/

The "Rows per sample" is enabled when doing "Two-Factor With Replication".
https://i0.wp.com/statisticsbyjim.com/wp-content/uploads/2019/11/Excel_ANOVA_two_factor_popup1.png
Comment 4 QA Administrators 2024-03-10 03:14:53 UTC Comment hidden (obsolete)
Comment 5 Jaime 2024-09-16 23:43:23 UTC
Same behavior as of Sep/24. 

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.6
Calc: threaded