DEVSQ

Formulas / DEVSQ
Calculate the sum of squared deviations from the mean.
=DEVSQ(array)
  • The DEVSQ function arguments are 1 to 255
  • The arguments can be an array or a reference to an array
  • The arguments are separated by commas
  • The arguments are limited to 30 in Excel 2003

Examples

  • =DEVSQ(A2:A8,"sample")

    The DEVSQ function takes two arguments: a range of cells and a text value. For example, this formula will return the sum of squares of deviations of data from their sample mean.

  • =DEVSQ(A2)

    The DEVSQ function can also take a single cell as an argument. For instance, this formula will calculate the sum of squares of deviations of data from the mean of the cell A2.

  • =DEVSQ(A2:A8,B2:B8)

    You can use the DEVSQ function to compare the mean of data in two different cells. For example, this formula will return the sum of squares of deviations of data from their mean in cell B2:B8.

  • =DEVSQ(A2:A8)

    The DEVSQ function can also be used to calculate the sum of squares of deviations for a group of data with a single argument. For example, this formula will return the sum of squares of deviations of data from their mean.


Summary

The DEVSQ function calculates the sum of squares of deviations of data points from their sample mean. It takes multiple arguments, with the first one being required. It can use numbers, words, arrays, or references as arguments and ignores error values and text inputs.

  • The DEVSQ function takes multiple arguments, which can be a hardcoded value, a cell reference, or a range.
  • The DEVSQ function calculates the sum of the squared deviations from the mean for a set of data.

Frequently Asked Questions

DEVSQ Function FAQs

What is the DEVSQ function?
The DEVSQ function is a statistical function used to calculate the sum of squares of deviations of data points from their sample mean.
What kind of arguments can I use with the DEVSQ function?
You can use the following arguments with the DEVSQ function:
  • Numbers
  • Names
  • Arrays
  • References
Do the DEVSQ function arguments have to be numbers?
Yes, all of the arguments must contain numbers.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV