Table of Contents
The SUMSQ function in Excel is a mathematical function that allows users to calculate the sum of squares for a given set of numbers. This function is useful for performing statistical analysis and can be used to calculate the variance and standard deviation of a data set. To use the SUMSQ function, you must select a cell where you want the result to appear and then enter “=SUMSQ(” followed by the range of numbers or cells you want to calculate the sum of squares for. Pressing enter will display the result. The SUMSQ function is a valuable tool for efficiently calculating sums of squares in Excel.
Use SUMSQ in Excel (With Example)
You can use the SUMSQ function in Excel to calculate the sum of squares for a given sample.
This function uses the following basic syntax:
=SUMSQ(value1, value2, value3, ...)Here’s the formula that SUMSQ actually uses:
Sum of squares = Σxi2
where:
- Σ: A fancy symbol that means “sum”
- xi: The ith data value
The following example shows how to use this function in practice.
Example: How to Use DEVSQ in Excel
Suppose we have the following dataset in Excel
We can use the following formula to calculated the sum of squares for this dataset:
=SUMSQ(A2:A13)
The following screenshot shows how to use this formula in practice:
The sum of squares turns out to be 1,402.
We can confirm this is correct by manually calculating the sum of squares for this dataset:
- Sum of squares = Σxi2
- Sum of squares = 22 + 32 + 52 + 52 + 72 + 82 + 92 + 122 + 142 + 152 + 162 + 182
- Sum of squares = 4 + 9 + 25 + 25 + 49 + 64 + 81 + 144 + 196 + 225 + 256 + 324
- Sum of squares = 1,402
The sum of squares turns out to be 1,402.
This matches the value that we calculated using the SUMSQ function.
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How do I use the SUMSQ function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-sumsq-function-in-excel/
stats writer. "How do I use the SUMSQ function in Excel?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-sumsq-function-in-excel/.
stats writer. "How do I use the SUMSQ function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-sumsq-function-in-excel/.
stats writer (2024) 'How do I use the SUMSQ function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-sumsq-function-in-excel/.
[1] stats writer, "How do I use the SUMSQ function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the SUMSQ function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.