the Statistics Add-In for Microsoft® Excel

Crosstabs

Sample Results as an Excel Table:

           

Crosstabulation

         
           

Column variable:

Size

       

Row variable:

New or Used

       
           
 

compact

large

medium

Sums

 

new

         

Frequency

6

18

10

34

 

Expected frequency

6.611111111

13.22222222

14.16666667

   

Row percent

17.64705882

52.94117647

29.41176471

   

Column percent

42.85714286

64.28571429

33.33333333

   

Total percent

8.333333333

25

13.88888889

   

Cell chi-square

0.056489262

1.726423903

1.225490196

   
           

used

         

Frequency

8

10

20

38

 

Expected frequency

7.388888889

14.77777778

15.83333333

   

Row percent

21.05263158

26.31578947

52.63157895

   

Column percent

57.14285714

35.71428571

66.66666667

   

Total percent

11.11111111

13.88888889

27.77777778

   

Cell chi-square

0.050543024

1.544695071

1.096491228

   
           

Sums

14

28

30

72

 
           

% Cells with E.F. < 5

Chi-square

Degrees of Freedom

P

Contingency Coefficient

Cramer's V

           

0

5.700132685

2

0.057840483

0.270851723

0.281368992