First time here? Check out the FAQ!
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
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-19 11:06:42 +0200
Seen: 132 times
Last updated: Jul 20 '12