We use Descriptive statistics to calculate several statistical parameters at once like mean, sum, standard deviation, variance, etc. This summary statistics is done with the data analysis tool. This tutorial will teach all levels of Excel users how to do Descriptive Statistics.
Figure 1 – Result of descriptive stats
How to Run Descriptive Statistics
We will use the data below to run summary statistics. This statistic will be for values in Column C and Column D. For instance, where descriptive statistics displays SUM as 50,620, it is the sum of the values in Column C.
Figure 2 – How to use descriptive statistics
- To run descriptive statistics, we will click on the Data tab, and then, the Data Analysis tool
Figure 3 – How to get descriptive statistics
- We will click on Descriptive statistics in the Data Analysis dialog box and click OK
Figure 4 – How to run descriptive statistics
- We will click on Input range and select Cell C4 to Cell D13
- Remember that we are doing this statistics by Column, so we will check the Column Circle
- We can click on New worksheet for the descriptive statistics to display the result in a new worksheet or specify a range where the result will be displayed in the current worksheet
Figure 5 – Descriptive statistics dialog box
- We will click OK
Figure 6 – Result of descriptive stats
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.