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.

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

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 = Σ(x_{i} – x)^{2}

**x**: The i_{i}^{th}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 )