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. Gall No. Replicate No. 1 2 3 4 5 6 1 4.4 5.7 6.2 5.1 6.1 6.2 2 4.9 5.1 5.1 6 6 6.2 3 4.7 5.8 6.1 5.8 5.7 5.3 4 4.8 5.5 5.3 5.9 6 6.3 Average 4.70 5.53 5.68 5.70 5.95 6.00 I am having a hard time wording my Ho and Ha, as well as finding ts, df, and P. How do I do this using excel
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.
| Gall No. | |||||||
| Replicate No. | 1 | 2 | 3 | 4 | 5 | 6 | |
| 1 | 4.4 | 5.7 | 6.2 | 5.1 | 6.1 | 6.2 | |
| 2 | 4.9 | 5.1 | 5.1 | 6 | 6 | 6.2 | |
| 3 | 4.7 | 5.8 | 6.1 |
|
5.7 | 5.3 | |
| 4 | 4.8 | 5.5 | 5.3 | 5.9 | 6 | 6.3 | |
| Average | 4.70 | 5.53 | 5.68 | 5.70 | 5.95 | 6.00 |
I am having a hard time wording my Ho and Ha, as well as finding ts, df, and P. How do I do this using excel?
Step by step
Solved in 2 steps with 3 images
