the Statistics Add-In for Microsoft® Excel

Pearson Correlation

Sample Results as an Excel Table:

         

Pearson Correlation

       
         
         
         
 

Children

Income

Price

Horsepower

Children

       

Correlation coefficient

1

0.627423862

-0.2260438

-0.137079457

valid cases

72

72

72

72

one-sided significance

0

1.84267E-09

0.028113741

0.125436642

         

Income

       

Correlation coefficient

0.627423862

1

0.28973287

0.312975891

valid cases

72

72

72

72

one-sided significance

1.84267E-09

0

0.006781431

0.00371624

         

Price

       

Correlation coefficient

-0.2260438

0.28973287

1

0.795649889

valid cases

72

72

72

72

one-sided significance

0.028113741

0.006781431

0

3.41615E-17

         

Horsepower

       

Correlation coefficient

-0.137079457

0.312975891

0.795649889

1

valid cases

72

72

72

72

one-sided significance

0.125436642

0.00371624

3.41615E-17

0

         
         

Cronbach's Alpha

0.264272641

     

Scott's Homogeneity-Quotient

0.292465747