STDEVA
TheSTDEVA
function returns the standard deviation of a sample, including text and logical values. It is a statistical function commonly used in data analysis to measure the amount of variation or dispersion of a set of values. This function is useful when working with datasets that contain nonnumerical values.
 How to use
STDEVA
formula?  Examples of using
STDEVA
formula STDEVA
formula not working? Similar formulas to
STDEVA
Usage
Use the STDEVA
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 value1 (required):
The first value or range of cells containing values, arrays, or references to cells that contain numbers.  value2 (optional):
Additional values, ranges, or references to cells that contain numbers. Up to 254 additional arguments can be included.
Examples
Here are a few example use cases that explain how to use theSTDEVA
formula in Google Sheets.
Calculating standard deviation of a sample with text values
When working with a dataset that contains text values, the STDEVA
function can be used to calculate the standard deviation of the sample. This function includes text values in the calculation, which makes it useful when you need to analyze data that includes nonnumerical values.
Calculating standard deviation of a sample with logical values
The STDEVA
function can be used to calculate the standard deviation of a sample that includes logical values. This function treats logical values as numbers, where TRUE is equal to 1 and FALSE is equal to 0. This makes it useful when working with datasets that include logical values.
Calculating standard deviation of multiple ranges
The STDEVA
function can be used to calculate the standard deviation of multiple ranges. You can specify up to 254 ranges as arguments to the function. This makes it useful when working with large datasets that are spread across multiple ranges.
Common Mistakes
STDEVA
not working? Here are some common mistakes people make when using the STDEVA
Google Sheets Formula:
Providing nonnumeric values
If the range of cells passed to the STDEVA
function contains nonnumeric values, such as text or logical values, an error will be returned. Ensure that the values being passed to the function are all numeric.
Forgetting to include required arguments
The STDEVA
function requires at least one argument, and the first argument is required. Forgetting to include the required arguments will result in an error. Ensure that all required arguments are included in the function call.
Related Formulas
The following functions are similar to STDEVA
or are often used with it in a formula:

STDEV
The
STDEV
function calculates the standard deviation of a set of numbers. It measures the amount of variation or dispersion of a set of values from the average (mean) value. It is commonly used in statistics to determine the spread of a data set. The values can be supplied as individual cells, ranges, or constants. 
STDEVP
The
STDEVP
function calculates the standard deviation of an entire population. It is commonly used in statistical analysis to measure the amount of variation or dispersion in a set of data. This function takes in at least two numerical arguments representing the values in the population for which you want to calculate the standard deviation. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

SUM
The
SUM
function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells. 
IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions.
Learn More
You can learn more about the STDEVA
Google Sheets function on Google Support.