SheetFX
≡
<< Go back to all functions

SUMSQ

The SUMSQ function in Google Sheets returns the sum of the squares of a series of numbers and/or cells. Whether you need to calculate the sum of squared values for statistical analysis or any other purpose, the SUMSQ function simplifies the task. Take a deep dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: SUMSQ(value1, [value2, ...])

Parameters:

  • value1: The first number or range of cells whose squares you want to sum.
  • value2, ...: [Optional] Additional numbers or ranges of cells whose squares you want to sum.

Step-by-Step Tutorial

  1. Using SUMSQ with individual numbers:

    • Example: =SUMSQ(3, 4, 5)
    • Result: 50

  2. Using SUMSQ with a range of cells:

    • Example: If A1:A4 has the values 1, 2, 3, 4, then =SUMSQ(A1:A4) will return 30.

Use Cases and Scenarios

  1. Statistical Analysis: Calculate the sum of squared values for data analysis.
  2. Regression Analysis: Evaluate the sum of squared residuals for a regression model.
  3. Error Calculation: Find the sum of squared errors to assess the accuracy of a prediction.

Related Functions

  • SUM: Find the sum of a range of cells.
  • SQRT: Calculate the square root of a number.

Related Articles