Ho to get the Descriptive Statistics in Microsoft Excel

In this article, we will learn Descriptive Statistics in Excel 2016.

Descriptive Statistics is to quick calculate Numerical descriptive statistics like Mean, Median, Mode, Standard Deviation, Range, Min, Max and various other in Microsoft Excel 2016.

We can use this tool to analyze the run rate, scores, marks etc.

All of the above might be confusing for some people, so let’s gear up & start learning ANOVA single factor in excel with the example.

Here we have a list of few scores.
Select the tab Data > Data Analysis as shown in below screenshot.
Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

Click on Data Analysis and its dialog box appears.
Now select Descriptive Statistics and click OK.
Descriptive Statistics dialog box appears. Fill the options as shown below.

Click OK to view the details your scores.
As you can see the details of the data we input.

Hope you got how to do Descriptive Statistics tool in Excel 2016. Find more articles on Data Analysis here. Please state your query in the comment box below. We will help you.

Related Articles:

Pareto Chart and Analysis

How to Install Analysis ToolPak in Excel For Mac and Windows

Regressions in excel 2010

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.