Summary Statistics in Excel or Descriptive Statistics in Excel

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:

DESCRIPTIVE STATISTICS IN EXCEL 1 or Summary Statistics in Excel

Step 1: On the top right corner of the data tab click data analysis.

DESCRIPTIVE STATISTICS IN EXCEL 2 or Summary Statistics in Excel

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.

DESCRIPTIVE STATISTICS IN EXCEL 3 orSummary Statistics in Excel

 

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

DESCRIPTIVE STATISTICS IN EXCEL 4 or Summary Statistics in Excel

 

Summary Statistics or Descriptive statistics will be generated as shown below.

DESCRIPTIVE STATISTICS IN EXCEL 5 or Summary Statistics in Excel

previous small Descriptive Statistics in Excel                                                                                                                next small Descriptive Statistics in Excel