How to use DEVSQ Function in Google Sheets(Quick & Easy Guide )

In this tutorial, you will learn How to use DEVSQ Function in Google Sheets

DEVSQ Function can be used in Google Sheets DEVSQ to Calculate the sum of squares of deviations which means you can return the sum of the squared deviations from the mean for a given collection of data.

Following is the Syntax for DEVSQ function

DEVSQ(value1, [value2, ...])
  • Value 1: This is the first value or range in your provided dataset
  • Value 2: This will be the second value followed by additional values in the dataset.

How to use DEVSQ Function in Google Sheets: Step by Step Guide

Enclosed are the steps to use DEVSQ function in Google Sheets for example.

Step 1: Prepare your dataset

Below is the dataset for which we will calculate the sum of squares of deviations.

Step 2: Apply the formula

Now we will use the DEVSQ function to get the result.

How to use Column and Columns Formu...
How to use Column and Columns Formula in Excel | Excel Tutorial For Beginners | Lesson - 21

Select the cell where you need to get the result and type =DEVSQ(A2:A6). You can modify the cell range as per your dataset

How to use DEVSQ Function in Google Sheets

Now press Enter and you will get the sum of squares of deviation which is 17.2 as shown below.

Following is the actual formula used by the DEVSQ function

Sum of squares of deviations = Σ(xi – x)2

  • xi: The ith  value of data
  • x: is the sample mean value

Using the above formula we can manually calculate the Sum of Squares of deviations and compare the result with our Google Sheets example result.

How to use DEVSQ Function in Google Sheets(Conclusion)

In the above tutorial, we have shown you how to use DEVSQ Function in Google Sheets to calculate the sum of squares of deviations. We hope this tutorial was useful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )