Excel Descriptive Statistics Tools

Perhaps the most common Data Analysis tool that you’ll use in Excel is the one for calculating descriptive statistics. To see how this works, for example, you may have the scores of 14 participants for a test.

excel-descriptive-statistics-tool

To generate descriptive statistics for these scores, execute the following steps.

  • On the Data tab, click Data Analysis.
excel-descriptive-statistics-tool-01
  • Select Descriptive Statistics and click OK.
excel-descriptive-statistics-tool-02
  • Select the range A2:A15 as the Input Range.
  • Select cell C1 as the Output Range.
  • Make sure Summary statistics is checked.
excel-descriptive-statistics-tool-03

Click OK and the result is as

excel-descriptive-statistics-tool-04

Here are the statistics that Excel calculates.

StatisticDescription
MeanShows the arithmetic mean of the sample data.
Standard ErrorShows the standard error of the data set (a measure of the difference between the predicted value and the actual value).
MedianShows the middle value in the data set (the value that separates the largest half of the values from the smallest half of the values).
ModeShows the most common value in the data set.
Standard DeviationShows the sample standard deviation measure for the data set.
Sample VarianceShows the sample variance for the data set (the squared standard deviation).
KurtosisShows the kurtosis of the distribution.
SkewnessShows the skewness of the data set’s distribution.
RangeShows the difference between the largest and smallest values in the data set.
MinimumShows the smallest value in the data set.
MaximumShows the largest value in the data set.
SumAdds all the values in the data set together to calculate the sum.
CountCounts the number of values in a data set.
Largest(X)Shows the largest X value in the data set.
Smallest(X)Shows the smallest X value in the data set.
Confidence Level(X) PercentageShows the confidence level at a given percentage for the data set values.

Get industry recognized certification – Contact us

Menu