Calculating Descriptive Statistics in Excel





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 4, 2013

For numerical data with one or more variables, descriptive statistics
are used to summarize the empirical distribution of each variable.

Windows Excel can calculate descriptive statistics using the Data
Analysis Toolpak, which you should already have enabled as an add-in for

First, start Excel and open your data set. I will assume that your
data is arranged with the variables as columns and that your data also
includes column headings.

Next, click the Data tab and choose Data Analysis. If you do not see the
Data Analysis option here, then you have not enabled the Data Analysis
Toolpak correctly.

In the next box, select Descriptive Statistics and click OK. You will
then be presented with a dialog box requiring several inputs.

For the Input Range, select the rectangular array of cells around the
numerical columns that you would like to analyze.

Click that labels are in the first row, and be sure to click the option
for Summary Statistics. Other options can safely be left at their
defaults. Then click OK.

After a moment, Excel will produce a new tab with the desired descriptive

  • Category

  • License

    • Standard YouTube License


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...