Select the statistics to include in your output.

Use the mean to describe the sample with a single value that represents the center of the data. Many statistical analyses use the mean as a standard measure of the center of the distribution of the data.

Use the standard error of the mean to determine how precisely the mean of the sample estimates the population mean. For more information, go to All statistics and graphs and click "SE Mean".

Use the standard deviation to determine how spread out the data are from the mean. For more information, go to All statistics and graphs and click "StDev".

Use the variance to determine how spread out the data are from the mean. The variance is equal to the standard deviation squared. For more information, go to All statistics and graphs and click "Variance".

The coefficient of variation (COV) is a measure of spread that describes the variation in the data relative to the mean. The coefficient of variation is adjusted so that the values are on a unitless scale. Because of this adjustment, you can use the coefficient of variation instead of the standard deviation to compare the variation in data that have different units or that have very different means. For more information, go to All statistics and graphs and click "CoefVar".

In the worksheet, the column name for the coefficient of variation is CVariation.

The range is the difference between the largest and smallest data values in the sample. The range represents the smallest interval that contains all the data values.

The sum is the total of all of the data values.

The minimum is the smallest data value in the sample. Use the minimum to identify a possible outlier or a data entry mistake. One of the simplest ways to assess the spread of your data is to compare the minimum and maximum.

25% of the data values in the sample are less than the 1^{st} quartile value. In the worksheet, the column name for the 1^{st} quartile is Q1.

The median is another measure of the center of the distribution of the data. The median is usually less influenced by outliers than the mean. Half the data values are greater than the median value, and half the data values are less than the median value.

25% of the data values in the sample are greater than the third quartile value. In the worksheet, the column name for the third quartile is Q3.

The maximum is the largest data value in the sample. Use the maximum to identify a possible outlier or a data-entry error. One of the simplest ways to assess the spread of your data is to compare the minimum and maximum.

The interquartile range (IQR) is the distance between the 1^{st} quartile (Q1) and the third quartile (Q3). Use the interquartile range to describe the spread of the data. A large IQR value indicates greater spread in the data.

The number of non-missing values in the sample. In the worksheet, the column name for N nonmissing is N.

The number of missing values in the sample. The number of missing values refers to cells that contain the missing value symbol *. In the worksheet, the column name for N missing is NMissing.

The total number of observations in the column. Use to represent the sum of N missing and N nonmissing. In the worksheet, the column name for N total is Count.

Cumulative N is a running total of the number of observations in successive categories. For example, an elementary school records the number of students in grades one through six. The CumN column contains the cumulative count of the student population:

Grade Level | Count | CumN | Calculation |
---|---|---|---|

1 | 49 | 49 | 49 |

2 | 58 | 107 | 49 + 58 |

3 | 52 | 159 | 49 + 58 + 52 |

4 | 60 | 219 | 49 + 58 + 52 + 60 |

5 | 48 | 267 | 49 + 58 + 52 + 60 + 48 |

6 | 55 | 322 | 49 + 58 + 52 + 60 + 48 + 55 |

The percent represents the contribution of a category to the whole. Percent is calculated by dividing the frequency of that category by the total frequency and multiplying by 100. For example, if you inspect 400 parts and 21 of them are defective, the percent defective would be

The cumulative percent is the sum of all the percentage values up to that category, as opposed to the individual percentages of each category. In the worksheet, the column name for cumulative percent is CumP.

Use the trimmed mean to eliminate the impact of very large or very small values on the mean. When the data contain outliers, the trimmed mean may be a better measure of central tendency than the mean. For more information, go to All statistics and graphs and click "TrMean".

The uncorrected sum of squares are calculated by squaring each value in the column, and calculates the sum of those squared values. That is, if the column contains x_{1}, x_{2}, ... , x_{n}, then sum of squares calculates (x_{1}^{2} + x_{2}^{2} + ... + x_{n}^{2}). Unlike the corrected sum of squares, the uncorrected sum of squares includes error. The data values are squared without first subtracting the mean.

Use skewness to determine the extent to which the data are not symmetrical. For more information, go to How skewness and kurtosis affect your distribution.

Use kurtosis to determine the extent to which the data are peaked, compared to a normal curve. For more information, go to How skewness and kurtosis affect your distribution.

The mean of the squared successive differences (MSSD) is an estimate of variance. You can use the MSSD is to test whether a sequence of observations is random. In quality control, you can use the MSSD is to estimate the variance when the subgroup size = 1.