EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Excel STDEV Function
 

Excel STDEV Function

Madhuri Thakur
Article byMadhuri Thakur

Updated August 23, 2023

STDEV function in excel

 

 

STDEV Function in Excel (Table of Contents)
  • STDEV Function in Excel
  • STDEV Formula in Excel
  • How to Use the STDEV Function in Excel?

STDEV Function in Excel

Stdev in Excel is used for calculating the standard deviation of any data set. Standard Deviation shows how one value deviates to another with how many digits. Stdev is used only for sample data, whereas we have other Standard Deviation functions such as STDEV.P for the entire population. To calculate the standard deviation of sample data, we have a new function which is STDEV.S. To calculate standard deviation, select the range of numbers.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

STDEV Formula in Excel

Below is the STDEV Formula in Excel :

STDEV formula

Examples of STDEV function in Excel

1) Let us take a look at some examples of STDEV. STDEV is widely used to measure how much the individual data elements are dispersed from the average value.

You can download this STDEV Function Excel Template here – STDEV Function Excel Template
  • For example, let’s say we have a dataset of parts for a store which is being checked for quality. We need to find the standard deviation between the number of parts we have, the number of parts to be reworked, parts that failed, the parts yet to be checked, and the total number of parts.

STDEV function example 1.1

  • The function STDEV will use like this:

STDEV function example 1.2

  • This would give us the standard deviation for values in the cells A2 till F2. Similarly, we can find out the standard deviation for others.

STDEV function example 1.3

The above data analysis means that the difference between the number of parts for each category is high. If the formula returned a lower number, it would mean that the number of parts of each category is closer. This is an important factor in many applications, such as analyzing the effectiveness of quality control measures.

2) Let’s look at another example where the STDEV function is useful.

Suppose we have weight data for a number of shipments. We want to find out how much they differ from each other.

The data is as below:

Shipment 1:  0.5kg

Shipment 2: 2 kg

Shipment 3: 0.8 kg

Shipment 4: 2.8 kg

Shipment 5: 1.1 kg

  • We put this in an Excel sheet.

STDEV function example 2.1

  • Now Use the STDEV function to get the standard deviation:

STDEV function example 2.2

  • This would give us the standard deviation in cell B7.

STDEV function example 2.3

Now we find that the standard deviation is about 0.9, which means that the weights do not vary much between the shipments. Such problems contain many more data points in real life and use more measures such as average and variance to create solutions to specific problems.

Explanation of the STDEV Function

Before we move on to learning how to use STDEV, here is an overview of the statistical concepts used in this function. A key measure of central tendency and dispersion in statistics is Standard Deviation. The following formula calculates the standard deviation:

Explanation

In this formula, one of the values (say 1,  etc.) is the mean or average of the numbers, while n is the total sample size. Standard deviation measures how widely each value in a sample varies from the average value. It is the square root of the variance. Variance is the squared differences’ average from a dataset’s mean or average.

How to Use the STDEV Function in Excel

Now that we have an overview of the statistics underlying the STDEV function in Excel, and a few examples of STDEV functions’ uses, let us look at how to use the function and the correct syntax.

  • First, we need one or more data points to choose from. Once we have done that, we need to pick a cell where we want the result displayed.

How to Use STDEV 1.1

  • Now type the function and arguments correctly and press F2 and Enter.

How to Use STDEV 1.2

  • And the result will be :

How to Use STDEV 1.3

The syntax of the STDEV function is as follows:

STDEV function

In STDEV, the number 1 is called a mandatory argument and corresponds to a sample of the data. The number 2 and other numbers are optional arguments but should correspond to a dataset sample to get correct results.

STDEV has some related functions for use with different types of datasets; the most commonly used are the following:

STDEV.S for a numeric data sample does not calculate standard deviation based on text and logical values.

STDEV.P for calculating the standard deviation for an entire population.

STDEVA for calculations based on logical values and text

We can also use the STDEV function from the formula bar, as shown below:

  • Pick a dataset and select any cell in which we would like to display the result.

How to Use STDEV 1.1

  • Go to Formulas and click on Insert Function.

How to Use STDEV 1.4

  • After clicking on the Insert Function, a pop-up window appears, and then select Statistical in the dropdown.

How to Use 1.5

  • And after selecting Statistical, select STDEV, or type STDEV in the search box and click on the go:

How to Use 1.6

  • Then select the data that needs analysis.

How to Use 1.7

  • After selecting the data, click on OK for the result:

How to Use 1.8

  • And the result will be :

How to Use 1.3

Things to Remember About the STDEV Function in Excel

We have seen a few examples of the STDEV function and have also seen how to use it in problems of data analysis in the examples; here are a few things to remember:

  1. When using STDEV, the function assumes that the sample is the entire size of the population. So when we want to determine the standard deviation from a subset of the whole data, we should use STDEV.S
  2. The standard deviation formula used in STDEV is called the (n-1) method.
  3. The arguments in STDEV can be numbers or text, arrays of different types, and references containing numbers.
  4. The calculation in STDEV uses logical values and text typed directly in the arguments. If the logical values or text are referenced from an array, empty cells, or error values in the reference, STDEV ignores them.
  5. To use logical and text values referenced from elsewhere and not typed directly in the argument, we should use the STDEVA function.
  6. Population in statistics means the entire dataset we are using. A sample is a part of the dataset which we pick to analyze.

Conclusion – STDEV Function in Excel

Data science is one of the most important areas of study currently. Excel is a tool we can use in many data science applications without resorting to high-level programming or having an in-depth knowledge of the mathematics involved. STDEV and many other such functions make it much easier for us to be data analysts. However, we need to know the basics and think about creative solutions to apply them.

Recommended Articles

This has been a guide to STDEV Function in Excel. Here we discuss the STDEV Formula in Excel and How to use the STDEV function in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. MID Function in Excel
  2. Logical Functions in Excel
  3. WEEKDAY Function Excel
  4. MAX Excel Function

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download STDEV Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download STDEV Function Excel Template

EDUCBA

डाउनलोड STDEV Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW