EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Statistical Functions in Excel Excel STDEV Function

Excel STDEV Function

By Madhuri ThakurMadhuri Thakur

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 for the entire population, we have other Standard Deviation function such as STDEV.P. 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.

Start Your Free Excel Course

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

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 which are 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 would be used 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 numbers 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 about how to use STDEV, here is an overview of the statistical concepts which are used in this function. A key measure of central tendency and dispersion in statistics is Standard Deviation. The following formula calculates 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 vary from the average value. It is basically the square root of the variance. Variance is the average of the squared differences from the mean or average of a dataset.

How to Use the STDEV Function in Excel

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

  • First of all, 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 to be displayed.

How to Use STDEV 1.1

  • Now type the function and arguments in the correct syntax 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 number1 is called a mandatory argument and corresponds to a sample of the data. The number2 and other numbers are optional arguments but should correspond to a sample of the dataset to get correct results.

STDEV has a number of 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 in.

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 STDEV 1.5

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

How to Use STDEV 1.6

  • Then select the data that needs analysis.

How to Use STDEV 1.7

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

How to Use STDEV 1.8

  • And the result will be :

How to Use STDEV 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 pertaining to 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 find out 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. Logical values and text typed directly in the arguments are used in the calculation. If the logical values or text are referenced from an array or empty cells or error values in the reference, they are ignored.
  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 that 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 applications of data science without resorting to high-level programming or having an in-depth knowledge of the mathematics involved. STDEV and many other such functions make it that 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
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - 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

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
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*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?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download STDEV Function Excel Template

EDUCBA

डाउनलोड STDEV Function Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more