ONE-WAY ANOVA
|
![[Link Map]](../../icons/smartnav.gif)
|
Arrange the treatment groups of the drytime variable in adjacent columns
as before and select Tools > Data Analysis > Anova: Single factor.
Insert the input range, including the treatment labels if they are available.
Select an output range and click OK to obtain the output below:
When there are only two treatments, the F-statistic is simply the
pooled t-statistic squared,
as can be seen by testing the effect of conditioning.
Replace the three machine treatment groups with a single treatment group labelled cond and
select Tools > Data Analysis > ANOVA: Single factor to get the following
output:
From the earlier example, the pooled t-statistic was found to be 5.66, which is the square
root of 32.08, the F-statistic.
Basic statistics in Excel 23.2.99 Page: 21 of 25
|
|