the Statistics Add-In for Microsoft® Excel

Discriminant Analysis

Sample Results as an Excel Table:

             

Discriminant Analysis

           
             

X-variable:

Size of Household

       
 

Income

         
 

Price

         
             

Y-Variable:

Type

         
             
             
 

Function

         
 

1

2

3

     
             

Eigenvalue

1.561182651

0.170170271

0.016907811

     

Variance (percent)

89.29918872

9.733689482

0.967121802

     

Percent cumulative

89.29918872

99.0328782

100

     

Canonic correlation

0.780740274

0.381344349

0.128944522

     

Wilks' Lambda

0.328117055

0.840367709

0.98337331

     

Chi-Square

74.66378553

11.65235416

1.123353133

     

Degrees of Freedom

12

6

2

     

P

4.25298E-11

0.07018919

0.570252197

     
             
             
             
             
             

Standardized coefficients of the discriminant functions

       
             
 

Function

         
 

1

2

3

     
             

Size of Household

-0.86476817

0.363641094

1.215088659

     

Income

0.394717959

0.580560995

-1.382469979

     

Price

0.922738072

0.137363546

0.639299027

     
             
             

Values of the discriminant functions at the group centroids

       
             
 

Function

         
 

1

2

3

     
             

camping van

-0.227710012

0.454483248

0.314438409

     

pickup

-0.423544858

0.121276586

0.13263321

     

sedan

-0.094453506

-0.347412705

0.070622442

     

sports car

2.400435132

0.196512125

-0.354125129

     

station wagon

-0.963379052

0.405628789

-0.050748035

     
             
             

Mahalanobis distances between the groups (upper right)

       

and p-values of the associated F-test (lower left)

       
             
 

camping van

pickup

sedan

sports car

station wagon

 
             

camping van

----

0.580428262

1.048366688

3.085134457

1.07105469

 

pickup

0.8528902

----

0.660423013

3.315828408

0.750777528

 

sedan

0.291360027

0.54403493

----

3.036259054

1.315905449

 

sports car

5.62829E-05

6.99968E-07

2.83493E-10

----

3.950413682

 

station wagon

0.31168981

0.487382765

0.000587202

6.14379E-13

----

 
             
             

Classification results:

           

(prior probabilities equal):

           
   

Calculated

       
             
 

Actual Count

camping van

pickup

sedan

sports car

station wagon

             

camping van

4

3

0

0

0

1

pickup

6

0

1

0

2

3

sedan

34

9

1

21

0

3

sports car

10

0

0

2

8

0

station wagon

18

0

1

6

0

11

             
             

61.11%

of the cases were classified correctly.