Descriptive Statistic quickly summarizes your data and gives you a few data points that you can use to quickly understand the entire data set. While you can also calculate each of these statistical values individually, using the descriptive statistics option in Excel quickly gives you all this data in one single place (and it’s a lot faster than using different formulas to calculate different values). In this short tutorial, I will show you how to get Descriptive Statistics in Excel.

Descriptive Statistics in Excel

To get the Descriptive Statistics in Excel, you need to have the Data Analysis Toolpak enabled. You can check whether you already have it enabled by going to the Data tab. If you see the Data Analysis option in the Analysis group, you already have it enabled (and you can skip the next section and go directly to the ‘Getting Descriptive Analysis’ section). In case you do not see the data analysis option in the data tab, follow the steps in the next section to enable it.

Enabling Data Analysis Toolpak

Below are the steps to enable the Data Analysis Toolpak in Excel: The other steps would enable the Data Analysis toolpak and you will be able to use it on all your Excel Workbooks.

Getting the Descriptive Analysis

Now that the Data Analysis Toolpak is enabled, let’s see how to get the descriptive statistics using it. Suppose you have a data set as shown below where I have the sales data of different products of a company. For this data, I want to get descriptive statistics. Below are the steps to do this: The above steps would insert a new sheet and you will get the statistics as shown below: Note that you can specify the following in step 8: Note that the resulting values you get are static values. In case your original data changes and you again want to get the Descriptive Statistics, you will have to repeat the above steps again. So this is how you can quickly get Descriptive Statistics in Microsoft Excel. I hope you found this tutorial useful. Other Excel Tutorials you may also like:

How to Calculate Standard Deviation in ExcelHow to Calculate PERCENTILE in ExcelCalculating Weighted Average in Excel.Calculating CAGR in ExcelHow to Calculate Correlation Coefficient in Excel