Check Sheet Logo
Check Sheet

STDEVA

The STDEVA 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 non-numerical values.

Usage

Use the STDEVA formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

=STDEVA(value1, value2)
Parameters:
  1. value1 (required):
    The first value or range of cells containing values, arrays, or references to cells that contain numbers.
  2. 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 the STDEVA 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 non-numerical 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 non-numeric values

If the range of cells passed to the STDEVA function contains non-numeric 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.