Learn How to Use Microsoft Excel STDEV Function

Written by | 0 Comments | 621 Views

In this article, you will learn how to use the Microsoft Excel STDEV function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel STDEV function return value and syntax with the help of some examples.

Microsoft Excel STDEV Function

The main purpose of the Microsoft Excel STDEV function is to get the standard deviation in the given sample. That implies, with the help of the STDEV function you can able to return the standard deviation for data that represents a sample. To calculate the standard deviation for an entire population, use STDEVP or STDEV.P. So, with the help of the STDEV function, you can able to get the standard deviation in the sample.

Return Value of STDEV Function

The return value will be the estimated standard deviation.

Syntax of STDEV Function

=STDEV(number1, [number2], ...)

Where the arguments:

• number1: This is the first number or reference in the sample.
• number2: This is the second number or reference in the sample (optional).

How to Use Microsoft Excel STDEV Function?

So we know that Microsoft Excel STDEV function you can able to get the standard deviation in the given sample. That implies, with the help of the STDEV function you can able to return the standard deviation for data that represents a sample. To calculate the standard deviation for an entire population, use STDEVP or STDEV.P. So, with the help of the STDEV function, you can able to get the standard deviation in the sample.