Sum of Squares Calculator

Instructions: This Sum of Squares Calculator will help you compute the sum of squares associated to a set of sample data. Please provide the information required below:

Sample Data (Space or comma separated) =
Name of the Variable (Optional) =

What is the Sum of Squares?

The concept of sum of squares is a very useful one, which appears almost everywhere in Statistics, but people do not often take the time to explain what it is. So, starting from the beginning, the sum of squares usually refers to the sum of squared deviations with respect to the mean, for a sample of data.

Mathematically, the formula to define the sum of squares associated to the sample \(\{X_1, X_2, ..., X_n \}\) is:

\[ SS = \displaystyle \sum_{i=1}^n (X_i - \bar X)^2 \]

Relationship Between Sum of Squares and Sample Variance

Why the idea of the sum of squares \((SS)\) is so useful in Statistics? Well, mostly for one reason: The sum of squares is a strong indication of the level of variability of a sample. And it is strongly related to the concept of sample variance. Indeed, the sample variance \(s^2\) is computed as:

\[s^2 = \displaystyle \frac{SS}{n-1}\]

So, you take the sum of squares \(SS\), you divide by the sample size minus 1 (\(n-1\)) and you have the sample variance. That is neato.

The idea of sum of squares also extends to linear regression, where the regression sum of squares and the residual sum of squares determines the percentage of variation that is explained by the model.

Using Excel to Compute the Sum of Squares

How to calculate sum of squares in Excel? You probably should put your data in a column and label that column as "X", then compute the average for the sample, and create of column labeled "X - Xbar" which computes the value of a corresponding cell minus the average. Then, use another column (next to the previous one) that labeled "(X - Xbar)^2", where you square the cells from the column to the left. Finally, the sum of squares is computed by adding up the values in the column. "(X - Xbar)^2".

The concept of sum of squares has applications for the t-test for one sample, for the t-test for two samples and for regression, among many others.

In case you have any suggestion, or if you would like to report a broken solver/calculator, please do not hesitate to contact us.

log in

reset password

Back to
log in