In this tutorial you will learn How to use SUMSQ Function in Google Sheets
You can use SUMSQ math Function to calculate the sum of squares of a set of numbers cells.
SUMSQ function Syntax
Syntax SUMSQ(value1, [value2, ...])
- Value 1 will be the first number or range whose squares to add together.
- Value 2 will be the Additional numbers or ranges whose squares should be added to the value1 square(s).
How to use SUMSQ Function in Google Sheets : Step by Step Guide
Encosed are the steps to use SUMSQ function.
In the below example we will show How to use SUMSQ Function
Step 1 : Prepare your dataset in Google Sheet
Assume we have the following dataset in Google Sheet for which we need to calculate the sum of sqaures
Step 2 : Use the SUMSQ function
To calculate the sum of squares for the above dataset we can use the below formula
Use the above provided formula and customize it as per your dataset .
For the provided example we have used the formula =SUMSQ(A2:A8) on Cell B2.
Press enter and the sum of squares will be returned for the provided dataset
Sum of Squares is returned to be 2336
We can verify the above result with a manual calculation of sum of squares as shown below :
- Sum of squares = Σxi2
- Sum of squares = 102 + 52 + 152 + 62 + 102 + 252 + 352
- Sum of squares = 100 + 25 + 225 + 36 + 100+ 625 +1225
- Sum of squares = 2336
The manual calculation result matches with the SUMSQ function result which is 2336
How to use SUMSQ Function in Google Sheets(Conclusion)
In the above tutorial we have shown you an example on How to use SUMSQ Function in Google Sheets .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 Transpose Data in Google Sheets