I am not sure how to do this using excel's ANOVA analysis pak, but that is the program I must use The data given below are measurements (in micrometer units) of the thorax length of the aphid,...

I am not sure how to do this using excel's ANOVA analysis pak, but that is the program I must use

The data given below are measurements (in micrometer units) of the thorax length of the aphid, Pemphigus populitransversus. The aphids were collected in 6 galls on the cottonwood, Populus deltoides. Four alate (winged) aphids were randomly selected from each gall and measured. The alate aphids of each gall are mostly isogenic (identical twins), being decended parthenogenetically from one stem mother. Thus, any variance within galls should be due to environment only. Variance among different galls may be due to differences in genotype and also to environmental differences among galls. Do a one-way ANOVA to test whether there significant intergall variance.

Ho:

Ha:

T stat:

df:

P:

Conclusion relative to hypothesis