WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Descriptive Statistics in Excel

Descriptive Statistics in Excel

What is Descriptive Statistics in Excel?

To summarize an information available in statistics is known as descriptive statistics and in excel also we have a function for descriptive statistics, this inbuilt tool is located in the data tab and then in the data analysis and we will find the method for the descriptive statistics, this technique also provides us with various types of output options.

Steps to Enable Descriptive Statistics in Excel

  • Step 1: Go to File > Options.

Descriptive statistics step 1

  • Step 2: Go to Add-ins

Descriptive statistics step 2

  • Step 3: Under Add-ins on the right-hand side, you will see all the inactive Applications. Select Analysis Toolpak and click on GO.

Descriptive statistics step 3

  • Step 4: Now, you will all the add-ins available for your excel. Select Analysis Toolpak and click on OK.

Descriptive statistics step 4

Now you must see the Data Analysis option under the Data tab.

Descriptive statistics step 5

Click on Data Analysis you will see all the available analysis techniques like Anova, T-Test, F-test in excel, Correlation, Histogram, Regression, Descriptive Statistics, and many more under this tool.

Descriptive statistics step 6

How to use Descriptive Statistics in Excel?

You can download this Descriptive Statistics Excel Template here – Descriptive Statistics Excel Template

Example #1

Now, look at the simple data from a test, which includes the scores of 10 students. Using this data of scores, we need the Descriptive Statistics data analysis.

Descriptive statistics Example 1

Copy this data to your excel sheet.

  • Step 1: Go to Data > Data Analysis.

Descriptive statistics Example 1-1

  • Step 2: Once you click on Data Analysis, you will list all the available analysis techniques. Scroll down and select Descriptive Statistics.

Descriptive statistics Example 1-2

  • Step 3: Under Input Range, select the range of Scores including heading, Check Labels in the first row, Select Output range and give cell reference as D1 and check Summary statistics.

Descriptive statistics Example 1-3

  • Step 4: Click on OK to complete the task. In the D1 cell, you will see the summary report of Descriptive Statistics data analysis.

Descriptive statistics Example 1-4

We got all kinds of statistical results pertaining to the data we have selected, i.e., scores.

The average Score (Mean) is 70.2, and the Standard Deviation is 15.97, the Minimum Score is 46, the maximum score is 91, the total scores sum id 702, and the total number of students this sample is 10. Like this, we have all kinds of statistical results.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2

We have learned how descriptive statistics works in the previous example. Download the workbook to this descriptive statistics in Excel.

I have a list of students, their age, gender, height, weight, weekly hours study, and recent examination score details for a few students.

Example 2

By looking at this above data, the common questions are what the average age of the student group is? , average weight, average exam score, average height, Maximum value in each category, Minimum value, etc.

We have as many as 5 different categories to tell the statistical results. We can conduct a Descriptive Statistical Analysis to find all these.

  • Step 1: Go to Data > Data Analysis.

Example 2-1

  • Step 2: Once you click on Data Analysis, you will list all the available analysis techniques. Scroll down and select Descriptive Statistics.

Example 2-1

  • Step 3: Under Input Range, select all the category range, including headings, i.e., C1:G26.

Example 2-3

We can get the summary result in the same worksheet, different worksheets, and different workbooks as well. Based on the selection, we give it will show the summary report. In this example, I have taken the option of showing the summary in the same worksheet, i.e., from J1 cell.

Example 2-4

Since we have selected the headings, we need to tick the checkbox Labels in the first row. Because we have selected the headings, it will be helpful while showing the results; otherwise, it will be confusing to understand each category’s results.

Example 2-5

And then tick the Summary Statistics option.

Example 2-6

  • Step 4: Click on OK to compete for the test. We will get the descriptive statistics results from the J1 cell.

Descriptive statistics Example 2-4

It has shown up all the statistical results for all five categories. The total number of students is 25, the average age is 26.64, average height is 5.244, average weight is 67.44, and the average exam score is 57.8, which is relatively low compared to modern-day standards and many other results.

Things to Remember

  • Descriptive Statistics in Excel is a bundle of many statistical results.
  • Label as the first row means the data range we have selected includes headings as well.
  • We can find the average value using an AVERAGE in excel function like this maximum value by MAX, minimum value by MIN functions.
  • SUMMARY will be displayed based on the selection we make.

Recommended Articles

This has been a guide to Descriptive Statistics in Excel. Here we discuss how to use descriptive statistics tools in excel along with practical examples and downloadable excel templates. You may learn more about excel from the following articles –

  • Examples of Regression Formula
  • Excel Correlation Matrix – Examples
  • T-TEST Excel
13 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Descriptive Statistics Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More