Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

how to do descriptive statistics in excel – Excelchat

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.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc