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 = Σ(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 :