Statistical

DEVSQ Function in Excel

Returns the sum of squares of deviations of data points from their sample mean.

Syntax

  • =DEVSQ(number1, [number2], ...)

Arguments

  • number1 (required): First number or range
  • number2 (optional): Additional numbers

Examples

  • =DEVSQ(A1:A10) - Sum of squared deviations - Result: SS value

DEVSQ for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • Ignores text and logical values

Use cases

  • Variance calculation
  • Statistics
  • Quality control

Frequently asked questions

  • What is the DEVSQ function in Excel? DEVSQ returns the sum of squares of deviations of data points from their sample mean. The syntax is =DEVSQ(number1, [number2], ...). Typical use cases include variance calculation, statistics, quality control.
  • How do I use the DEVSQ function? To use DEVSQ, type =DEVSQ( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does DEVSQ work with? DEVSQ works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is DEVSQ not working in my Excel? Common issues with DEVSQ include Ignores text and logical values. Start by checking the syntax =DEVSQ(number1, [number2], ...), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.