I wanted to know if it was possible to easily create an interaction plot with two factors in Calc.
My spreadsheet basically has 3 columns: the Genotype (5 values), the Treatment (3 values) and the data collected. I want to compare the means of the data between Genotypes AND treatments.
So, this is what I get in Calc when I use one data range with the two factors in “categories”:
And this is what I would like to get (obtained in R):
I guess I could add cells to have the means, then create a dataset for each treatment, and then add error bars, but there should be a cleaner and easier way to do this, shouldn’t it?
Here is an example of dataset: http://dl.dropbox.com/u/1755762/Dataset%20example.ods