The R-squared (aka, coefficient of determination) is a goodness of fit measure. It gives the percentage of TOTAL variation that is explained by the regression line.
Here is David's XLS: https://trtl.bz/2Exyu5c
Here is David's XLS: https://trtl.bz/2Exyu5c