the Statistics Add-In for Microsoft® Excel

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.