I am interested in performing an ANOVA on the difference in two independent groups. I have 4 sets of data: the posttest and pretest scores of a treatment group, and the posttest and pretest scores of a control group. The numbers for the two groups are different, and I have the means and standard deviations of the 4 data sets (I do not have the data).
I would like to conduct an ANOVA on the difference in scores: is it possible to calculate a Fisher-Snedecor F statistic from the difference in scores? Do I need the correlation coefficients between the posttest scores (dependent data) and the pretest scores (independent data)?
I would like to do the calculations on a spreadsheet (and need therefore the formulas). I would also be very interested in solved spreadsheet examples.