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.

To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the cell you're working with.

How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function ...