To calculate the sum of squares, subtract the mean from the data points, square the differences, and add them together. There are three types of sum of squares: total, residual, and regression.

1. Click the cell under a column of numbers you want to add. Or, if you want to sum a row of numbers, click the cell to the right of the series. 2. On the Home tab, click the AutoSum button (which ...