Descriptive Statistics dialog box

 

Use this dialog box to compute some basic statistics for the selected samples.

 

Input

Specifies the worksheet location of the input data for this operation.

 

Valid Input Range

Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.

 

Input Range

Type in this box the range of cells containing the data you want to use as input for this command.

 

Refer to Specifying Input Arguments for additional information on this subject.

 

Output

Specifies the worksheet location for placing the results of this operation.

 

New Workbook

Select this option to place the results of this operation in a new document workbook.

 

New Sheet

Select this option to place the results of this operation in a new worksheet.

 

Range Position

Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.

 

Refer to Specifying Output Locations for additional information on this subject.

 

Series Context

 

Series in Columns

Select this option to specify that the data specified by the Input Range box is organized in columns.

 

Series in Rows

Select this option to specify that the data specified by the Input Range box is organized in rows.

 

One Series Column-Wise

Select this option to specify that the data specified by the Input Range box is one series ordered across columns.

 

One Series Row-Wise

Select this option to specify that the data specified by the Input Range box is one series ordered across rows.

 

Refer to Specifying Input Arguments for additional information on this subject.

 

Options

 

Confidence Level

Type in this box a confidence level for calculating the margin of error for the population mean and the confidence interval for the population variance.

Refer to Margin of Error of the Mean, Confidence Interval for the Population Variance and Statistical Inference, Decision Theory and Hypothesis Testing for additional information on this subject.

 

OK

Closes the dialog box and carries out this operation.

 

Cancel

Closes the dialog box without carrying out this operation.

 

 

Operation Output

 

Mean

The arithmetic mean of the sample, defined as:

 

 

Median

The median of the sample, taken as the mid-value for an odd number of items (or the mean between the 2 mid-values for an even number of items), from the list of values in the samples arranged in order of magnitude.

 

Mode

The mode of the sample, taken as the first most frequently occurring value in the sample, if one exists. If more than one mode is present in the sample, the same are listed at the end of the report.

 

Geometric Mean

The geometric mean of the sample, calculated as:

 

 

 

Harmonic Mean

The harmonic mean of the sample, calculated as:

 

 

 

Mean Deviation

The mean deviation of the sample, calculated as:

 

 

Root Mean Square

The root mean square of the sample, calculated as:

 

 

Variance

If this sample represents the population, then the following quantity is the population variance:

 

 

Standard Deviation

If this sample represents the population, then the following quantity is the population standard deviation:

 

 

Sample Variance

The unbiased sample variance, calculated as:

 

 

Sample Standard Deviation

The sample standard deviation, calculated as:

 

 

Standard Error

The standard error of the sample mean, calculated as:

 

 

Skewness

The skewness, calculated as:

 

 

 

Standard Error of Skewness

The standard error of skewness, calculated as:

 

,

 

 

Kurtosis

The kurtosis, calculated as:

 

,

,

 

 

Standard Error of Kurtosis

The standard error of kurtosis, calculated as:

 

 

Count

The number of items in the sample.

 

Sum

The sum of all values in the sample:

 

 

Minimum Value

The minimum value in the sample.

 

Maximum Value

The maximum value in the sample.

 

Range

The difference between the maximum and minimum values of the sample.

 

Margin of Error of the Mean

The margin of error for the population mean, derived from the Student's t-distribution with N-1 degrees of freedom. This value represents a distance from the sample mean, where finding the population mean has the probability specified in Confidence Level.

 

Confidence Interval for the Population Variance

The confidence interval for the population variance, derived from the chi-square distribution with N-1 degrees of freedom. The Low and High values delimit the interval where finding the population variance has the probability specified in Confidence Level.

 

Additional Modes

Additional modes in the sample, if such values exist, are listed in this and continuing rows.