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 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.

Picture 1 of Create descriptive statistics table for dataset in Excel

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

Picture 2 of Create descriptive statistics table for dataset in Excel

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.

Picture 3 of Create descriptive statistics table for dataset in Excel

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

Picture 4 of Create descriptive statistics table for dataset in Excel

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.

Picture 5 of Create descriptive statistics table for dataset in Excel

Step 3: Completing the statistics table (as shown)

Picture 6 of Create descriptive statistics table for dataset in Excel

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!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile