STDEVA Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft has so many programs that aid most users with various computer activities. Among all the programs of Microsoft, the most frequently used one is Microsoft Excel. It is considered as the most versatile program since it’s known to be efficient in giving solutions to some data that needs computations, organization and storing information, graphical representation and many others. Because of its versatility, it is the most preferred program by companies, businesses, professionals and students. If you want to be familiar with the use of the program, better learn and gain knowledge of the different functions of Microsoft Excel. Through these varieties of function, users could easily use the program. If you happened to be a novice in using this program, one of the functions you need to learn and understand is the STDEVA function.

What is STDEVA Function?

The function estimates the standard deviation in concurrence with the given set of numbers. On the other hand, standard deviation refers to the measurement used to find out how huge is the difference of the values from the usual value of the mean. Logical values and content are used during the computation.

What is the STDEVA Function Formula?

In Excel, formula is a very important aspect because once a correct formula is entered, an accurate result is obtained. For STDEVA function, the syntax to be used should be:

=STDEVA(value1, value2, value3,…..)


value1, value2, value3, …… — are the values from 1 up to 30 that corresponds to sample population. The arguments could be in the form of single range or a single reference to certain range rather than the values separated by a comma.

How STDEVA Function Works?

An example can help to have a better understanding about how the function works. With this, the example below could aid new users to figure out how the function works and how to use it.

Compute for standard deviation of strength of 8 tools with different strength but have undergone a similar testing process. The 8 tool strength is 2041, 1954, 1962, 2015, 1974, 1966, 1852 and 1865.

To use STDEVA function in solving the problem, follow the procedures below:

  • Enter the given data in an empty or new spreadsheet. If you happen to be a beginner of the program, you could start placing the data in column A.
  • After entering the given data, click an empty cell from the worksheet. The chosen cell is the location of the STDEVA function answer.
  • In the empty cell, enter the STDEVA syntax, which is “=STDEVA(value 1, value 2, value 3, …..)”. With this, the syntax to appear in the worksheet formula bar should be “=STDEVA(A1:A8)” or “=STDEVA(A1,A2,A3,A4,A5,A6,A7,A8)”. The values for the arguments can be supplied by clicking the reference cells that contain the numbers.
  • After placing the entire required arguments, press “Enter”.
  • The answer will immediately appear in the selected cell and it is equal to 65.70701.

If ever you did not come up with the same answer, check first the data that you have entered. If all the data entered are correctly placed in, check for the syntax because perhaps wrong values were supplied. This is usually the common mistake done by users that’s why they are not able to come up with an accurate result.

Post comment