# 2.13.1.12 moments

## Brief Information

Compute moments on worksheet data

## Command Line Usage

 

1. moments ix:=Col(1); 

2. moments ix:=Col(1) mean:=mymean; 

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input ix

Input

vector

<active>

Specifies the input data range

Mean mean

Output

double

<unassigned>

The variable specifies the output for the arithmetic average.

Standard Deviation sd

Output

double

<unassigned>

The variable specifies the output for the standard deviation, which is a statistical measure of the distance a quantity is likely to lie from the average value of a group of data.

SE of Mean se

Output

double

<unassigned>

The variable specifies the output for the standard error of the mean, which is used to estimate the deviation of the population mean.

Number of Observations n

Output

int

<unassigned>

The variable specifies the output for the number of valid observations

Sum sum

Output

double

<unassigned>

The variable specifies the output for the arithmetic sum of selected dataset

Skewness skewness

Output

double

<unassigned>

The variable specifies the output for skewness, which reveals the symmetry of sample distribution. A positive skewness implies the distribution curve skew to right while a negative value indicates the curve skew to left

Kurtosis kurtosis

Output

double

<unassigned>

The variable specifies the output for kurtosis, which indicates how flat or peaked a distribution is. Negative values correspond to flat distributions, while positive values correspond to peaked distributions.

Coefficient of Variation cv

Output

double

<unassigned>

The variable specifies the coefficient of variation, which gives a measure of how dispersed a dataset is. This measure can be used to compare distributions of different sizes and with different means.

## Description

The "moments" command displays the mean, standard deviation, and other summary statistics of a given dataset. moments are used to describe certain basic features of the data in a study.

In the context of statistical analysis, moments include measures such as mean, standard deviation, standard error, kurtosis, skewness, and coefficient of variation.

## Examples

1. List all input and output results of descriptive statistics of given dataset, we assume data are put in 1st column of active worksheet.
In Command Window, type the following:

moments ix:=col(a);

2. To return the standard deviation of given dataset from the Command Window, type the following (we assume that the data are put in 1st column of active worksheet):
moments ix:=col(a) sd:=mysd; mysd=

## Algorithm

1. Mean is computed using the following equation: 2. Standard deviation is computed as follows: 4. Sample size is the total number of valid values in a data set

5. Sum is computed using following equation: 8. Coefficient of variance is computed as: ## References

Silverman, B.W. (1986), Density Estimation for Statistics and Data Analysis. New York: Chapman and Hall.

Tukey, J.W. (1977), Exploratory Data Analysis. Reading, MA: Addison-Wesley.

Erickson, B.H. and Nosanchuk, T.A. (1992) Understanding Data. Second Edition. Buckingham: Open University Press.

## Related X-Functions

Keywords:summary statistics, mean, median, standard deviation, skewness, kurtosis