the Statistics Add-In for Microsoft® Excel

Descriptive Statistics

Sample Results as an Excel Table:

       

Descriptive Statistics

     
       
       
 

Size of Household

Income

Horsepower

       

Valid cases

72

72

72

Mean

3.666666667

28934.38889

89.70833333

Std. error of mean

0.262407298

1231.285072

6.173338527

Variance

4.957746479

109156530.8

2743.927817

Std. Deviation

2.226599757

10447.80028

52.38251442

Variation Coefficient

0.607254479

0.361085915

0.583920272

rel. V.coefficient(%)

7.15656267

4.255438317

6.881566403

Skew

0.779475351

0.717595814

1.797690994

Kurtosis

-0.017045455

0.837419335

3.592515379

Minimum

1

12123

23

Maximum

9

63166

282

Range

8

51043

259

Sum

264

2083276

6459

1st percentile

----

----

----

5th percentile

1

13632.45

30.3

10th percentile

1

15147.5

36.2

25th percentile

2

21137

61

Median

3

29165

75.5

75th percentile

5

33813.25

102.5

90th percentile

7

41573.2

171.8

95th percentile

9

47992.5

203.35

99th percentile

----

----

----

Geom. mean

2.992485803

27102.57182

78.04018807