How to Do Descriptive Statistics in Excel (2 Suitable Methods)

Sometimes you may need to do Descriptive Statistics in Excel. In addition, you can find out lots of statistical terms like Summation, Median, Mean, Minimum, Maximum, Standard Deviation and so on through one simple method. So, I will explain how to do Descriptive Statistics in Excel in this article.


Download Practice Workbook

You can download the practice workbook from here:


2 Methods to Do Descriptive Statistics in Excel

Here, I will describe 2 suitable methods to do Descriptive Statistics in Excel. Also, for your better understanding, I’m going to use sample data that has 2 columns. Those are Student Name, and Mathematics Score. The dataset is given below.

How to Do Descriptive Statistics in Excel


1. Applying Data Analysis ToolPak to Do Descriptive Statistics in Excel

You can apply the Data Analysis ToolPak to do Descriptive Statistics in Excel. Firstly, you have to check that in your Excel Custom Ribbon is the Data Analysis ToolPak visible or not. If the Data Analysis ToolPak is invisible then you should follow Step-1. Otherwise, you may follow from Step-2.


Step 1: Inserting Data Analysis ToolPak in Excel

Here, I will show how to insert Data Analysis ToolPak in Excel.

  • Firstly, you have to go to the File tab.

Inserting Data Analysis ToolPak to Do Descriptive Statistics in Excel

At this time, you will see the following window.

  • Now, from that window, you should choose the Options menu.

At this time, a dialog box named Excel Options will appear.

  • Firstly, from that dialog box, you have to go to Add-ins command.
  • Secondly, choose Excel Add-ins in the Manage: box.
  • Finally, press the Go button.

At this time, another dialog box named Add-ins will appear.

  • Now, you need to click on the Analysis ToolPak.
  • Then, press OK to get the changes.

Lastly, you will see that there is a new ribbon named Data Analysis under the Data tab.


Step 2: Use of Descriptive Statistics in Excel

In this section, I will demonstrate how to use the Descriptive Statistics feature in Excel.

  • Firstly, from the Data tab >> go to the Data Analysis ribbon.

Use of Descriptive Statistics in Excel

At this time, a dialog box named Data Analysis will appear.

  • Now, select Descriptive Statistics and then Click on OK.

Subsequently, a new dialog box named Descriptive Statistics will appear.

  • Firstly, select the data range in the Input Range: box for which you want to do the descriptive statistics. Here, I have selected the range C4:C18.
  • Secondly, mark the Labels in first row option.

  • After that, choose the cell in the Output Range: box where you want to see the result. Here, I have chosen the D4 cell.
  •  Then, you must mark the Summary statistics option.
  • Finally, press OK to get the result.

At this time, you will see the following output.

Using Data Analysis Tool to get Descriptive Statistics in Excel

Now, I will do formatting to the output. In addition, you can do the formatting according to your preference. Also, this is not a mandatory term.

  • Firstly, select the data range.
  • Secondly, from the Home tab >> you may select the All Borders option >> then you may increase the Font Size >> then you may choose Center and Middle Alignment.

  • After that, select D4:E4.
  • Then, from the Home tab >> I increase the Font Size >> then I change the Fill Color >> then Bold it.

Finally, you will see the following formatted result.

Formatted Result of Descriptive Statistics in Excel

Read More: Descriptive Statistics – Input Range Contains Non-Numeric Data 


Similar Readings


2. Employing Power Query to Do Descriptive Statistics in Excel

You can employ Power Query to do Descriptive Statistics in Excel. Furthermore, with this method, you will get certain terms of Descriptive Statistics like Sum, Max, Min, Average, Median, and Count. The steps are given below.

Steps:

  • Firstly, from the Data tab >> you should go to the From Table/Range feature.

Employing Power Query to Do Descriptive Statistics in Excel

At this time, a dialog box named Create Table will appear.

  • Firstly, select the data range. Here, I have selected the data B4:C18.
  • Secondly, I must check the My table has headers option. This is because I have selected data with titles.
  • Thirdly, press OK to get the result.

After that, you will see the following situation. Which is Table-1 Power Query Editor.

  • Now, from the Transform tab >> you have to go to the Group By command.

At this time, a new window named Group By will appear.

  • Firstly, check Advanced.
  • Secondly, from the three dots beside Student Name >> you should press on Delete.

  • Now, in the same window, write down Summation in the New column name.
  • Then, choose the Operation as Sum.

  • After that, choose the Mathematics Score in the Column box.
  • Then, click on Add aggregation.

Here, I have pressed 4th time on the Add aggregation. But, you have to do this as per your requirement.

  • Now, in the same way, write down in the New column name and choose the Operation and then select the Mathematics Score option.
  • Finally, press OK to get changes.

  • Subsequently, from the Home tab >> choose the Close & Load feature >> then select Close & Load To…

At this time, a new dialog box named Import Data will appear.

  • Firstly, check Table.
  • Secondly, mark the Existing worksheet:
  • Thirdly, choose the cell where you want to keep the results.
  • Finally, press OK.

At the end, you will get the following result in your worksheet.

Read More: How to Calculate Root Mean Square Error in Excel


Use of Customize Status Bar to Do Descriptive Statistics in Excel

You can use the Customize Status Bar to do Descriptive Statistics in Excel. Also, with this method, you will get certain terms of Descriptive Statistics. These are Average, Count, Maximum, Minimum, and Sum. The steps are given below.

Steps:

  • Firstly, Right Click on the Status Bar.
  • Secondly, from the Context Menu Bar whose name is Customize Status Bar >> must check Average, Count, Maximum, Minimum, and Sum.

Use of Customize Status Bar to Do Descriptive Statistics in Excel

Finally, if you select the data range you will see the results on the Status Bar.

Read More: How to Show Menu Bar in Excel (2 Common Cases)


💬 Things to Remember

  • With method 1 you will get lots of statistics terms. But method 2 and 3 will give you some certain terms.

Practice Section

Now, you can practice the explained method by yourself.

Try to Do Descriptive Statistics in Excel


Conclusion

I hope you found this article helpful. Here, I have explained 2 methods to do Descriptive Statistics in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo