How to Do Summary Statistics in Excel

Calculating summary statistics in Excel is the fastest way to get a big-picture view of your data without looking at every single row. It's the first step in any data analysis, giving you a quick understanding of your data's central point, spread, and overall distribution. This guide will walk you through two powerful methods for generating these stats: using individual functions for one-off calculations and leveraging the Analysis ToolPak for a complete report.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly Are Summary Statistics?

Summary statistics (or descriptive statistics) are single numbers that give you a high-level summary of a dataset. Instead of being overwhelmed by hundreds or thousands of data points, you can use these key figures to understand the data's core characteristics at a glance. They help answer questions like:

• What's a typical value in this dataset? (e.g., Mean, Median, Mode)
• How spread out are the data points? (e.g., Standard Deviation, Range)
• What are the highest and lowest values? (e.g., Min, Max)

Understanding these metrics is fundamental for making informed decisions, whether you're analyzing sales figures, website traffic, or survey results.

Method 1: The Quick Way Using Individual Functions

If you only need one or two specific statistics, using Excel’s built-in formulas is the most direct approach. You just type the formula into a cell, specify your data range, and hit Enter. Let's look at the most common ones.

For these examples, let's assume your data is in cells A2 through A101.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Mean (Average)

The mean is the most common measure of central tendency. It’s the sum of all values divided by the number of values. It gives you the "average" value in your dataset.

=AVERAGE(A2:A101)

Median

The median is the middle value in a dataset that has been sorted from smallest to largest. If you have an even number of values, it's the average of the two middle values. The median is incredibly useful because it isn't skewed by unusually high or low outliers, making it a better measure of the "typical" value for things like salaries or home prices.

=MEDIAN(A2:A101)

Mode

The mode is the value that appears most frequently in your dataset. It's most helpful for categorical data or when you want to know the most common response or a popular choice.

=MODE.SNGL(A2:A101)

Note: Excel has a few MODE functions. MODE.SNGL returns the most frequently occurring value. MODE.MULT returns a vertical array of the most frequently occurring values if there’s more than one mode.

Standard Deviation

This tells you how spread out your data points are from the mean. A low standard deviation means the data points are clustered closely around the average. A high standard deviation means they are spread out over a wider range.

=STDEV.S(A2:A101)

Use STDEV.S when your data is a sample of a larger population (most common scenario). Use STDEV.P only if your data represents the entire population.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Min, Max, and Range

To find the absolute lowest and highest values in your dataset, you can use the MIN and MAX functions. The range, which is the difference between the max and min, is a simple measure of spread.

• Minimum Value: =MIN(A2:A101)
• Maximum Value: =MAX(A2:A101)
• Range (manual calculation): =MAX(A2:A101)-MIN(A2:A101)

Count and Sum

The COUNT function counts how many cells in your range contain numbers, which tells you the size of your dataset. The SUM function adds up all the values.

• Count of data points: =COUNT(A2:A101)
• Sum of all values: =SUM(A2:A101)

Method 2: The Powerhouse Approach with the Analysis ToolPak

When you need a complete overview with more advanced statistics, Excel's Analysis ToolPak is your best friend. It generates a full table of descriptive statistics with just a few clicks, saving you from typing individual formulas. It’s hidden by default, so first, you need to enable it.

How to Enable the Analysis ToolPak

You only have to do this once. After it's enabled, it will stay in your Data tab.

For Windows Users:

1. Click on File in the top-left corner, then go to Options at the bottom of the left menu.
2. In the Excel Options window, click on Add-ins.
3. At the bottom of the window, you'll see a "Manage" dropdown. Make sure it says Excel Add-ins and click Go...
4. In the new dialog box, check the box next to Analysis ToolPak and click OK.

For Mac Users:

1. Go to the Tools menu at the top of the screen.
2. Click on Excel Add-ins.
3. Check the box next to Analysis ToolPak and click OK.

You should now see a Data Analysis button on the far right of the Data tab in your Excel ribbon.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Generating a Summary Statistics Report

Now that the ToolPak is ready, you can generate your full report:

1. Navigate to the Data tab and click Data Analysis.
2. From the list in the pop-up window, select Descriptive Statistics and click OK.
3. A new configuration window will appear. Here’s how to fill it out:
4. Click OK.

Excel will instantly generate a neatly formatted table containing a full set of descriptive statistics for your data.

What Do These Stats Mean? Making Sense of the Output

The Analysis ToolPak gives you a lot of information. Here’s a quick guide to interpreting some of the most important results beyond the basics we covered earlier:

• Standard Error: This measures how accurately your sample mean represents the true population mean. A smaller standard error means the sample mean is likely closer to the actual population mean.
• Variance: This is the square of a standard deviation. It measures the average degree to which each data point differs from the mean. It’s a foundational concept in statistics, but standard deviation is usually easier to interpret because it’s in the same units as your original data.
• Skewness: This indicates the asymmetry of your data distribution.
• Kurtosis: This tells you about the "tailedness" of your distribution, or how much your data is affected by extreme outliers.

Final Thoughts

Whether you're calculating individual stats with functions like =AVERAGE() or generating a complete report with the Analysis ToolPak, Excel offers accessible tools to understand your data. Mastering both lets you choose the right approach for any task, giving you a clear picture of what the numbers are actually telling you.

While Excel is great for this kind of one-off analysis, reporting can get repetitive when you have fresh data coming in from different marketing and sales platforms. We built Graphed to automate this. Simply connect your various data sources - like Google Analytics, Salesforce, or your ad platforms - and ask for the metrics you need in plain English. Your dashboards update automatically, so you can stop manually exporting and cleaning CSVs and spend more time acting on the insights.