Create descriptive statistics table for dataset in Excel

In Excel supports user statistical analysis tools. Here I introduce you how to create descriptive statistics tables for data sets in Excel.

In case the device does not have Analysis Toolpak installed, follow the instructions of Part 1. Install Analysis Toolpak if already installed, follow the instructions from Part 2. Create a statistics table .

1. Install Analysis Toolpak

Step 1: In card File-> Options -> dialog appears -> Add-Ins -> Analysis ToolPak -> Go.

Create descriptive statistics table for dataset in Excel Picture 1

Step 2: The Add-Ins dialog box appears -> Analysis Toolpak -> OK .

Create descriptive statistics table for dataset in Excel Picture 2

So you have installed Analysis Toolpak for Excel.

2. Create data statistics table

I have the following data table, I want to statistic about the sales and which products sell the best.

Create descriptive statistics table for dataset in Excel Picture 3

Step 1: Click Data -> Data Analysis . The Data Analysis dialog box appears, click Descriptive Statistics -> OK .

Create descriptive statistics table for dataset in Excel Picture 4

Step 2: Dialog Descriptive Statistics appears -> select the data that you want statistics in Section Input Range -> select the location of the statistics table in section Output Range -> tick Summary Statistics -> OK.

Create descriptive statistics table for dataset in Excel Picture 5

Step 3: Completing the statistics table (as shown)

Create descriptive statistics table for dataset in Excel Picture 6

We see Excel for some basic statistical quantities as follows:

1. Mean: The average value

2. Standar Error: Error of mean

3. Median: Median

4. Standar Deviatic: Standard deviation

5. Variance: Variable length

6. Maximum: Maximum value

7. Minimum: Minimum value.

Hope the data sheet will help you.

Good luck!