Table 15.
Excel cell formulas.
| Data Row | Trainer Col B | # Runners Col C | Ave MPH Col D | Stdev Col E | Mean×ni Col F | Lsmean Col G |
SSW Col H |
SSB Col I |
VarianceWB Col J |
StdevWB Col K |
|---|---|---|---|---|---|---|---|---|---|---|
| Row 2 | 1 | 10 | 6.2 | 1.24 | D2 × C2 | - | (E22) × (C2-1) | C2 × (D2-$G$6)2 | - | |
| Row 3 | 2 | 5 | 5.5 | 0.55 | D3 × C3 | (E32) × (C3-1) | C3 × (D3-$G$6)2 | |||
| Row 4 | 3 | 8 | 6.1 | 0.915 | D4 × C4 | (E42) × (C4-1) | C4 × (D4-$G$6)2 | |||
| Row 5 | 4 | 12 | 6.8 | 1.7 | D5 × C5 | (E52) × (C5-1) | C5 × (D5-$G$6)2 | |||
| Row 6 | - | SUM (C2:C5) |
- | - | SUM (F2:F5) |
F6/C6 | SUM (H2:H5) |
SUM (I2:I5) |
(I6 + H6)/(C6 − 1) | SQRT(J6) |