How to Get Descriptive Statistics in Excel?
Let’s look at how to obtain the descriptive statistics using the Data Analysis Toolpak now that it is enabled.
Example: We have given shirt size of 20 men in the below table.
Sample data
Follow the below steps to implement descriptive statistics on sample data:
Step 1. Go to “Data” >> Click “Data Analysis” (Image 1) – to pop up the “Data Analysis” Dialogue box. If you cannot find “Data analysis” in Excel ribbon. The end of this article finds the steps [To provide “Data Analysis”]
Step 2. In Data Analysis, Select “Descriptive Statistics” and Press “OK” – To pop-up “Descriptive statistics” Dialogue box for further input
Step 3. Make sure the below options are selected in “Descriptive statistics” and Press “OK”
Input Range: “$B$1:$B$21”
Grouped By: Columns
Labels in first row: Checked
Output Range: $D$5
Summary statistics: Checked
Output
Descriptive statistics Output in Table “D5:E19”
Descriptive Statistics in Excel
Obtaining descriptive statistics for data collection may be helpful if you frequently work with huge datasets in Excel. A few key data points are provided by descriptive statistics, which you can utilize to quickly grasp the complete data set.
Although you can calculate each of the statistical variables separately, using Excel’s descriptive statistics feature allows you to rapidly get all this information in one location.