Creating Descriptive Statistics Tables in Excel

In this article, Mytour will guide you on how to create descriptive statistics tables in Excel. To create descriptive statistics tables in Excel, we utilize the Descriptive Statistics function within the Analysis ToolPak.

Creating Descriptive Statistics Tables in Excel

Since Excel does not have Analysis Toolpak pre-installed, we need to install Analysis Toolpak before proceeding. Here's how to do it:

To install Analysis Toolpak in Excel, follow these steps: Click on the Office Button (Figure 1)àExcel Options. An Excel Options window will appear, click on the Add-In tab, then click the 'Go' button (Figure 2). The Add-In window will display, check the Analysis Toolpak option, and click OK (Figure 3). The Configuration Process window will appear (Figure 4). Once installation is complete, go to the Data tab, and you will see the Analysis Toolpak as shown in Figure 5.

Steps to create descriptive statistics tables in Excel

Step 1:  Open the data table for which you want to create descriptive statistics tables

Step 2: Select the Data -> Data Analysis -> Descriptive Statistics -> OK tab

Step 3: The Descriptive Statistics table displays, where you input data as follows:

Input Range: Excel data range requiring statistical analysis

Group By: 

• Columns: Data arranged by column
• Rows: Data arranged by row

Labels in First Row: Data range including labels declared

Output Range: Top-left cell address of the data table to be displayed

New Worksheet Ply: Report presented on a new Worksheet

New Workbook: The report is displayed on a new file.

Summary statistics: Statistical parameters summarization.

Confidence Level for Mean: Confidence level of the mean value.

Kth Largest: Displays the kth largest value within the data range.

Kth Smallest: Displays the kth smallest value within the data range.

After entering the required information into the Descriptive Statistics table, we proceed to step 4.

Step 4: Press OK and we obtain the result of the descriptive statistics table needed in Excel.

Consider the following example: Create a descriptive statistics table for the variable 'Years of Service' in the Excel sheet nhanvien.xls with data as shown in the figure:

Step 1:  Open the Excel file nhanvien.xls

Step 2: Select the Data ->Data Analysis -> Descriptive Statistics -> OK tab

Step 3: Declare data in the Descriptive Statistics table as follows

Step 4: Press OK to obtain a table with the parameters:

This article introduces you to creating descriptive statistics tables in Excel. This application is applicable to Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, especially the latest version of Office 2016 today.

Additionally, you can refer to how to use Histogram to draw probability distribution charts in Excel on Mytour.