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:

Bonferroni

 

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

----

3807.37638

3850.398947

 

medium

6129.1

no

----

3090.996206

 

large

11277.71429

yes

yes

----

 
           
           

Subset 1:

compact

       
 

medium

       
           

Subset 2:

large

       
           

A two-way analysis of variance is also possible, with or without interaction.