Descriptive Statistics


You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test.

Descriptive Statistics Example

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

1. On the Data tab, click Data Analysis.

Click Data Analysis

Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

2. Select Descriptive Statistics and click OK.

Select Descriptive Statistics

3. Select the range A2:A15 as the Input Range.

4. Select cell C1 as the Output Range.

5. Make sure Summary statistics is checked.


6. Click OK.


Descriptive Statistics Result

Do you like this free website? Please follow us on Google+