The rows per sample tab in Anova calculation is always deactivated.

[Ankur8402]

I am trying to run Hypothesis test using two way Anova, but the rows per sample tab is always deactivated
Is there any particular format in which the data must be to run the two way anova test in libre office calc?

[mariosv]

LibreOffice help: Analysis_of_Variance_ANOVA

With the help data

or by rows

[dariot]

marios, you are showing the result for one way anova, not two way, in fact you always have selected “single factor” which is namely the matter with 3 levels (Maths, Physics or Biology).
The question from ankhur is related to Two factor ANOVA, still not working as of today LibreOffice Ver. 5.3.6.1

[mariosv]

i see, please do a bug report about LibreOffice feedback

[dariot]

Thanks mariosv. I am not registered in bugzilla and this created uneasiness. I tried to ask the question to the comunity first, showing this example. In Sheet1 what I get and in Sheet2 I manually worked out what I would expect. (the graph being a “nice to have”