In this tutorial we will learn how to create a summary statistics or descriptive statistics in Excel for a given set of values. We will be using Analysis Toolpak add-in to generate summary statistics or descriptive statistics in Excel.
We will be using the 15 different scores obtained by students in a particular subject to depict example of Descriptive statistics in Excel.
The data is shown below
Data:
Step 1: On the top right corner of the data tab click data analysis.
Note: if you can’t able to find the Data Analysis button? Click here to load the Analysis ToolPak add-in.
Step 2: Select Descriptive statistics and click ok.
Step 3: Click in the Input Range box and select the range A2:A16, Select the output range C2 and check the summary statistics check box, as shown below and click ok
Summary Statistics or Descriptive statistics will be generated as shown below.