стр. 48 |

170

Chapter 10: Statistics Tools

Input (or, вЂњSourceвЂќ) data

Choose the data series whose descriptives you desire. Click on the edge of

the box next to вЂњInput RangeвЂќ (at the point where the dotted arrow points

in Figure 145).

Options

Choose other options shown in Figure 145. Select the option вЂњLabels in

first rowвЂќ because the names of the three series are in the first row of the

range you selected (the labels are in cells C1, D1, and E1)вЂ” this way

Excel picks up the names of the variables and uses these names in the

output13. Execute the dialog by clicking on the button OK.

Output

Excel produces the descriptive statistics and places the results in a new

worksheet. (This is illustrated in Figure 146.)

Note that in the output of this procedure (shown in Figure 546) the first row has the

13

labels for the three variablesвЂ” 1995, 2000, and 2010.

171

Statistical Analysis with Excel

Figure 146: Output of Descriptive Statistics procedure

This tool generates a report of univariate statistics for data in the input

range, providing information about the central tendency and variability of

your data

Example 2: Adding additional parameters to the descriptives table

Go to the menu option TOOLS/DATA ANALYSIS. Select the option

вЂњDescriptive Statistics.вЂќ In addition to the statistics requested in the

previous example, I request Excel to report on the fifth largest and fifth

smallest values for each column/series.

172

Chapter 10: Statistics Tools

Figure 147: The Descriptives Statistics dialog

Output

The output for the procedure is reproduced in the next table. In one

simple step, you have created a table that captures the basic statistical

attributes of several data series and the fifth highest and lowest values of

each data series.

Table 29: Output of the Descriptive Statistics tool including the Kth largest and smallest

values. The names of the three variable are: s1, s2, and x1.

s1 s2 x1

Mean 7.32 Mean 7.23 Mean 1173.00

Standard Standard Standard

0.44 0.49 52.67

Error Error Error

Median 5.31 Median 4.81 Median 1173.00

Mode 1.34 Mode 23.00 Mode #N/A

Standard Standard Standard

5.72 6.33 682.73

Deviation Deviation Deviation

32.68 40.13 466119.22

Sample Sample Sample

173

Statistical Analysis with Excel

s1 s2 x1

Variance Variance Variance

Kurtosis вЂ“0.22 Kurtosis 0.04 Kurtosis вЂ“1.20

Skewness 0.95 Skewness 1.06 Skewness 0.00

Range 19.66 Range 22.00 Range 2344.00

Minimum 1.34 Minimum 1 Minimum 1

Maximum 21 Maximum 23 Maximum 2345

Sum 1229.79 Sum 1215.395 Sum 197064

Count 168 Count 168 Count 168

Largest (5) 21 Largest (5) 23 Largest (5) 2288.86

Smallest (5) 1.34 Smallest (5) 1 Smallest (5) 57.14

Confidence Confidence Confidence

0.87 0.96 103.99

Level (95.0%) Level (95.0%) Level (95.0%)

Interpretation of the statistical parameters is discussed in chapter 6, and

of Confidence levels is discussed in 7.1.

RANK AND PERCENTILE

10.2

стр. 48 |