Analysis of Variance (ANOVA)
Sample Results as an Excel Table:
| Analysis of Variance | |||||
| Variable: | Price | ||||
| grouped by: | Size | ||||
| Sum of Squares | Degrees of Freedom | Mean Square | F | P | |
| Between Groups | 641822014.5 | 2 | 320911007.3 | 13.96376784 | 8.08847E-06 |
| Within Groups | 1585736726 | 69 | 22981691.68 | ||
| Total | 2227558740 | 71 | 31374066.77 | ||
| Bartlett-Test for homogeneity of variances | |||||
| Chi-square | Degrees of Freedom | P | |||
| 20.754688 | 2 | 3.11298E-05 | |||
| Multiple comparisons | |||||
| Method: | LSD | Significance (p): | 0.05 | ||
| Critical differences in mean between group pairs (upper right) | |||||
| and calculation of significances (lower left): | |||||
| (Mean) | compact | medium | large | ||
| compact | 3832.5 | ---- | 3095.449373 | 3130.427312 | |
| medium | 6129.1 | no | ---- | 2513.022437 | |
| large | 11277.71429 | yes | yes | ---- | |
| Homogeneous Subsets | |||||
| 1 | 2 | ||||
| compact | * | ||||
| medium | * | ||||
| large | * | ||||
A two-way analysis of variance is also possible, with or without interaction.